Mashup of - MS Excel Beginner Course, MS Excel Intermediate Course, MS Excel Advanced Course, MS Word, Excel Dashboard, MS PowerPoint and MS Outlook
Excel Superstar offers courses that are uniquely designed to give you a complete tour of Excel and its Techniques. Anyone who wishes to master MS Excel or any other Microsoft Office Tools completely can do it here. The mission is to turn our learners into Absolute Professionals who have complete knowledge about MS Office Tools.
The video Tutorials that you get are authentic and put up into four distinct categories:
• MS Excel Course for Beginners
• MS Excel Course for Intermediate
• MS Excel Course for Advanced
• MS Excel Course for GOD MODE
Learn Excel in Hindi in 7 days
Full Beginner to Advanced Course
170+ Excel Videos
140+ Training Files
Online Access
Language Hindi-English Mix
Price including GST
Call 7021329219 for more info
Our Course has got 170+ video tutorials to benefit your Excel and other Microsoft Office course-based Knowledge. These video tutorials will help you to learn ‘How to deliver faster while doing less work.’ These are Educational Videos having fun elements as well so that the learners do not lose the interest. Fun Elements are the extended benefits to users which helps in memorizing the lessons well.
All the courses of MS Office are designed keeping the users in mind. It should deliver its complete value-adding productivity in the Professional life. Learn Advanced Excel Formulas and skills to Excel at work. This will help you to Achieve the quest to Work Smart and achieve more
The same video tutorials are put up on our Website and YouTube Channel. There are training files that will be made available to the Learners.
The list of things that you’re going to get from this course:
1. 170+ top-notch videos
2. All the training materials
MS Excel Beginner Mode
- AutoSum function in Excel
- Max function in Excel
- Average function in Excel
- CountBlank function in Excel
- Count and Counta function in Excel
- Master logical statements: True or False in Excel
- Simple logical statement: True or False in Excel
- Status bar in Excel
- Data Formatting in Excel
- Autofill dates in Excel
- Autofill numbers in Excel
- Sort Data in Excel | Descending order
- Sort Data in Excel | Alphabetically
- Sort by Dates in Excel
- Sort by Color in Excel
- Filter Data and then Calculate Sum in Excel
- Filter in Excel
- Working with filtered Data in Excel
- Number filter in Excel
- Remove Duplicates values in Excel
- Create Drop-down in Excel in 30 seconds
- Remove Drop-down in Excel
- Freeze Panes in Excel
- Format Painter in Excel
- Table Formatting in Excel
- Hyperlinks in Excel
- UPPER, LOWER, PROPER to change text case in Excel
- Trim function in Excel
- Round function in Excel
- MRound function in Excel
- How to store numbers as text in 1 minute in Excel
- Value function in Excel
- Len function in Excel
- Left – Right – Mid function in Excel
- Excel VBA (Macro Basic) in Excel
- Basics of Charts in Excel
MS Excel Intermediate Mode
- Pivot Table in Excel
- Vlookup function in Excel | Part 1
- Vlookup function in Excel | Part 2
- Vlookup function in Excel | Part 3
- Vlookup function in Excel | Part 4
- Vlookup function in Excel | Part 5
- Use Vlookup to find the Debtors Ageing analysis in Excel
- I bet you wouldn’t know this Vlookup trick in Excel | Score Grading
- I bet you wouldn’t know this Vlookup trick in Excel |Food Grading
- Using Vlookup find Service tax in Excel
- Excel vlookup in Multiple sheets in Excel
- Vlookup vs. Hlookup in Excel
- Excel Logical function – AND, OR in Excel
- IF function and Nested IF function in Excel
- Countif function in Excel | Cell Counting
- Sumif function in Excel | Adding numbers
- Avaergeif function in Excel
- Sumproduct function in Excel
- Calculate Year on Year percentage Growth in Excel
- Add serial numbers column before sorting in Excel
- 2 level sorting in Excel
- Subtotal function in Excel
- Format Painter Continuously in Excel
- Color multiple sheet tab in Excel
- Color cells based on cell value in Excel
- Color cells based on cell error or blanks in Excel
- Adding leading Zeroes in cheque number in Excel
- Calculate Fixed Deposit in Excel | Part 1
- Calculate Fixed Deposit in Excel | Part 2
- Formatting Tricks to write x3 in Excel
- Pie Chart in Excel
- Chart Trick – Best way to present Charts in Excel
- View bar in Excel
- Comments in Excel
- Print Excel Sheets in Excel
- Dashboard in Excel
MS Excel Advanced Mode
- Delete Error cells by using Go To Special in Excel
- Excel Shortcut: Ctrl + Enter in Excel
- Fill Intermittent Blank cells in Excel
- Match function in Excel | Part 1
- Match function in Excel | Part 2
- 2D Lookup | Vlookup and Match in Excel | Part 1
- 2D Lookup | Vlookup and Match in Excel | Part 2
- 2D Lookup | Vlookup and Match in Excel | Part 3
- 2D Lookup | Vlookup and Match in Excel | Part 4
- Roundup and Rounddown function in Excel
- Round function in Excel | Practical Applications
- Round Tricks from Excel Superstar in Excel
- Substitute function in Excel
- Activate Developer Tab in 2007-2016 in Excel
- Dashboard Trick – Create a spin Button in Excel
- Create Scenario in Excel
- Dashboard Trick – Create a scrollBar in Excel
- Hyperlinked Shortcuts in Excel
- Horizontal Sort in Excel
- Add a blank row in Excel
- Sort Data by Custom list in Excel
- Thermometer Chart in Excel
- Multi-axis Chart in Excel
- Formula Security in Excel
- Formula Audit in Excel
- 3D Data Consolidation in Excel Part 1 & 2 in Excel
- Goalseek in Excel
- Substitute and Replace function in Excel
- Joining data strings using CONCATENATE, & in Excel
- Reverse 2-way Lookup – INDEX with MATCH Part 1 in Excel
- Reverse 2-way Lookup – INDEX with MATCH Part 2 in Excel
- Reverse 2-way Lookup – INDEX with MATCH Part 3 in Excel
MS Excel GOD MODE
- Microsoft Add-in Fuzzy lookup in Excel
- Flash fill in Excel | Data Cleaning
- Hide a sheet so that no one can easily Unhide in Excel
- Confidential – Remove “Protect sheet” Password with Notepad in Excel
- Confidential – Remove “Protect workbook” Password with Notepad in Excel
- Making a text magically invisible in Excel
- OFFSET function in Excel
- Indirect function in Excel
- Text to Columns in Excel
Requirements are simple:
- Since you’re getting the Tutorials in the video form, you need a laptop or a Computer.
- You need Microsoft office tools in your PC like MS Excel.
- If you have a smartphone, such an add-on, view it while you’re free, traveling or whenever you wish to.
This offer is valid in all over India.
In case if you’ve any question or doubt, feel free to clear your doubts. We’re available for assistance.
You can mail us on - <info@excelsuperstar.org>
You can call on - +91 7021329219
Address: Suit No. 1 Sunderdham Society, Near Jai Vaibhav Society, Jambali Gali, Borivali West, Mumbai – 400 092
Find Bank details below to pay via Cash deposit in Bank:
Bank Name: YES BANK
Account Name: YODA LEARNING SOLUTIONS
IFSC Code: YESB0000213
Account Number: 021383800001525