we will introduce in this post five Excel crash courses that will help you boost you knowledge in Excel in very short time.
36 Minutes to Learn the Basics of Excel
Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Basics of Excel, great for interview prep!
What Will You Learn?
- Enter and edit Excel data. Format numbers, fonts and alignment.
- Make simple pivot tables and charts
- Create simple Excel formulas.
- Use Excel Functions IF and VLOOKUP
- Filter and sort lists of data. Find the “Top 10” values.
- Use Excel table functions to de-duplicate data and make totals.
- Understand how Excel is used in a business context to analyze data.
- Create a simple sales analysis report
Start Course: 36 Minutes to Learn the Basics of Excel
Useful Excel for Beginners
Learn the basics of Microsoft Excel and become an effective user.
Start Course: Useful Excel for Beginners
Excel Dashboards in an Hour
Learn how to create interactive Excel Dashboards in one hour. Be able to build Dashboards that are quick and easy to update. Know which chart to choose for your data.
Start Course: Excel Dashboards in an Hour
Excel Formulas and Functions Cheat Sheet
Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.
Start Course: Excel Formulas and Functions Cheat Sheet
Excel VBA programming by Examples
Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook. Learn to automate their time consuming repeatitive tasks for more accuracy and less time consuming.
Start Course: Excel VBA programming by Examples
Useful Links
If you don’t have it, Check the below links:- Download Hiren’s Boot 11.0 ISO
- Download Hiren’s Boot 15.2 ISO
- Install Hiren’s Boot ISO to Bootable USB