MS Excel Analytics for Business Owners
Learn some of the best MS Excel tips, tricks, and shortcuts for your business
Watch PromoAbout the Course
Business owners spend over 50% of their time organizing and analyzing data. Microsoft Excel’s powerful tools like filtering, sorting and pivot tables can help format data and bring out greater insights to make smarter business decisions and save hours of time!
In this course, you will learn:
- How to extract Bank Account Nos. from narration
- 5 ways to clean data using Excel's Power Query
- How to analyze Ledger data using Pivot Table
- 3 ways to clean Tally data to analyze it better
- How to convert Dr-Cr to plus-minus in Tally data
- How to format Form 26AS TDS Sheet
- 5 tricks to save time in general formatting issues
- How to remove Passwords from Protected Sheets
- How to perform 2-way reconciliation of two lists
Learn some of the best MS Excel tips, tricks, and shortcuts that can help you quickly extract key metrics for your business, especially if you’re using Tally. Most of these will work on Google Sheets too. Get started right away!
Course Curriculum
MS Excel Analytics for Business Owners
Available in
days
days
after you enroll
-
StartHow to Extract Bank Account Numbers from Tally Narration (4:58)
-
StartHow to Analyse Ledger Data Using Pivot Tables (6:08)
-
Start3 Ways to Clean Tally Data to Analyse it Better (5:32)
-
StartHow to Covert Debit/Credit to Plus/Minus from Tally Data (4:49)
-
StartHow to Format Form 26AS TDS Sheet (6:58)
-
StartHow to Covert Numbers to Words (3:17)
-
StartHow to Remove "Protect Sheet" Password (3:54)
-
StartHow to Perform 2-Way Reconciliation of Two Lists (5:22)
-
Start5 Ways to Clean Data Using Power Query (16:12)
-
Start5 Tricks to Save Time in General Formatting Issues (10:27)
-
StartUnlock your Certificate: MS Excel Analytics for Business Owners
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We value your time and understand your needs. If you are unsatisfied with the content on mojoVersity, please write to us at [email protected]. We are open to taking your recommendations and suggestions.
Who is the course provider?
WorkReady offers hi-ROI induction programs that can help train your new hires on Data Analytics, Business Acumen, Digital Awareness, Effective Communication or your own product before they join your organization.
Visit Work-Ready.in to check out their programs: t.ly/5L4i
How to download my certificate?
You can download your certificate only if you have taken the quiz at the end of the course. Unlock your certificate by completing all the chapters and the final quiz. Click on complete and continue at the right top to generate your certificate.