Classes
Module 1: Introduction to Excel
Module 2: Basic Formulas and Functions
Module 3: Formatting and Customization
Module 4: Managing Worksheets
Module 5: Data Handling and Analysis
Module 6: Basic Charts and Graphs
Module 7: Computational Thinking
Module 8: Automation
Module 9: Visual Basic for Applications (VBA)
-
9.1 An introduction to Visual Basic for Applications (VBA)
-
9.2 The different types of programming structures
-
9.3 The macro recorder versus manually generating the VBA
-
9.4 Coding best practices
-
9.5 Variables
-
9.6 Assigning VBA to a button or an icon
-
9.7 Coding errors in VBA and how to resolve them
-
9.8 Debugging your code
-
9.9 Function procedures
-
9.10 Determining the last row using VBA
Module 10: VBA - Selection and loop programming structures
Module 11: Data Analytics
-
11.1 Introduction
-
11.2 The world of data
-
11.3 Data analytics for accounting and related services
-
11.4 The data analytics process
-
11.5 Step one: Identify the questions
-
11.6 Step two: Master the data
-
11.7 Step three: Perform test plan
-
11.8 Step four: Address and refine results
-
11.9 Step five: Communicate insights
-
11.10 Step six: Track outcomes
Module 12: Dashboards
-
1. Introduction
-
2. What is a dashboard?
-
3. The dashboard design process
-
4. Dashboard best practices
-
5. Excel functions to assist in automating your dashboard
-
6. Other useful Excel features in creating your dashboard
-
7. Adding interactive controls to your dashboard
-
8. Important considerations in designing and developing your dashboard
Module 13: Emerging technologies
Module 14: Cyber security
