Excel Skills for Business: Intermediate II
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Approx. 29 hours to complete
Course Summary
This intermediate Excel course teaches how to use advanced features like PivotTables, data analysis, and macros to improve your productivity and efficiency with spreadsheets.Key Learning Points
- Learn how to use PivotTables to summarize and analyze data
- Discover advanced data analysis techniques like Goal Seek and Solver
- Automate tasks with macros to save time and increase productivity
Related Topics for further study
Learning Outcomes
- Apply PivotTables to analyze and summarize data
- Use advanced data analysis techniques to solve problems
- Create macros to automate tasks and increase productivity
Prerequisites or good to have knowledge before taking this course
- Basic knowledge of Excel
- Access to Microsoft Excel software
Course Difficulty Level
IntermediateCourse Format
- Online
- Self-paced
Similar Courses
- Excel PivotTables for Beginners
- Excel Macros and VBA
Related Education Paths
Notable People in This Field
- Chandoo
- Jordan Goldmeier
Related Books
Description
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to
Outline
- Data Validation
- Week 1 Introduction
- Week 1 Discussion
- Practice Video: Data Validation
- Practice Video: Creating Drop-down Lists
- Practice Video: Using Formulas in Data Validation
- Practice Video: Working with Data Validation
- Practice Video: Advanced Conditional Formatting
- Week 1 Wrap-Up
- Welcome to Excel Skills for Business: Intermediate II
- 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, Excel Terminology, and Ninja Tips
- Data Validation
- Creating Drop-down Lists
- Using Formulas in Data Validation
- Working with Data Validation
- Advanced Conditional Formatting
- Week 1 Practice Challenge
- Week 1 Final Assignment
- Conditional Logic
- Week 2 Introduction
- Week 2 Discussion
- Practice Video: Logical Functions I: IF
- Practice Video: Logical Functions II: AND, OR
- Practice Video: Combining Logical Functions I: IF, AND, OR
- Practice Video: Combining Logical Functions II: Nested IFs
- Practice Video: Handling Errors: IFERROR, IFNA
- Week 2 Wrap-Up
- Download the Week 2 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Logical Functions I: IF
- Logical Functions II: AND, OR
- Combining Logical Functions I: IF, AND, OR
- Combining Logical Functions II: Nested IFs
- Handling Errors: IFERROR, IFNA
- Week 2 Practice Challenge
- Week 2 Final Assignment
- Automating Lookups
- Week 3 Introduction
- Week 3 Discussion
- Practice Video: Introduction to Lookups: CHOOSE
- Practice Video: Approximate Matches: Range VLOOKUP
- Practice Video: Exact Matches: Exact Match VLOOKUP
- Practice Video: Finding a Position: MATCH
- Practice Video: Dynamic Lookups: INDEX, MATCH
- Week 3 Wrap-Up
- Download the Week 3 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Introduction to Lookups: CHOOSE
- Approximate Matches: Range VLOOKUP
- Exact Matches: Exact Match VLOOKUP
- Finding a Position: MATCH
- Dynamic Lookups: INDEX, MATCH
- Week 3 Practice Challenge
- Week 3 Final Assignment
- Formula Auditing and Protection
- Week 4 Introduction
- Week 4 Discussion
- Practice Video: Error Checking
- Practice Video: Formula Calculation Options
- Practice Video: Trace Precedents and Dependents
- Practice Video: Evaluate Formula, Watch Window
- Practice Video: Protecting Workbooks and Worksheets
- Week 4 Wrap-Up
- Download the Week 4 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Error Checking
- Formula Calculation Options
- Tracing Precedents and Dependents
- Evaluate Formula, Watch Window
- Protecting Workbooks and Worksheets
- Week 4 Practice Challenge
- Week 4 Final Assignment
- Data Modelling
- Week 5 Introduction
- Week 5 Discussion
- Practice Video: Modelling Functions: SUMPRODUCT
- Practice Video: Data Tables
- Practice Video: Goal Seek
- Practice Video: Scenario Manager
- Practice Video: Solver
- Week 5 Wrap-Up
- Download the Week 5 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Modelling Functions (SUMPRODUCT)
- Data Tables
- Goal Seek
- Scenario Manager
- Solver
- Week 5 Practice Challenge
- Week 5 Final Assignment
- Recording Macros
- Week 6 Introduction
- Week 6 Discussion
- Practice Video: Record a Macro
- Practice Video: Run a Macro
- Practice Video: Edit a Macro
- Practice Video: Working with Macros
- Practice Video: Relative Reference Macros
- Week 6 Wrap-Up
- Download the Week 6 workbooks
- Keyboard Shortcuts, Excel Terminology, and Ninja Tips
- Record a Macro
- Run your Macro
- Edit a Macro
- Working with Macros
- Relative Reference Macros
- Week 6 Practice Challenge
- Week 6 Final Assignment
- Final Assessment
- Final Assessment
Summary of User Reviews
Discover the next level of Excel proficiency with the Excel Intermediate 2 course on Coursera. This course has received high praise from users for its comprehensive coverage of advanced Excel skills. Many users were impressed with the engaging and practical examples used throughout the course.Key Aspect Users Liked About This Course
engaging and practical examples used throughout the coursePros from User Reviews
- Comprehensive coverage of advanced Excel skills
- Easy to follow along and understand
- Great for improving Excel proficiency
- Practical and relevant examples
- Engaging course content
Cons from User Reviews
- Some users found the course too basic
- Not suitable for those with no prior Excel knowledge
- Course materials could be more interactive
- Limited opportunities for practice exercises
- Some users experienced technical difficulties
Nicky Bull
4.8 Raiting
The Complete Junior to Senior Web Developer Roadmap (2021)
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Go from Junior Developer to Senior Developer. Learn all the technical skills Senior Web Developers know! This extensive course doesn’t just cover a small portion of the industry....
The Complete Financial Analyst Course 2021
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included! ** Updated for July 2021! ** ", Business Insider...
The Ultimate Microsoft Excel 2010 and 2013 Training Bundle
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Can You Use The Internet? If Yes, Then You Can Master Microsoft Excel 2010 and 2013 The Easy Way - On Your Schedule...
Data Visualization and Building Dashboards with Excel and Cognos
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Enroll to learn more, complete the course and claim your badge! By completing this course, you will gain a basic understanding of using spreadsheets as a tool for data visualization....
