It's time to show who's the boss. Whether you're starting from scratch or you want to become a pro-Excel user, you've come to the right place.
This course is going to give you a detailed understanding of Microsoft Excel, & after that, we are going to discuss formulas and functions that transform your Excel spreadsheet from a normal worksheet into a reliable, dynamic, and powerful tool.
This course worth your attention, because most of the Excel courses will teach you simply what each feature & formula of Excel does, however, I am going to teach you contextual examples which are designed to show you why these features & formulas are super awesome & the process of how they can be applied in various ways to transform Excel into anything you want. I will train you not only to record data & use formulas, but I am also going to teach you how to THINK & TRANSFORM Excel.
1. Start using Excel as a tool of your journey towards success
2. Writing robots dynamic Excel Formulas
3. Easy build dynamic reports in Excel
4. Design your own Excel Formula to define your needs
5. Become the boss and design your own formula-based Excel formatting rules
6. Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions
7. Manipulate dates, times, text, and arrays
8. Maintain large sets of Excel data in the way you want
9. Use Excel 100 Times faster by mastering Excel Shortcuts
10. Make dynamic reports wth features of reducing errors by using Data Validation
11. Use Excel as an Analytics tool by using Filters & Pivot Tables
12. Understand how Excel understand you to feel its power
Although there are no fixed eligibility criteria but deep desire to learn Excel is required. With this, anyone with the very basic knowledge of using a computer can join as we are going to start from very scratch
The course continues 10 hours of videos and Excel Exercise Workbooks
1. Completely online, no bar on access. You can access it anytime and from anywhere 2. Everything is discussed with an example & detailed cases so that practical situations. Issues in its applicability faced by the industries and businesses are covered and discussed with solution
Things you need to know to start your journey with Excel Making you familiar with Excel Application Features,
All Excel important shortcuts to note How to increase speed of using Excel Way to find Shortcut of anything in Excel
All Excel important formulas Financial Formulas Logical Formulas Text Formulas Date Formulas
All Excel important formulas
How to use Filters & Tables How to use Pivot Table Basics & Advance
How to build Reports of your need How to modify data using Excel Formulas & Features How to use Data Validation i
Basic to intermediate google sheets
Basic to intermediate google sheets
1. Completely online, no bar on access. You can access it anytime and from anywhere
2. Everything is discussed with an example & detailed cases so that practical situations. Issues in its applicability faced by the industries and businesses are covered and discussed with solution
Mr. Anshuman Tandon is an Excel Expert, he is the founder of Excel Man, an online platform to teach MS Office & Google softwares to all professionals, he had worked as a Tax Specialist at Masters India Pvt Ltd a GST Suvidha Provider, & had worked with concerns like Flipkart, Hindware, Maruti Suzuki, L&T & India Mart in dealing their GST related tasks & resolving their queries, he has also worked with over 180 MSMEs in dealing their day to day GST related queries & work all over India He has also worked in Jaypee Brothers Medical Publishers Pvt Ltd as a Senior Executive Finance a well-known medical publisher of India & dealt their top management reporting He is having a total of 10 years experience in MS office products & has expertise in all of them, he had taught MS Excel to over 2000 professionals in the past year Currently, he is working as a Manager - Taxation in Alde Medi Impex Ltd a well known Medicine Manufacturer in India
Excellent Course, Value for Money, Learned lot of new shortcuts. Sir Explained all the things in Detail which makes everyone to understand in easy way.