Microsoft Excel Level 2

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 .