Mastering MS Excel 101 (with exercises and solution videos)
A course on the key fundamentals of Microsoft Excel - including practice exercises and solution videos
4.66 (22 reviews)
59
students
4.5 hours
content
Jun 2018
last update
$54.99
regular price
What you will 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)
Screenshots
Related Topics
1718530
udemy ID
5/28/2018
course created date
9/18/2020
course indexed date
Bot
course submited by