Microsoft Excel Training Class - Introduction

Microsoft Excel Training Class Topics Covered Topics generally covered in the Microsoft Excel course include the following. Course content may be adapted based upon the needs of the specific class. Getting Started with Excel Getting to know the workspace Getting to know the cell pointer Using the Ribbon Exploring the Status bar Using the Quick Access toolbar Using the Formula bar Moving around the worksheet Exploring what’s new in Excel 2013 Creating an Excel Worksheet Entering data in a cell Working with cell ranges Saving and opening workbooks Editing data, and using undo and redo Working with rows and columns Creating additional worksheets Printing worksheets and workbooks Formatting a Worksheet in Excel Understanding cell formats Changing number formats Changing the font and font size Modifying row heights and column widths Cell alignment and cell styles Borders and shading Copying cell formats Using conditional formatting Using page themes Using Formulas in Excel Entering simple formulas Referencing cells from other worksheets or workbooks Using functions and the function Library Using the AutoSum tool Using common functions Working with ranges Copying formulas Formula auditing Working with Charts in Excel Understanding chart types Creating moving, and resizing, a chart Understanding chart elements Using chart recommendations Customizing the chart Printing a chart Using Sparklines Working with Data in Excel Working with lists Creating a list Sorting records Filtering records Searching records Deleting records Removing duplicates Extracting records Subtotaling data Grouping records Using data validation Converting text to columns Using Flash Fill Working with Excel Templates Working with templates Saving a workbook as a template Opening a custom template Protecting workbooks and worksheets Unlocking cells in a protected worksheet Hide and protect formulas Searching for templates Advanced Data Analysis in Excel Introduction to PivotTables Creating a PivotTable Rearranging a PivotTable Removing fields from a PivotTable Formatting a PivotTable Editing and updating a PivotTable Changing the calculation Hiding and showing data in a PivotTable Adding subtotals to a PivotTable Using recommended PivotTables Working with PivotCharts Working with tables What-If analysis