This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
AIN3701 - Automation and data analysis
Classes
1. Assignment two
2. Assignment three (Introduction to dashboards)
3. Assignment three: Dashboards
4. Exam preparation: Assignment 2
5. Assignment 3 Additional notes
Module 1: Introduction to Excel
1. Overview of Excel
2. Basic Excel Functions
Module 2: Basic Formulas and Functions
1. Basic Arithmetic Operations
2. Common Functions
Module 3: Formatting and Customization
1. Cell Formatting
2. Conditional Formatting
Module 4: Managing Worksheets
1. Worksheet Basics
2. Working with Multiple Worksheets
Module 5: Data Handling and Analysis
1. Sorting and Filtering Data
2. Basic Data Validation
Module 6: Basic Charts and Graphs
1. Creating Charts
2. Chart Formatting
Module 7: Computational Thinking
7.1 What is computational thinking?
7.2 The pillars of computational thinking
7.3 Illustrative example 1
7.4 The pillars of computational thinking: Pattern recognition
Module 8: Automation
8.1 What is automation?
8.2 What processes can be automated?
8.3 The benefits and risks associated with automation
8.4 Cognitive computer systems in the automation process
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
10.1 Introduction
10.2 Operators in VBA
10.3 Selection programming structures
10.4 Loop programming structures
10.5 Bringing it all together
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
1. Introduction
2. Moore's Law, Law of Accelerated Returns and Disruptive Innovations
3. Emerging technologies
Module 14: Cyber security
1. Introduction
2. Cyber security
3. Public Key Cryptography
8.1 What is automation?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock