This hands-on intermediate class is suitable for Excel 2010/2013/2016 users.
You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.
Live face-to-face instructor. No minimum class size - all classes guaranteed to run!
You should have completed our Introduction class or have the equivalent experience prior to attending this course.
Course Outline
Managing Workbooks
Inserting and Deleting Worksheets
Rearranging Worksheets
Adding Hyperlinks
Linking to other Workbooks
Customizing Excel
Named Ranges
Using Names in Formulas
Other ways to use Named Ranges
Naming Shortcuts
Managing Named Ranges
Filtering and Sorting Data Tables
Sorting Data
Custom Sorts
Filtering Tables
Using Auto-Filter
Removing Duplicate Rows
Working with Structured References
Data Validation
Transposing Rows and Columns
Summarizing Data
Consolidating Data
Using Sub-totals
PivotTables
About PivotTables
Creating PivotTables
Formatting PivotTables
Manipulating PivotTables
Viewing Subsets of PivotTable Data
Adding Slicers
Creating PivotCharts
Presentation Features
Conditional Formatting
Graphical Conditional Formatting
Custom Formats
Adding Graphics
Adding Smart Art
Advanced Charts
Special Chart Types
Inserting Trendlines
Combination Charts
Chart Templates
Inserting Sparklines
Quick Analysis Options
Collaboration
Controlling Access with Permissions
Protecting and Securing Workbooks
Shared Workbooks
Adding Comments
Tracking Changes
Merging Shared Workbooks
Still have questions?
Ask the community
.