Learn beyond the normal bars and graphs so that your reports will be easier to understand.

Microsoft Excel is one of the most powerful and useful business programs. It is used by millions of businesses globally primarily because it is effective and can be used by every industry there is.


In this 2-day hands-on workshop, the participants will be able to appreciate the Excel environment and its tools; execute advance functions of Excel; create business systems such time management; sales tracking and analysis and more. In addition, participants will be able to learn pivot table.

TARGET AUDIENCE: Finance, Marketing, Operations and HR professionals who are tasked to create and generate reports.


TOPICS COVERED:

• Excel Interface

• Excel Functions

• Encoding & Editing

• Creating & Saving

• Keyboard Shortcuts

• Charts

• Creating and using names

• Managing names

• Validating cell entries

• Advanced filtering

• Conditional formatting

• Outlining and consolidating data

• Creating subtotals

• PivotTables and Pivot Charts

• Working with PivotTables

• Modifying Pivot Table data

• Formatting PivotTables

• Using Pivot Charts


Note: Pre-work assessment Included. This workshop includes an online Training Needs Analysis (TNA) to know how to effectively put the participants to the right level of Excel.

Tickets