Microsoft Excel Advanced Bootcamp

Microsoft Excel is essential, a highly sought after skill in various sectors. It is a flexible and powerful tool for managing, organizing, manipulating and exploring data through tables, charts, equations and graphs. 

Gaining insight into Microsoft Excel Advanced capabilities through a bootcamp has many advantages. You will become knowledgeable in the concepts of the advanced features thereby sharpening your skillset. With these skills you will complete your work much quicker by doing away with repetitive tasks and performing automation to process large volumes of data. This will allow you to streamline your workflow in a much better way. You will be able to make use of these advanced tools to organise information that can be easily analysed. This results in a huge improvement on your efficiency and productivity.  

The Microsoft Excel Advanced Bootcamp is ideal for anyone who already has a basic understanding of Excel and wants to improve their skills in working with more complex Excel features.  The course covers topics such as collaborating with other people, managing and formatting data, validating data, using advanced formulas and using PIVOT tables. The course can be beneficial for individuals who wish to improve their ability to work with complex workbooks, construct complex Excel functions as well as work with others on their spreadsheets. 

Prerequisites: 

• Proficient in written and spoken English. 

• Basic understanding of MS Excel. 

Duration: 1 Day

Day 1

• Collaborate with other people 

• Managing rules and customising formats 

• Understanding conditional formatting rules 

• Using logical, statistical and mathematical functions 

• Using lookup functions and external features 

• Using date and time functions 

• Validating data 

• Using Pivot Tables 

After completing this module, you will be able to: 

• Use tools to collaborate with others, restrict editing in workbooks, and manage workbook versions. 

• Manage and format data, including understanding conditional formatting, managing rules and customizing formats. 

• Create advanced formulas using logical, statistical, mathematical, lookup, date and time functions, and external references. 

• Validate and fill cells, audit formulas, and evaluate data. 

• Create and use Pivot Tables.  

No Exam

Duration: N/A

No Certification Course Completion Confirmation

• Virtual training: Trainer delivers the training using virtual streaming technology. 

• In-class training: Laptop will be provided (Delegates are welcome to make use of their laptops). Lunch and refreshments and training manuals will be provided.