we will introduce in this post five Excel crash courses that will help you boost you knowledge in Excel in very short time.
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
Learn the basics of Microsoft Excel and become an effective user.
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.
Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.
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.
Useful LinksIf 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