Expand your knowledge of Excel with this half-day course. After a review of the basics, you’ll learn how
to use absolute and relative cell addresses and how to name ranges for more advanced spreadsheet
You'll learn how to build complex spreadsheets and you'll practice running statistical,
financial, logical, and database functions on data. You’ll also see how advanced formatting techniques
can vary your data displays. You’ll also learn how to use spreadsheet tabs to create multi-page
spreadsheets, and formulas that span several worksheets.
You’ll practice linking data to other
spreadsheets, as well as other workbooks. You’ll practice using the new Quick Analysis Tool to quickly
create charts, formulas, tables and Sparklines. Finally, you’ll learn to create and use Excel templates to
automate the creation of new spreadsheets.
Prerequisites: Introduction to Excel or equivalent experience.
for a downloadable pdf document of the class outline.