Microsoft Excel for Business Analysts

Learn specific functions, formulas, and tools that Microsoft Excel has to help conduct business or data analysis.

Your 100% online, self-paced Microsoft Excel® for Business Analysts includes:

-8+ hours of Microsoft Excel® Business Analysts Training designed by industry experts
–Learn at your own pace whenever and wherever you want, even if you work full-time
-How to take raw data and clean it
-Tools and functions that can be used to conduct analysis
-Display data in the most meaningful way
-Advanced techniques designed to aid forecasting and using existing data to predict future trends
-Practice exercises so you can immediately put into practice the new data analysis techniques that you learn


"Master of Project Academy allows professionals to advance their training at a schedule that fits their busy life. No set dates, no set number of hours. No need to take time off to accommodate a course schedule in a physical classroom. And with 24 hour assistance, professionals have access to help whenever they need it."

Microsoft Excel Training

Microsoft Excel® for Business Analysts Training is ideal for you if you’re looking to learn specific functions, formulas, and tools that Excel has to help conduct business or data analysis.

See Pricing


50+ Lectures


8+ Hours


Lifetime Access option


30 day money back guarantee!


100% Online & Self-Paced


Course Completion Certificate


  • Enroll in a Microsoft Appreciated Training
  • Learn how to take raw data and clean it so it’s in a usable format
  • Tools and functions that can be used to conduct analysis
  • How to display data in the most meaningful way
  • Advanced techniques designed to aid forecasting and using existing data to predict future trends
  • Practice exercises so you can immediately put into practice the new data analysis techniques that you learn
  • Get prompt answers & support from the instructor within 24 hours!
  • Test yourself with quizzes at the end of the sections
  • Earn 10 PDUs if you are a PMP already
  • Get downloadable handouts and materials during the course

Microsoft Excel is used by hundreds of millions of people around the world. Students, Accountants, Engineers, Managers, Architects, Doctors and many other professions are using MS Excel as their primary tool for keeping, organizing, analyzing and managing records and data.

This training is most suited for:

  • Data Analysts
  • Students
  • Engineers
  • Project Managers
  • Accountants
  • Anyone using Microsoft Excel®
  • Anyone who wants to learn how to use MS Excel®

What is Microsoft Excel®?

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Microsoft Excel is used by several small to large organizations as the primary tool for keeping, analyzing, and managing data. Learning how to use Microsoft Excel will earn you a must-to-have skill in today's competitive world.

What is in this Microsoft Excel® for Business Analysts Training Program?

Microsoft Excel course program includes 20 different sections.

We start by looking at how to take raw data and clean it so it’s in a usable format. After that, we look at a number of tools and functions that can be used to conduct analysis before moving onto how to display data in the most meaningful way. Finally, we move onto some more advanced techniques designed to aid forecasting and using existing data to predict future trends.This course also includes practice exercises so you can immediately put into practice the new data analysis techniques that you learn.

In this Microsoft Excel® for Business Analysts Course course you will learn:...

  • How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
  • How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
  • How to split data using text functions SEARCH, LEFT, RIGHT, MID
  • How to standardize and clean data ready for analysis
  • About using the PivotTable function to perform data analysis
  • How to use slicers to draw out information
  • How to display your analysis using Pivot Charts
  • All about forecasting and using the Forecast Sheets
  • Conducting a Linear Forecast and Forecast Smoothing
  • How to use Conditional Formatting to highlight areas of your data
  • All about Histograms and Regression
  • How to use Goal Seek, Scenario Manager, and Solver to fill data ga
  • Do I need Microsoft Excel Program?

    Our Microsoft Excel® for Business Analysts Training is 100% online and self-paced. Lectures do not require you to have a MS Excel on your PC. However, we recommend you to practice what you learned during the Microsoft Excel® for Business Analysts Training course. Therefore, we advise you to obtain a MS Excel license and try to apply what you learn throughout the MS Excel course.

    Curriculum


      Section 1: Introduction
    Available in days
    days after you enroll
      Section 2: The Basics
    Available in days
    days after you enroll
    • Start
      A Recap of Basic Formulas (12:42)
    • Start
      Absolute vs Relative Referencing (8:15)
    • Start
      Exercise 01
    • Start
      Practice Questions
      Section 3: Merging and Looking Up Data
    Available in days
    days after you enroll
    • Start
      Merging data from different sources (2:48)
    • Start
      Looking up Information with VLOOKUP (Exact) (10:57)
    • Start
      Looking up information with VLOOKUP (Approx) (6:27)
    • Start
      How to use VLOOKUP with data that expands (10:00)
    • Start
      Using HLOOKUP (12:16)
    • Start
      Combining VLOOKUP and MATCH (12:25)
    • Start
      Using INDEX, MATCH and XLOOKUP (17:26)
    • Start
      Data Validation Lists with Lookups (8:30)
    • Start
      Exercise 02 (6:24)
    • Start
      Practice Questions
      Section 4: Making Better Decisions with IF
    Available in days
    days after you enroll
    • Start
      More Examples of the IF Function (7:08)
    • Start
      How to use the IF function (5:30)
    • Start
      Working with Nested Ifs (6:35)
    • Start
      The IFS function (8:47)
    • Start
      Error handling with IFERROR and IFNA (9:21)
    • Start
      Using MAX and MIN instead of the IF function (11:25)
    • Start
      Using SUMIFS and COUNTIFS (11:52)
    • Start
      Exercise 03 (1:32)
    • Start
      Practice Questions
      Section 5: Preparing Data for Analysis
    Available in days
    days after you enroll
    • Start
      Using the Flash Fill command (4:39)
    • Start
      Splitting data using text functions (16:13)
    • Start
      Concatenating data (9:03)
    • Start
      Standardizing data (9:00)
    • Start
      Formatting data as a table (9:45)
    • Start
      Exercise 04 (2:28)
    • Start
      Practice Questions
      Section 6: PivotTables
    Available in days
    days after you enroll
    • Start
      An introduction to PivotTables (3:15)
    • Start
      Creating a PivotTable (12:40)
    • Start
      Summarizing Data (13:52)
    • Start
      Calculations in PivotTables (15:13)
    • Start
      Using Slicers to filter information (9:55)
    • Start
      Exercise 05 (1:53)
    • Start
      Practice Questions
      Section 7: Visualizing Data with Charts
    Available in days
    days after you enroll
    • Start
      Creating a Pivot Chart (10:38)
    • Start
      Formatting a Pivot Chart (14:25)
    • Start
      Using Sparklines (7:52)
    • Start
      A Basic Interactive Dashboard (14:45)
    • Start
      Exercise 06 (2:51)
    • Start
      Practice Questions
      Section 8: Forecasting
    Available in days
    days after you enroll
    • Start
      The Forecast Function (7:24)
    • Start
      Forecast Sheets (7:18)
    • Start
      Exercise 07 (1:35)
    • Start
      Practice Questions
      Section 9: Additional useful tools in Excel
    Available in days
    days after you enroll
    • Start
      Conditional Formatting (11:28)
    • Start
      The INDIRECT function (13:29)
    • Start
      The OFFSET function (10:32)
    • Start
      Using Histograms (4:55)
    • Start
      Regression (6:41)
    • Start
      Exercise 08 (2:13)
    • Start
      Practice Questions
      Section 10: WhatIf Analysis
    Available in days
    days after you enroll
    • Start
      Scenario Manager (8:01)
    • Start
      Goal Seek (7:43)
    • Start
      Data Tables (7:13)
    • Start
      Solver (6:50)
    • Start
      Exercise 09 (1:42)
    • Start
      Practice Questions
      Section 11: Course Close
    Available in days
    days after you enroll
    • Start
      Course Close (0:44)
      Tip #1 - Join LinkedIn Community
    Available in days
    days after you enroll
    • Start
      Join LinkedIn Community & Follow Latest Updates
      How to Submit a PDU Claim (For Retaining PMP Certificate)
    Available in days
    days after you enroll
    • Start
      How to Submit PDUs
      Bonus Lecture - Discount for our paid courses
    Available in days
    days after you enroll
    • Start
      Bonus Lecture - Discount for our paid courses
      Important Notice About Certificate of Completion
    Available in days
    days after you enroll
    • Start
      Important Notice About Certificate of Completion

    Everything you need to train for Microsoft Excel® for Business Analysis

    Ready to get serious about learning MS Excel? Your new Business Analysis career opportunities depend on it.
    Enroll today and give yourself the best chance to create the best in Excel…
    100% online training, learn at your own pace from wherever you want


    In-person, virtual, and hybrid group training formats are available for this program.

    For group and corporate training solutions, please

    Request a Quote

    Monthly

    $47

    per month

    Benefits of a monthly subscription:

    The faster you complete the course, the less you pay

    Get continuous access to the course - auto-billing means no manual payment hassles.
    Cancel anytime

    Annual

    $97

    1-year duration

    Benefits of an annual subscription:

    Learn at your own pace - take your time to complete the training and fully prepare for the certification exam

    Revisit key lectures and highlights to give yourself the best chance of passing

    Lifetime

    $147

    lifetime access

    Benefits of lifetime course access:

    Pay once, get forever access to course materials and all future updates at no additional cost

    Revisit key lectures and highlights to give yourself the best chance of passing

    30 Day Money Back Guarantee - Our Overall Full Refund Rate is < 1%

    Frequently Asked Questions


    When does the course start and finish?
    Master of Project Academy courses are designed to be flexible and affordable, so you can learn how you choose.

    You can begin the course from the moment you enroll. Get instant access to all the lectures, videos and materials and train for certification at your own pace.

    There’s no deadline to complete the course – you can watch and re­‐watch as many times as you like, giving yourself the best chance at passing your certification exam at the first attempt.
    What if I am unhappy with the course?
    All our courses come with a full 30-­day guarantee for your protection. Our overall refund rate is less than 1% from 300,000+ students who have used our course to train for Microsoft Excel® for Business Analysts.

    But if for any reason you decide to cancel, just email [email protected] within 30 days of enrollment, and we’ll refund your payment in full.
    Any further questions?
    We’re happy to answer them! Please visit our FAQ page for more details or email [email protected].
    How long can I access the course for?
    For however long you need it. You can choose from monthly access, one‐year access or lifetime access below. If you select monthly access you will be auto-­billed on the same day each month, and can access the full course at any time until you cancel.

    If you want to take longer to study the course, you can select annual or lifetime access to give yourself more time to watch and re-­‐ watch the lectures. Lifetime access is exactly that – you will never lose access and will receive free course content updates forever.
    Who teaches the course?
    Master of Project Academy instructors has several years of experience in their fields and each has major industry experience including but not limited to IT, banking, telecommunications, consultancy, non-profit organizations, military, energy, and more.

    Read more about Master of Project Academy Instructors.