On this intermediate course you will learn to manipulate data using sorting and filtering, conditional formatting, PivotTables and advanced charting. You will share data across multiple workbooks, add graphics and learn to collaborate with others.
- You will be learning Microsoft Excel from a live instructor.
- They will teach you step-by-step how to master Excel, using demonstrations, hands-on exercises and one-on-one help.
- Suitable for Excel 2016, 2019 & 365 users.
Managing Workbooks
- Inserting and Deleting Worksheets
- Rearranging Worksheets
- Adding Hyperlinks
- Linking to other Workbooks
- Customizing Excel
- Using Names in Formulas
- Other ways to use Named Ranges
- Naming Shortcuts
- Managing Named Ranges
- Sorting Data
- Custom Sorts
- Filtering Tables
- Using Auto-Filter
- Removing Duplicate Rows
- Working with Structured References
- Data Validation
- Transposing Rows and Columns
- Consolidating Data
- Using Sub-totals
- About PivotTables
- Creating PivotTables
- Formatting PivotTables
- Manipulating PivotTables
- Viewing Subsets of PivotTable Data
- Adding Slicers
- Creating PivotCharts
- Conditional Formatting
- Graphical Conditional Formatting
- Custom Formats
- Adding Graphics
- Adding Smart Art
- Special Chart Types
- Inserting Trendlines
- Combination Charts
- Chart Templates
- Inserting Sparklines
- Quick Analysis Options
- Controlling Access with Permissions
- Protecting and Securing Workbooks
- Shared Workbooks
- Adding Comments
- Tracking Changes
- Merging Shared Workbooks
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
