Though many professionals use Excel on a daily basis, Excel has many undiscovered functions that can increase productivity even further. In this course, we will explore one of the relatively new tools brought by Excel to help professionals in cleaning up and preparing data for further analysis and reporting.
In addition, we will cover many features of pivot tables which is the main reporting tool in Excel. We will also take a look at PowerPivots, another powerful tool in Excel which will put your pivot tables on turbo. While pivot tables have some limitations, PowerPivots can be used when you have significantly big data. The last part of the course is dedicated to automating your Excel reports and reconciliation through the use of macros.

Topic 1: Getting Started:

– Navigate the Excel User interface

– Use Excel Commands

– Create and save a basic Workbook.

– Enter Cell Data

– Use Excel Help.

Topic 2: Performing Calculations:

– Create worksheet formulas

– Insert functions

– Reuse Formulas and Functions

Topic 3: Modifying a worksheet:

– Insert, Delete and Adjust Cells, Columns and Rows.

– Search for and Replace data.

– Use proofing and research tools.

Topic 4: Formatting a Worksheet: Apply text and Number Formats.

– Align cell Contents.

– Apply Styles and themes.

– Apply basic conditional formatting.

– create and use templates.

Topic 5: Printing Workbooks:

– Preview and print a workbook.

– Set up the page layout.

– Configure Headers & Footers.

Topic 6: Managing Workbooks:

– Manage Worksheets.

– Manage Workbook and Worksheet Views.

– Manage workbook properties.

Topic 7: Working with Multiple Workbooks and Worksheets:

– Use links and external references.

– Use 3-D references.

– Consolidate Data.

Topic 8: Using Lookup Formulas and Formula Auditing:

– Use lookup functions.

– Trace cells.

– Watch and evaluate formulas.

Topic 9: Sharing and protecting workbooks:

– Collaborate on a workbook.

– Protect worksheets and workbooks.

Topic 10: Forecasting Data:

– Determine potential outcomes using data tables.

– Determines potential outcomes using scenarios.

– Use the goal seek feature.

– Forecasting Data trends.