Service Description

This will be a 60-minute introduction with Excel basics. My goal is to ensure you feel comfortable with using Excel's Pivot Table functions. I will instruct from Excel 2016 but most of what I cover can be used in previous versions. This session will be a live interactive 1-on-1 session where you'll connect to my online classroom. Instructions on how to connect will be sent to your email after registration completion. The following will be covered in your session: Excel Tables: Creating an Excel Table Adding or Deleting a Table Row or Column Turning On/Off the Total Row Removing Duplicates Converting a Table to a List Range Using Table Specifiers in Formulas Sorting & Filtering a Table or List Range: Using a List Range Sorting Complex Sorting Filtering and Advanced Filtering Filtering with AutoFilter Using Advanced Filters Selecting/Ordering Advanced Filter Columns. Clearing Filtering Showing/Hiding AutoFilter Grouping and Subtotaling List Data Creating a PivotTable or PivotChart from Worksheet Data Show/Hide the PivotTable Fields Pane Adding/Removing a PivotTable Field Refreshing a PivotTable Rearranging a PivotTable Adding a PivotChart to an Existing PivotTable Changing the Summary Function Changing How Values are Shown Sorting and Filtering a PivotTable Filtering with Timelines and Slicers. Using a PivotTable to Analyze Multiple Data Sources Adding Excel Workbook Tables