Left Blocks Image | Learnfly Right Blocks Image | Learnfly
All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Learnfly | Menu Trigger Icons Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart
    Learnfly | Empty Cart Icons

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
1 days left at this price!

This plan includes

  • Limited free courses access
  • Play & Pause Course Videos
  • Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Email & Chat Support
Get Unlimited Learning Access
$29
1 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to 11,000+ Courses
  • Ads free experience Courses
  • Play & Pause Course Videos
  • Learnfly HD IconsHD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Direct Support
  • Email & Chat Support
  • Cancel Anytime
$29
$29
$29
  • 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

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.

  • 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
  • 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
View More...
  • Section 1 : Manage Data 8 Lectures 00:17:56

    • Lecture 1 :
    • Grouping Preview
      Learn how to group large data sets into manageable sections
    • Lecture 2 :
    • SubTotals
      Use SubTotals to group and analyse data
    • Lecture 3 :
    • The Filter function
      Use the Filter function to extract selected data sets by criterion
    • Lecture 4 :
    • Named Cells
      Naming cells and ranges makes building and understanding formula much easier. Instead of using cells reference words are used
    • Lecture 5 :
    • Naming Ranges
    • Lecture 6 :
    • Formatted as a Table
      A formatted table is a powerful feature that allows you to visually group and analyse data. It provides several benefits, including easier sorting, filtering, and automatic formatting. Let's explore how to create and format a table:
    • Lecture 7 :
    • Exercise One Instructions
      Download the practise file and try and complete the exercise.
    • Lecture 8 :
    • Course Content
      This is the course content video. The course manual is available to download from here.
  • Section 2 : Pivot Tables 10 Lectures 00:25:27

    • Lecture 1 :
    • Basic Pivot tables
      Create a simple Pivot table utilise slicers and timelines, progress to add calculations and relate tables. Finally add measures and KPIs
    • 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
      Download the practise file
  • Section 3 : What IF Analysis 8 Lectures 00:22:35

    • Lecture 1 :
    • Goal Seek
      Learn how to use Goal Seek to solve problems. What IF analysis tool
    • 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
      Download the practise file and complete the exercise
  • Section 4 : Data Validation 5 Lectures 00:10:25

    • Lecture 1 :
    • Basic Data Validation
      Use data validation to restrict data entry and avoid inaccurate data corrupting spreadsheets
    • Lecture 2 :
    • Conditional Validation
    • Lecture 3 :
    • Linked Validation demonstration
    • Lecture 4 :
    • Data Validation and Functions
    • Lecture 5 :
    • Exercise four instructions
      Download the practise file and complete the exercise
  • Section 5 : Functions 24 Lectures 00:43:41

    • Lecture 1 :
    • Simple IF Function
      Use a logical function to produce one of two results
    • Lecture 2 :
    • IF Function with an AND
    • Lecture 3 :
    • VLOOKUP
    • Lecture 4 :
    • VLOOKUP to compare lists
    • Lecture 5 :
    • XLOOKUP V VLOOKUP
    • Lecture 6 :
    • COUNTIF Function
    • Lecture 7 :
    • SUMIF function
    • Lecture 8 :
    • Rolling 6 month chart with SUMIF
    • Lecture 9 :
    • COUNTIFS function
    • Lecture 10 :
    • SUMIFS Function
    • Lecture 11 :
    • Dynamic SUMIF
    • Lecture 12 :
    • Take Function
    • Lecture 13 :
    • Nesting Functions
    • Lecture 14 :
    • Index and Match Functions
    • Lecture 15 :
    • Array Functions and Spill error
      If you see the Spill Error, check for data in the space where the formula would normal spill
    • Lecture 16 :
    • Concatenation
    • Lecture 17 :
    • Vstack
    • Lecture 18 :
    • Lookup an Image
    • Lecture 19 :
    • Use a Lookup to return multiple rows
    • Lecture 20 :
    • Exercise Five Instructions
      Download the practise file and complete the exercise
    • Lecture 21 :
    • Text Functions
    • Lecture 22 :
    • Date Functions
    • Lecture 23 :
    • Switch Function
    • Lecture 24 :
    • Dynamic Doughnut Chart with IF & And
  • Section 6 : Basic Macros 3 Lectures 00:05:29

    • Lecture 1 :
    • Simple Macro
    • Lecture 2 :
    • Add a Macro to the quick access toolbar
    • Lecture 3 :
    • Exercise Six Instructions
      Download the practise file and complete the exercise
  • Section 7 : Developer Controls 3 Lectures 00:07:20

    • Lecture 1 :
    • Spinner Control
      Use some of the developer controls to enhance spreadsheets
    • Lecture 2 :
    • How to use the Check box
    • Lecture 3 :
    • Option button
  • Section 8 : Power Query Editor 5 Lectures 00:09:09

    • Lecture 1 :
    • Transform data
    • Lecture 2 :
    • Query Editor Group By
    • Lecture 3 :
    • Conditional Column
    • Lecture 4 :
    • Append Queries
    • Lecture 5 :
    • Exercise Seven Instructions
  • Learnfly Google Logo
  • Learnfly Facebook Logo
  • Learnfly Apple Logo
  • Learnfly EA Logo
  • Learnfly Amazon Logo
  • Learnfly IBM Logo
  • Learnfly Microsoft Logo
  • Learnfly Reddit Logo
  • Learnfly Spotify Logo
  • Learnfly Uber Logo
  • Learnfly Youtube Logo
  • Learnfly Instagram Logo
  • 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.
    Learnfly LMS Sample
  • 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?
User Images | Learnfly

2614 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...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

  • Learnfly | a-l-1a Icons
  • Learnfly | a-l-2a Icons
  • Learnfly | a-l-3a Icons
  • Learnfly | a-l-4a Icons
  • Learnfly | a-l-6a Icons
  • Learnfly | a-l-7a Icons
Sign Up & Start Learning
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons




By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.
Learnfly | Sign Up Icons