Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
3 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
3 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- Improved Data Analysis: Advanced Excel training allows you to manipulate, visualise, and evaluate data more effectively. You'll learn how to create complex equations, track various departments and operations, and design professional-level spreadsheets. These skills enable you to analyse data at a more advanced level, providing valuable insights for decision-making.
- Enhanced Productivity: With advanced Excel skills, you can work more efficiently. You'll be able to clean up data, balance accounts, and create easy-to-read reports for upper management. By streamlining processes and automating repetitive tasks using macros, you'll save time and increase productivity.
- Increased Employability: Employers value candidates who are proficient in Excel and other Office 365 programs. Adding advanced Excel skills to your resume enhances your employability. Many companies rely on Excel for communication, documentation, project management, and performance tracking.
- Employee Value: For existing employees, advanced Excel knowledge is an asset. It improves work speed, efficiency, and productivity. HR managers recognize that employee satisfaction is linked to training opportunities. By investing in Excel training, companies retain skilled staff members.
- Consistent Language Across Workplaces: Advanced Excel skills allow you to transition seamlessly between different workplaces while using the same
Course Overview
This course will introduce you to the essential data analysis tools and techniques in Excel, such as pivot tables, charts, slicers, and dashboards. You will learn how to perform what-if analysis using scenarios, goal seek, and data tables to explore the impact of different assumptions and values on your results. You will also learn how to create simple macros to automate repetitive tasks and enhance your productivity. Additionally, you will learn how to use data validation to control the type and range of data that can be entered in a cell, and how to use advanced functions such as VLOOKUP, INDEX, MATCH, and IFERROR to perform complex calculations and lookups.
Pre-requisites
- You should have completed the level 2 course or have a good understanding of Excel
- You will require a copy of Microsoft Excel and a computer
- Using two monitors would be a help but essential
Target Audience
- The course is designed for people wanting automate processes in Excel
- This course is useful for people that carry out data analytical tasks
- This course is useful if you work with large data sets and want to quickly interrogate specific sets
- This course is design for people that wish to move their Excel understand forward
Curriculum 67 Lectures 02:22:02
-
Section 1 : Manage Data
- Lecture 2 :
- SubTotals
- Lecture 3 :
- The Filter function
- Lecture 4 :
- Named Cells
- Lecture 5 :
- Naming Ranges
- Lecture 6 :
- Formatted as a Table
- Lecture 7 :
- Exercise One Instructions
- Lecture 8 :
- Course Content
-
Section 2 : Pivot Tables
- Lecture 1 :
- Basic Pivot tables
- Lecture 2 :
- Filtering in a Pivot table
- Lecture 3 :
- Adding % column in a Pivot Table
- Lecture 4 :
- Report Connections
- Lecture 5 :
- Grouping a Pivot table
- Lecture 6 :
- Calculations in a Pivot table
- Lecture 7 :
- Relationships in a Pivot Table
- Lecture 8 :
- PowerPivot Measures and KPIs
- Lecture 9 :
- External data into PowerPivot
- Lecture 10 :
- Exercise two Instructions
-
Section 3 : What IF Analysis
- Lecture 1 :
- Goal Seek
- Lecture 2 :
- Scenario Manager
- Lecture 3 :
- Data tables
- Lecture 4 :
- Solver
- Lecture 5 :
- Forecast Sheet
- Lecture 6 :
- Forecast Function
- Lecture 7 :
- Forecast.ETS
- Lecture 8 :
- Exercise Three Instructions
-
Section 4 : Data Validation
- Lecture 1 :
- Basic Data Validation
- Lecture 2 :
- Conditional Validation
- Lecture 3 :
- Linked Validation demonstration
- Lecture 4 :
- Data Validation and Functions
- Lecture 5 :
- Exercise four instructions
-
Section 5 : Functions
- Lecture 1 :
- Simple IF Function
- Lecture 2 :
- IF Function with an AND
- Lecture 3 :
- Nested IF and IFS
- Lecture 4 :
- VLOOKUP
- Lecture 5 :
- VLOOKUP to compare lists
- Lecture 6 :
- XLOOKUP V VLOOKUP
- Lecture 7 :
- COUNTIF Function
- Lecture 8 :
- SUMIF function
- Lecture 9 :
- Rolling 6 month chart with SUMIF
- Lecture 10 :
- COUNTIFS function
- Lecture 11 :
- SUMIFS Function
- Lecture 12 :
- Dynamic SUMIF
- Lecture 13 :
- Take Function
- Lecture 14 :
- Nesting Functions
- Lecture 15 :
- Index and Match Functions
- Lecture 16 :
- Array Functions and Spill error
- Lecture 17 :
- Concatenation
- Lecture 18 :
- Vstack
- Lecture 19 :
- Lookup an Image
- Lecture 20 :
- Use a Lookup to return multiple rows
- Lecture 21 :
- Exercise Five Instructions
- Lecture 22 :
- Text Functions
- Lecture 23 :
- Date Functions
- Lecture 24 :
- Switch Function
- Lecture 25 :
- Dynamic Doughnut Chart with IF & And
-
Section 6 : Basic Macros
- Lecture 1 :
- Simple Macro
- Lecture 2 :
- Add a Macro to the quick access toolbar
- Lecture 3 :
- Exercise Six Instructions
-
Section 7 : Developer Controls
- Lecture 1 :
- Spinner Control
- Lecture 2 :
- How to use the Check box
- Lecture 3 :
- Option button
-
Section 8 : Power Query Editor
- Lecture 1 :
- Transform data
- Lecture 2 :
- Query Editor Group By
- Lecture 3 :
- Conditional Column
- Lecture 4 :
- Append Queries
- Lecture 5 :
- Exercise Seven Instructions
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
-
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
704 Course Views
3 Courses
I have been a Microsoft Office, Project and Visio trainer for IT's Easy Training since 1999. I have trained more than fifteen thousand delegates in various Microsoft applications, with a focus on Excel, Project and Access. I also offer courses on Word, Visio, PowerPoint and Publisher, but less frequently. I am passionate about learning new features and sharing my knowledge with my delegates. I tailor my courses to the business needs of my clients and provide email support and blog updates to help them apply what they learn. I am based in the UK and travel across the country to deliver training sessions.
View More...
