Corporate Frontier Services

MICROSOFT EXCEL – ADVANCED LEVEL

INTRODUCTION

Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.

This course introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables.

In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek to analyse data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, and create and use macros. 

This Course Include

CONTACT INFORMATION

COURSE OBJECTIVES

  • Functions & formulas
  • Database Management
  • Pivot Tables & Charts
  • Learn Conditional Formatting, Data Validation
  • Audit worksheets
  • Analyse and present Data through Sparklines
  • Create Dashboard Report