Course Objectives

==== Lesson 1 (1h 30min) 1) Getting started with Excel (20 min) - What is Excel and where it can be used? - Basic examples of excel uses in the industry. - Introduction to Excel tabs and toolbar - What is a sheet and how to make one? 2) Putting data into Excel (45 min) - How to put data into excel? - Tips and tricks when adding data - Formatting your data - Structuring your data - Difference between string and numbers, and other number types 3) Working with datasets (25 min) - Copy and pasting the data - Data Cleansing - Data Structuring - Using filters ==== Lesson 2 (1h 30 min) 1) Basic Operations in Excel (20 min) - Arithmetics operations - Geometric operations - Exponentials - Mathematical Formulas 2) Conditional Formatting (15 min) - What it is and how does it work? - In built operations in excel? - Creating user-defined conditional formatting. 3) Writing Formulas (15 min) - What is a formula in excel? - How to write a formula in excel? 4) Making Graphs (20 min) - The graphs in excel - Examples of the graphs - Formatting the graphs - Changing colours and adding text 5) VBA Coding (20 min) - What is VBA coding? - Why do you need VBA coding? - Difference between VBA coding and excel formulas? - Benefits and Disadvantages of using VBA coding - Example case

Cancellation Policy

If you can not attend the course, then make sure to let us know at least 2 business days before the start date.

Contact Details