IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > MS Excel Training Course Online
MS Excel Training Course Online by Upskillist
Learn how to use Excel functions and create dynamic formulas to generate datasets and data visualisations in this online certification and excel training course.
Course Highlights
- Basic data analysis techniques using tools and functions such as slicers and pivot tables
- How to ensure data integrity by applying structured references, creating input sheets and error checking
- How to present and format your data using spreadsheets, graphs and charts
- How to navigate and utilise multiple sheets, workbooks and printing options using keyboard shortcuts
- Create templates, custom lists, macros and basic VBA techniques
Skills you will learn!
Curriculum
10 Topics
Setting the Stage
Blank Canvas
Sheets Tables and Things
Keep Organised
Code of Conduct
Lights Camera Action!
Getting Into Shape
Keep it Clean
Creating Footprints
A Helping Hand
10 Topics
Setting the stage
The blank canvas
Sheets tables and things
Keep organised
The code of conduct
Lights camera action!
Getting into shape
Keep it clean
Creating footprints
A helping hand
8 Topics
More Functions and Formulae
Automating Your Work with Macros
Importing Data
Working with Tables
Creating and Formatting Data
Creating and Formatting Content
Thesaurus and Research
Validating Data
9 Topics
Importing Data into Excel
Advanced Tables
Analysing Data with Automated Tools
Analysing Data with Scenarios
Using Pivot Tables and Pivot Charts
Analysing Data with Functions
Protecting Cells Sheets and Workbooks
Collaborating with Others
Managing Data and Workbooks
MS Excel Training Course Online
Related Excel Courses
Thank You!
Your review has been submitted successfully.