Microsoft Excel Advanced
Gain advanced Microsoft Excel skills to analyze and report on data, collaborate with team members, and maintain workbooks effectively for various purposes. With automation techniques, you'll save time and increase productivity, while using conditional logic to construct and apply formulas and functions. Our course will equip you with the tools necessary to manipulate vast amounts of data, uncover valuable insights, and drive organizational growth. Invest in your professional development and stay ahead of the curve with our advanced Excel course.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
Our advanced Microsoft Excel course offers an opportunity to unlock Excel’s full potential. Gain skills to analyze and report on data with ease, collaborate with team members, and maintain workbooks for various purposes. With automation techniques, you’ll be able to handle complex and repetitive tasks while using conditional logic to construct and apply formulas and functions.
Our course equips you with the tools necessary to manage and maintain workbooks effectively for all business needs, boosting productivity and saving time. The advanced skills you’ll gain will allow you to manipulate vast amounts of data, uncover valuable insights, and drive organizational growth.
Invest in your professional development and stay ahead of the curve with our advanced Excel course. Don’t miss out on this opportunity to gain the skills and knowledge needed to succeed in today’s fast-paced business world. Join us today and start unlocking the full potential of Excel!
Who should attend?
Designed for experienced Excel 2016 users seeking to advance their skills in advanced features.
Learning Outcome
Upon the successful completion of this course,
- you will have the ability to analyze data at an advanced level, collaborate seamlessly with other users on workbooks, and automate workbook functionality.
Prerequisites
In order to guarantee success, students should have practical experience in creating and analyzing datasets using Excel 2016. Essential tasks include creating formulas, utilizing Excel functions, sorting and filtering data, creating basic charts, working with PivotTables and PivotCharts, and customizing the Excel environment.
To meet these prerequisites, students can complete Microsoft® Office Excel® 2016 Level 1 / Intro and Excel Level 2 / Intermediate courses.
Course Content
Module 1: Enhancing Workbooks
- Customize Workbooks
- Comments
- Hyperlinks
- Watermarks
- Background Pictures
- Manage Themes
- About Themes
- Customizing Themes
- Create and Use Templates
- Templates
- Template Types
- Creating a Template
- Modifying a Template
- Protect Files
- Recovering Lost Data
- The Changes Group
- Worksheet and Workbook Protection
- The Protect Worksheet Option
- The Protect Workbook Option
- Preparing a Workbook for Multiple Audiences
- Displaying Data in Multiple International Formats
- Utilize International Symbols
- Modifying Worksheets Using the Accessibility Checker
- Managing Fonts
Module 2: Auditing Worksheets
- Trace Cells
- The Trace Cells Feature
- Tracer Arrows
- Troubleshoot Invalid Data and Formula Errors
- Invalid Data
- The Error Checking Command
- Error Types
- Watch and Evaluate Formulas
- The Watch Window
- Formula Evaluation
- Create a Data List Outline
- Outlines
- The Outline Group
Module 3: Working with Multiple Workbooks
- Consolidate Data
- Data Consolidation
- The Consolidate Dialog Box
- Consolidation Functions
- Link Cells in Different Workbooks
- External References
- Merge Workbooks
- The Compare and Merge Workbooks Feature
Module 4: Exporting Excel Data
- Export Excel Data
- The Export Process
- Import a Delimited Text File
- The Import Process
- The Get External Data Group
- Delimited Text Files
- Methods of Importing Text Files
- Integrate Excel Data with the Web
- The File Publishing Process
- Publish as Web Page Dialog Box
- Create a Web Query
- Web Queries
- The New Web Query Dialog Box
Module 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- PivotTables
- Start with Questions, End with Structure
- The Create PivotTable Dialog Box
- The PivotTable Fields Pane
- Summarize Data in a PivotTable
- The “Show Values As” Functionality of a PivotTable
- External Data
- PowerPivot
- PowerPivot Functions
- Filter Data by Using Slicers
- Slicers
- The Insert Slicers Dialog Box
- Analyze Data with PivotCharts
- PivotCharts
- Creating PivotCharts
- Applying a Style to a PivotChart
Module 6: Automating Worksheet Functionality
- Update Workbook Properties
- Workbook Properties
- Create and Edit a Macro
- Macros
- The Record Macro Dialog Box
- Naming Macros
- Visual Basic for Applications
- Copying Macros Between Workbooks
- Macro Security Settings
- Apply Conditional Formatting
- Conditional Formatting
- Conditional Formats
- The Conditional Formatting Rules Manager Dialog Box
- The New Formatting Rule Dialog Box
- Clear Rules
- Add Data Validation Criteria
- Data Validation
- The Data Validation Dialog Box
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.