Your cart is empty.
Keep shoppingMastering MS Excel 101 (with exercises and solution videos)
63 students
Mastering MS Excel 101 (with exercises and solution videos)
A course on the key fundamentals of Microsoft Excel - including practice exercises and solution videos
Created byJef Jacobs
Last updated 6/2018
English
What you'll learn
- Enter data in any format (e.g. numbers, text or dates)
- How to select data and navigate Excel in a quick and efficient way
- How to format cells so that data is easy to read and understand
- Manage, clean and organize large tables or spreadsheets
- Use formulas and functions for completing calculations (SUM, COUNT, AVERAGE, etc.)
- Dealing with annoying errors in Excel
- How to copy and paste data (and how to manage formulas and formatting)
- How to fix cell references using the "$" symbol
- Using Text based formulas (e.g. TRIM, PROPER, and CONCATENATE)
- The power of the IF function and its derivatives (e.g. AND, OR, SUMIF, COUNTIF)
- Advanced referencing functions - VLOOKUP, HLOOKUP and OFFSET
- Drawing visually effective graphs and charts (and how to format them)
Explore related topics
Course content
11 sections • 44 lectures • 4h 39m total length
Requirements
- Access to Microsoft Excel (any version)
Description
Hello there and welcome to Mastering Microsoft Excel 101
You have come to the right place if you want to improve your Microsoft Excel skills. This course will help you feel confident rather than intimidated by Microsoft Excel.
Excel has played a big part in my working career as a university lecturer, management consultant and analytics manager. I hope that you too can make Excel work for you.
This course is structured from basic topics to more advanced ones, but you're welcome to skip and jump to any chapter that meets your work, life or interest needs. Each chapter includes downloadable files that you can use to practice what was discussed in each video or to test your overall knowledge. Remember, only by practicing will your skills improve.
Happy learning!
Jef
Who this course is for:
- Anyone interested in improving their Microsoft Excel skills