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: –
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