Arise SLG

Data Training Institute

Microsoft Excel Level 3 (Advanced)

Live & online$300
Microsoft Excel Level 3 (Advanced)

About This Course

Master advanced Excel techniques in this Level 3 course, covering topics like pivot tables, advanced formulas, and automation with macros. This course is designed for experienced Excel users looking to optimize their data analysis and reporting capabilities.

What You'll Learn

  • Gain expertise in creating and managing pivot tables for enhanced data analysis.
  • Learn to apply advanced formulas to streamline complex calculations.
  • Discover how to automate tasks and reports using Excel macros.

Course Content

7 sections · taught live, step by step

1

Section 1: Enhancing Workbooks

  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Add Alternative Text to Objects
  • Modify Worksheets Using the Accessibility Checker
  • Manage Fonts
  • Create a Template
  • Modify a Template
2

Section 2: Working with Multiple Workbooks

  • Data Consolidation
  • The Consolidate Dialog Box
  • Consolidation Functions
  • Understand External References
  • Link Individual Cells
  • Link Groups of Cells
  • The Compare and Merge Workbooks Feature
  • Removing Duplicates
  • Transposing Data
3

Section 3: Protecting Workbooks and Worksheets

  • Protecting a Workbook
  • Protecting a Worksheet
  • Unprotecting Workbooks and Worksheets
4

Section 4: Outlining, Grouping, and Subtotalling

  • Grouping & Outlining
  • Subtotalling
5

Section 5: Importing and Exporting Excel Data

  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files
  • The File Publishing Process
  • Publish as Web Page Dialog Box
  • Web Queries
  • The New Web Query Dialog Box
6

Section 6: Analyzing Data with Pivot Tables, Slicers, and Pivot Charts

  • Pivot Tables
  • The Create Pivot Table Dialog Box
  • The Pivot Table Fields Pane
  • Summarize Data in a Pivot Table
  • The “Show Values As” Functionality of a Pivot Table
  • Create a Calculated Field
  • Refresh the Pivot Table Data
  • Add Style to a Pivot Table
  • Work with Subtotals and Grand Totals
  • Introduction to PowerPivot
  • Use the Field Headers
  • Use the Pivot Table Dialog Box
  • Use Slicers
  • Create Pivot Charts
  • Filter with Pivot Charts
7

Section 7: Automating Worksheet Functionality

  • What Are Macros?
  • The Record Macro Dialog Box
  • Name Macros
  • Visual Basic for Application
  • Copying Macros Between Workbooks
  • Macro Security Settings
  • Difference Between a Relative and Absolute Macro
  • What Is Conditional Formatting?
  • The Conditional Formatting Rules Manager Dialog Box
  • Clear Rules
  • Data Validation
  • The Data Validation Dialog Box

Not sure this course is the right fit?

Tell us your goals and we'll recommend the right learning path — or build a custom corporate training for your team.

Talk To Us