•          Actionable insight to improve your aptitude within Excel

•          Applicable information throughout every industry

•          Lessons to improve your organization, decision-making, visualization, and     problem-  solving skills.

•          Course certificate to boost your marketability

Day 1

 Managing Rows & Columns

·      
Inserting, Moving & Deleting Cells

·      
Managing Columns and Rows

·      
Hide and Unhide Rows & Columns

·      
Changing Column Width & Row Height

Managing Worksheets

·      
Format Worksheet Tabs

·      
Insert and Delete Worksheet

·      
Move and Copy Worksheet

·      
Hide & Unhide Worksheet

Formatting Cells

·      
Formatting the Cell

·      
Number and Date Formatting

·      
Finding and Replacing Text 

·      
Working with Styles

Advanced Formatting

·       Considerations in Designing a Spreadsheet

·       Working with Cell Styles & Document Themes

·       Apply, Create & Manage Conditional Formatting

·       Creating a Custom Number Format 

Working with Tables

·       Create a Table & Use of Total Row

·       Sorting & Filtering a Table

·       Formatting the Table 

Advanced Functions and Formulas

·       Formulas with Multiple Operators

·       Using and Managing Defined Names

·       Using Mixed Cell Referencing

·       Date and Time Functions

·       Using Logical Functions (IF, AND and OR), Sum, Sumif.

·       Using Lookup Functions

·       Mathematical and Statistical Functions

·       Using Financial, Text & Database Functions

·       Using 3D Reference within SUM Function 

Day 2

Validating Data and Auditing Worksheets

·       Using Data Validation

·       Auditing Tools

·       Displaying and Tracing Formulas

·       Understanding Formula Errors

Managing Charts 

·        Data Visually Using Charts

·       Customizing Chart Data

·       Format Chart Legend and Titles

·       Change the Chart Body

·       Saving the Chart as a Template

·       Creating a Pie Chart

·       Using Chart Titles & Placing Chart

Working with Data Ranges

·       Sorting by One Column

·       Sorting by Multiple Columns

·       Filtering Data

·       Using Advanced Filter

Working with PivotTables

·       Creating a PivotTable

·       Specifying PivotTable Data

·       Changing a PivotTable’s Calculation

·       Filtering and Sorting a PivotTable

·       Working with PivotTable Layout

·       Grouping PivotTable Items

·       Updating & Formatting a PivotTable

·       Creating a PivotChart

Linking and Importing Data

·       Inserting a Hyperlink

·       Linking Data & Managing External Links

·       Importing Data

·       Working with Existing Data Connections

Managing Collaborative Editing

·       Working with Comments to Cells

·       Tracking Changes

·       Protecting Worksheets & Worksheet Elements

·       Protecting a Workbook