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.

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 daily.

• 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 Assessmenta