Course Details

Course content:

• Understanding the Microsoft Excel Interface
• Working with Workbooks and Templates
• Working with Sheets
• Getting Data onto a Sheet
• Selecting and Moving Data on a Sheet
• Formatting Sheets and Cells
• Advanced Formatting
• Using Formulas
• Using Functions
• Sorting Data
• Filtering and Consolidating Data
• Distributing and Printing a Workbook
• Inserting Subtotals and Grouping Data
• Creating Charts and Sparklines
• Summarizing Data with PivotTables
• Inserting SmartArt, WordArt, and Pictures
• Introducing the Excel Web App