Home > Courses > Microsoft > Office Productivity > Mastering MS Excel 101 (with exercises and solution videos)
   4.8  6 reviews on Udemy

Mastering MS Excel 101 (with exercises and solution videos)

A course on the key fundamentals of Microsoft Excel - including practice exercises and solution videos
Course from Udemy
 28 students enrolled
 en
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)

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

Mastering MS Excel 101 (with exercises and solution videos)
$ 39.99
per course
Also check at

FAQs About "Mastering MS Excel 101 (with exercises and solution videos)"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

CONTACT

[email protected]

SOCIAL NETWORK

Copyright © Elektev
Privacy Policy