All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 4 Days!

Browse Library

Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access to 16000+ online courses
  • Play & Pause Course Viewing
  • Attend weekly live webinar
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Cancel Anytime
$29
  • You will learn formulas, debugging formulas, pivot tables, macros , a bit of VBA, chart animation using VBA, Power Query, Power BI, Excel super short cuts.

All in One Excel Course - Enhance your Excel experience with MBA in Excel. Start with formulas, move onto Pivot tables, macro and VBA, manipulate data and consolidate with Power Query and visualize with Power BI. All in One course, from basics to Advanced level.  Recommended for any Excel user to level up their skills and insights of different tools provided. Excel is a must anywhere you go in the world. Uplift your Excel confidence and step out an Excel hero. With more than 18 hours of content, I hope you will be able to learn many new tips and at the end of the course be able to quickly analyze and debug formulas with ease. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst. All you need is basic Excel skills and a passion to put in hard work to master key concepts.

More videos to be added on student feedback and request.

Formulas covered are Xlookup, Vlookup, Counta, Index & Match, Sumif, Sumifs, Countif, Countifs, Array nested formulas, Filter, Xmatch, Sumproduct, Text functions, Date functions, VBA coding, DAX functions, Pivot tables, Named Ranges, Offset, Conditional Formatting, Dashboard creation, Animation in Excel, Getpivotdata, Slicers, Indirect function, Textjoin, IFS, Maxifs, Sort, Sortby, Unique, Switch, Let, Sequence, much more and  Super Excel shortcuts.

Course is updated with Microsoft 365 version.

  • All you need is a mindset to learn Excel skills and a little bit of Excel basic knowledge
  • Data Analysts, Managers, Sales , Students, Working professionals and everyone using Excel. Anyone who wants to Master Excel skills, formulas and data analysis.
View More...
  • Section 1 : Understanding and analyzing your Data 3 Lectures 00:08:48

    • Lecture 1 :
    • Understand your data before you dive in Preview
    • Lecture 2 :
    • How to use the Subtotal function
    • Lecture 3 :
    • Using Date Functions
  • Section 2 : Analyzing our Data 11 Lectures

    • Lecture 1 :
    • Remove Duplicate entries
    • Lecture 2 :
    • Using Sumif
    • Lecture 3 :
    • Using Sumifs - Multiple Criterias
    • Lecture 4 :
    • Advanced Sumifs
    • Lecture 5 :
    • Summarizing with Sumproduct
    • Lecture 6 :
    • Advanced Count / Sum Techniques - Part 1
    • Lecture 7 :
    • Advanced Count / Sum Techniques - Part 2
    • Lecture 8 :
    • Using Named Ranges - what they are and how to use them effectively
    • Lecture 9 :
    • Excel Super Hero Shortcuts - Learn them and Master them
    • Lecture 10 :
    • Conditional Formatting - Part 1
    • Lecture 11 :
    • Conditional Formatting - Part 2
  • Section 3 : Analyzing through Pivot tables 12 Lectures

    • Lecture 1 :
    • Format your data into a Table feature
    • Lecture 2 :
    • Summarizing City Sales
    • Lecture 3 :
    • Calculate City Sales Contribution
    • Lecture 4 :
    • Applying Slicers
    • Lecture 5 :
    • Slice Multiple Pivot tables
    • Lecture 6 :
    • Create Multiple Filter pages in one click
    • Lecture 7 :
    • Using Getpivotdata feature
    • Lecture 8 :
    • Adding new data to your pivot table
    • Lecture 9 :
    • Adding Slicer and Timeline
    • Lecture 10 :
    • Using Macros with Pivot tables - Part 1
    • Lecture 11 :
    • Using Macros with Pivot tables - Part 2
    • Lecture 12 :
    • Using Macros with Pivot tables - Part 3
  • Section 4 : Advanced Formulas 1 Lectures

    • Lecture 1 :
    • Advanced Formulas using arrays
  • Section 5 : Lookups in Excel 2 Lectures

    • Lecture 1 :
    • Excel Lookups - Part 1
    • Lecture 2 :
    • Lookups in Excel Part 2
  • Section 6 : Business Calculations 1 Lectures

    • Lecture 1 :
    • Business Calculations
  • Section 7 : Dashboards 11 Lectures

    • Lecture 1 :
    • Dashboard overview
    • Lecture 2 :
    • Understand your data
    • Lecture 3 :
    • Remove unique dates with macro
    • Lecture 4 :
    • Building a dynamic date range using named ranges
    • Lecture 5 :
    • Using Form Controls and Named Ranges
    • Lecture 6 :
    • Assigning the macro to the combo box
    • Lecture 7 :
    • Building the formulas for category totals
    • Lecture 8 :
    • Calculating Channel and Category totals
    • Lecture 9 :
    • Using shapes with Named ranges
    • Lecture 10 :
    • Putting all the elements in place
    • Lecture 11 :
    • Appending new data to the Dashboard
  • Section 8 : Unleashing the Power of Macros 8 Lectures

    • Lecture 1 :
    • Recording a macro
    • Lecture 2 :
    • Recording in Absolute and Relative mode
    • Lecture 3 :
    • Understanding the Range object
    • Lecture 4 :
    • Sum totals dynamically
    • Lecture 5 :
    • Lock formulas with VBA
    • Lecture 6 :
    • Create a summary report in VBA
    • Lecture 7 :
    • Using Sumifs in VBA
    • Lecture 8 :
    • Formatting the Report
  • Section 9 : Designing a Dashboard - Start to Finish 8 Lectures

    • Lecture 1 :
    • Using Getpivot Data - Designing the layout
    • Lecture 2 :
    • Using Getpivot Data
    • Lecture 3 :
    • Using Getpivot Data - Creating the Charts
    • Lecture 4 :
    • Formatting the Charts
    • Lecture 5 :
    • Application.caller
    • Lecture 6 :
    • Call shapes using Application.caller
    • Lecture 7 :
    • Applying and Formatting Slicers
    • Lecture 8 :
    • Applying a Dynamic Title
  • Section 10 : VBA - Create Chart Animation 8 Lectures

    • Lecture 1 :
    • Setting up the table
    • Lecture 2 :
    • Using a combo box
    • Lecture 3 :
    • Defining Named Ranges
    • Lecture 4 :
    • Creating the animation effect
    • Lecture 5 :
    • Adding a second series animation
    • Lecture 6 :
    • Formatting our chart
    • Lecture 7 :
    • Finishing with Dynamic header and values
    • Lecture 8 :
    • Applying final touches with form controls and buttons
  • Section 11 : Dynamic Filter using VBA 4 Lectures

    • Lecture 1 :
    • Understanding the Advanced Filter
    • Lecture 2 :
    • Writing the VBA code for the Advanced Filter
    • Lecture 3 :
    • Formatting the Sheet
    • Lecture 4 :
    • Using nested formulas to update
  • Section 12 : Using Selection Change event in VBA 11 Lectures

    • Lecture 1 :
    • Analyzing top performing SKUs
    • Lecture 2 :
    • Using the selection change event code
    • Lecture 3 :
    • Ranking total sales using Large function
    • Lecture 4 :
    • Using a scroll bar form control
    • Lecture 5 :
    • Using Sumifs formula in VBA
    • Lecture 6 :
    • Finding the top SKUs contribution
    • Lecture 7 :
    • Conditional formats to highlight category and values
    • Lecture 8 :
    • Using animation for Top SKUs
    • Lecture 9 :
    • Defining the price ranges
    • Lecture 10 :
    • Finding the different price point range
    • Lecture 11 :
    • Completing the final touches
  • 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?

Mohammed Mustafa,

I have been an Excel enthusiast for the last 12 years and have never stopped. Excel has always been my passion and it amazes me what we can accomplish with this tool. Before I got into Excel, I used to be a Snooker National and International level player. I believe that if you want to be good at something, there is nothing stopping you, it is only practice, practice and more practice. Same is the case with Excel, if you want to be good, you have to give it time and learn new things. Wish you all the best who join my course to learn key concepts of data analyzing through this beautiful software Excel.
View More...
  • vba-web-connect-ms-office-to-the-web

    VBA WEB - Connect MS Office to the ...

    By : Daniele Protti

    Lecture 223 Intermediate Level 19:38:23
  • excel-vba-from-beginner-to-expert

    Excel VBA from Beginner to Expert

    By : Daniele Protti

    Lecture 66 Beginner Level 4:48:51
  • mastering-office-365

    Mastering Office 365

    By : Chip Reaves

    Lecture 70 Beginner Level 11:35:57
  • excel-tips-and-tricks

    Excel tips and Tricks

    By : Muhammad Ali Yasin

    Lecture 16 Beginner Level 0:38:20
  • microsoft-powerpoint-2016-self-publishing-ebook-book-covers

    Microsoft PowerPoint 2016 Self-publ...

    By : Brian Jackson

    Lecture 34 Beginner Level 4:41:46
  • powerpoint-2013-2016-beginner-to-advanced-with-animation

    PowerPoint 2013/2016 Beginner to Ad...

    By : Brian Jackson

    Lecture 114 Beginner Level 10:27:34
Signup & Continue Checkout
By signing up, you agree to our Terms of Use and Privacy Policy
Create New Password
Enter your email address and we'll send you a link to reset your password.