Course Summary
Excel Advanced is a course designed for experienced Excel users who want to take their skills to the next level. It covers advanced functions, data analysis tools, and automation techniques.Key Learning Points
- Learn advanced Excel functions and data analysis tools
- Automate tasks using macros and Visual Basic for Applications (VBA)
- Create interactive dashboards and reports
Related Topics for further study
- Advanced Excel Functions
- Data Analysis
- Automation
- Interactive Dashboards
- Visual Basic for Applications (VBA)
Learning Outcomes
- Ability to use advanced Excel functions and data analysis tools
- Proficiency in creating automated tasks using macros and VBA
- Ability to create interactive dashboards and reports
Prerequisites or good to have knowledge before taking this course
- Basic knowledge of Excel
- Access to Microsoft Excel
Course Difficulty Level
AdvancedCourse Format
- Online
- Self-paced
Similar Courses
- Excel VBA
- Data Analysis and Visualization
Related Education Paths
Notable People in This Field
- Excel MVP and Author
- Excel MVP and Trainer
Related Books
Description
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.
Outline
- Spreadsheet Design and Documentation
- Week 1 Introduction
- Week 1 Discussion
- Practice Video: Spreadsheet Design Principles
- Practice Video: Calculations
- Practice Video: Formatting
- Practice Video: Documentation
- Practice Video: Interface and Navigation
- Welcome
- Course Structure & Assessments
- Course goals and weekly learning objectives
- Read me before you start: Quizzes and navigation
- Read me before you start: Versions and regions
- Download the Week 1 workbooks
- Keyboard Shortcuts, Terminology, and Ninja Tips
- Spreadsheet Design Principles
- Calculations
- Formatting
- Documentation
- Week 1 Final Assignment
- Advanced Formula Techniques
- Week 2 Introduction
- Week 2 Discussion
- Practice Video: Tables and Structured Referencing
- Practice Video: Using Functions to Sort Data
- Practice Video: Introduction to Array Formulas
- Practice Video: Working with an Array Function (TRANSPOSE)
- Practice Video: Solving Problems with Array Formulas
- Download the Week 2 workbooks
- Keyboard Shortcuts, Terminology, and Ninja Tips
- Tables and Structured Referencing
- Using Functions to Sort Data
- Introduction to Array Formulas
- Week 2 Practice Challenge
- Week 2 Final Assignment
- Data Cleaning and Preparation
- Week 3 Introduction
- Week 3 Discussion
- Practice Video: Replace blanks with repeating values
- Practice Video: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
- Practice Video: Remove Unwanted Spaces (TRIM, CLEAN)
- Practice Video: Diagnostic Tools (ISNUMBER, LEN, CODE)
- Practice Video: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
- Download the Week 3 workbooks
- Keyboard Shortcuts, Terminology, and Ninja Tips
- Replace blanks with repeating values
- Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
- Remove Unwanted Spaces (TRIM, CLEAN)
- Diagnostic Tools (ISNUMBER, LEN, CODE)
- Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
- Week 3 Practice Challenge
- Week 3 Final Assignment
- Financial Functions and Working with Dates
- Week 4 Introduction
- Week 4 Discussion
- Practice Video: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
- Practice Video: Financial Functions (FV, PV, PMT)
- Practice Video: Loan Schedule (PMT, EDATE)
- Practice Video: Net Present Value and Internal Rate of Return (NPV, IRR)
- Practice Video: Depreciation Functions (SLN, SYD, DDB)
- Download the Week 4 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
- Financial Functions (FV, PV, PMT)
- Loan Schedule (PMT, EDATE)
- Net Present Value and Internal Rate of Return (NPV, IRR)
- Depreciation Functions (SLN, SYD, DDB)
- Week 4 Final Assignment
- Advanced Lookup Functions
- Week 5 Introduction
- Week 5 Discussion
- Practice Video: INDIRECT
- Practice Video: ADDRESS
- Practice Video: Introduction to OFFSET
- Practice Video: Solving Problems with OFFSET
- Download the Week 5 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- INDIRECT
- ADDRESS
- Introduction to OFFSET
- Week 5 Final Assignment
- Building Professional Dashboards
- Week 6 Introduction
- Week 6 Discussion
- Practice Video: Dashboard Design
- Practice Video: Prepare Data
- Practice Video: Construct Dashboard
- Practice Video: Creative Charting
- Practice Video: Interactive Dashboard
- Download the Week 6 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Dashboard Design
- Final Assessment
- Final Assessment
Summary of User Reviews
Excel Advanced is a highly recommended course by many users. It offers comprehensive and practical knowledge on Excel, with hands-on exercises that allow users to apply the concepts learned. One key aspect that many users found great is the instructors' ability to explain complex Excel functions in a simple and easy-to-understand manner.Pros from User Reviews
- Comprehensive and practical knowledge on Excel
- Hands-on exercises to apply concepts learned
- Instructors explain complex Excel functions in a simple and easy-to-understand manner
Cons from User Reviews
- Some users found the course too basic for their level of knowledge
- A few users reported technical issues with the platform
- The course can be time-consuming, requiring a significant time commitment
Nicky Bull
4.7 Raiting
Mobile App Biz Pro Secrets - Complete App Business In A Box!
- 4.5
-
![]()
![]()
![]()
![]()
![]()
The ULTIMATE App Biz Program! Get a piece of the BILLIONS earned by app devs yearly! Start your app business: JOIN NOW!...
Top Strategies to succeed in Shopify Dropshipping in 2021!
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Make your Dropshipping store profitable! Dropship products from top countries, Boost your sales, Master Marketing & more People fail with ecommerce (dropshipping) because:...
Excel Mastery 15 Days Course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
This Excel Course will give you make you master in excel in 15 days Microsoft Excel Mastery Course: Complete Excel Training: You are here because you want to learn Excel....
SEO Guide 2021: How I Get 5,000 Visitors a Day to My Website
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn Search Engine Optimization from Start to End | Actionable SEO Tips | WordPress SEO Training Learn and Master the Search Engine Optimization (SEO) in this Comprehensive Course...
