Event Details

Overview

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 students 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. Plus, you will be able to learn pivot table.


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 PivotTable data

• Formatting PivotTables

• Using Pivot Charts




Menu