Basic Excel for Professional and Business Analysis

Why Attend

This Basic Excel course will provide learners with a core understanding of how to effectively
operate and use the Excel spreadsheet software at an advanced level. Whether you need to
learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this
Excel Advanced course is perfect.

Event Date: –

Request an In-House Proposal

Download 2024 Training Calendar

Overview
Course Outline

Course Methodology
20% of the course is theory focused while 80% uses MS Excel as a powerful tool to perform daily,
monthly and periodic tasks. Groups and individuals will be required to complete exercises, case
studies, and projects on a daily basis.

 Introduction to Spreadsheets
 Understanding Microsoft Excel
 Excel Workbook Windows
 Basic Spreadsheet Skills
 Excel Help System
 Opening and Closing Workbooks
 Understanding Workbook File Formats
 Creating New Workbooks
 Selecting Cells
 Auto Sum and Auto Fill Function
 Cell Referencing and Request
 Formatting Cells
 Formatting Numbers
 Placing Cell Alignment
 Cell, Rows and Columns
 Understanding Worksheets
 Editing, Copying and Moving Cells
 Page Layouts in Excel
 Proofing Workbooks
 Basic Options, Ribbons and Toolbar
 Final Assessment