Microsoft Excel – Advanced
Turn unorganized data into useful information and quickly make spreadsheets your friends. Train IT Midlands’s lets people of any technical level learn exactly what they need to know at their own pace. The course starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.
Notes:
• All lessons are bite-sized and self-contained, so you can select only what you need.
• Features matching content with Interactive Online Learning and Skills Assessments.
Working with PivotTables
Working with PivotTables
Creating a PivotTable
Specifying PivotTable Data
Changing a PivotTable’s Calculation
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart
Using Slicers
Sharing Slicers Between PivotTables
Analyzing Data
Analyzing Data
Creating Scenarios
Creating a Scenario Report
Working with Data Tables
Using Goal Seek
Using Solver
Using Text to Columns
Grouping and Outlining Data
Using Subtotals
Consolidating Data by Position or Category
Consolidating Data Using Formulas
Working with the Web and External Data
Working with the Web and External Data
Inserting a Hyperlink
Importing Data from an Access Database or Text File
Importing Data from the Web and Other Sources
Working with Existing Data Connections
Working with Macros
Working with Macros
Recording a Macro
Playing and Deleting a Macro
Adding a Macro to the Quick Access Toolbar
Editing a Macro’s Visual Basic Code
Inserting Copied Code in a Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If…Then…Else Statement
Customizing Excel
Customizing Excel
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel’s Default Options
Creating a Custom AutoFill List
Creating a Custom Number Format
