Advanced Microsoft Excel III: Import and export data, remove duplicates and use data validation, and analyze data using filters and pivot tables.
Advanced Microsoft Excel II: Use range names and 3-D references in formulas; learn to use financial, logical and date functions; troubleshoot formulas and functions with auditing tools, use Goal Seek and Scenarios.
Students should have taken all previous Excel classes or be familiar with the skills covered.
Advanced Microsoft Excel I: Customize Excel 2007's Quick Access Toolbar, customize and manage your worksheets and workbooks, use custom number formats and conditional formatting.
Students must have taken the Basic Excel series or be familiar with formulas, functions and formatting in Excel.
Download handouts and practice problem files below. If files fail to download properly, try a different browser (Internet Explorer, Firefox).
Microsoft Excel IV - Charts/Graphs: Explore Excel’s chart-making abilities. Create several types of charts, format charts, enhance and control axes, scales, labels.
Microsoft Excel III - Formatting and Printing: Format Excel spreadsheets, control how numbers display, add colors and borders, use conditional formatting; learn printing, control page divisions, print row and column headers, and more.
Microsoft Excel II - Formulas and Functions: Learn to do basic mathematical calculations with Excel.
Microsoft Excel I - Introduction and Data Entry: Learn to start Excel, save and open spreadsheets, copy and paste cells, select and insert rows and columns, and type text and numbers.