Excel: Beginning to Expert - Complete Course (updated)
Learn all the great features like Pivot Tables, Vlookup, Charts, Flash Fill, Auto Fill and so much more!
4.58 (269 reviews)
3,030
students
9.5 hours
content
Aug 2020
last update
$59.99
regular price
What you will learn
Move around efficiently in Excel
Understand how to use the Excel interface and Ribbon
Effectively use the Status Bar
Use the many help features in Excel
Enter data quickly and effeciently
Create formulas and use built-in functions
Calculate dates and times
Quickly format text, numbers, percentages, and currency
Create conditional formatting such as data bars and highlighted text based on rules
Create and format tables easily
Create slicers to quickly filter table data
Create and format shapes, images, and SmartArt to enhance your data
Quickly "best fit" columns and rows
Easily shift, insert, and move any data in rows or columns
Use a wide rang of tools to prpare data for looking professional when printed
Create insightful charts and control every aspect of layout and detail
Freeze rows and or columns for better views of worksheet data
View multiple worksheets or multiple workbooks ata the same time
Moving, copying, grouping, and formating worksheets and worksheet tabs
Undertand how to use the powerful IF, Vlookup and other Power Functions
Use security and Sharing features
Sort any column and sort multiple items at the same time
Automatically insert subtotal data
Filter out any item or data
Quickly find and replace data
Split data such and City, State, Zip between columns for better sorting
Remove duplicate data easily
Create drop down "pick lists"
Use validation tools to only accept specific data in specified cells
Create pivot table with ease
Create pivot charts and change them quickly
Use dozens of Excel hacks, short cuts, tricks, and tips!
Screenshots
Related Topics
1114336
udemy ID
2/14/2017
course created date
5/30/2020
course indexed date
Bot
course submited by