
Understanding how to use the subtotal function in excel when you want to filter data and update your totals accordingly.
See what's included in the course
Get a preview of the modules in the MBA in Excel course, outlining how business analytics in Excel will be covered to build mastery.
Understand how to extract date formats using various methods
Explore sumif to calculate monthly totals for quantity and value, then compute average price, locking references with F4 and dragging formulas, and visualize trends with a line chart.
Master advanced sumifs in excel by building multi-criteria array formulas with ctrl+shift+enter, summing sales by product, region, and date.
Learn to use slicers and a date timeline in Excel pivot tables to filter by category and period, build a dynamic chart, and identify key contributors with running totals.
Record and store multiple macros to automate pivot table analyses. Assign macros to shapes for quick use, covering top five sales reps, SKUs, categories, and customers.
Record a macro to remove unique dates starting from June 1, 2020 using an advanced filter, and paste results for calculating the previous month and the previous year sales.
Update a macro-enabled dashboard by appending July data to a table, expanding the dataset, and sorting dates for a seamless macro run via the form control.
Lock formulas using VBA by prompting a password with an input box, locking cells with formulas on the active sheet, and protecting the sheet for reuse via a personal workbook.
Record macros and write VBA to generate a monthly sales report using sumifs by salesman and month. Prepare data with advanced filter and dynamic ranges.
Course reviews:
"Best course of MS excel. covered everything"
Abhishek Batham
" This course really worth more than others."
Sandeep K.H - India
" Thank you for this amazing course and for all the Information you shared in this course. For me your course is in top 10 excel courses here on Udemy and believe me I have seen a lot. Your course have everything. If you will do in the future others courses I will buy then instantly. "
Copaci Florin-Romania
"Thank you so much for the course. I am loving it. You present challenge after challenge in each exercise, and its been fun following, along as well as figuring out multiple ways to answer your questions. I hope you make more courses. You are a good teacher."
N.Sanchez - USA
"I am lucky I took this course. Amazing"
Ijlal hasnain - Pakistan
"I must confess, course really helped me in doing my work. I highly recommend the course to the who like to learn and master in data analysis. Funny thing, I did this course while based in Switzerland. Most importantly, I was able to reach out with my customized questions to the course Instructor and he was always reachable and supportive to answer my queries."
Rizwan Safdar - Switzerland
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.