Excel: Beginning to Expert - Complete Course (updated)

Rating 4.25 out of 5 (247 ratings in Udemy)

What you'll 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 …

Rating 4.25 out of 5 (247 ratings in Udemy)

What you'll 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!

Description

Microsoft Excel 2019Complete Course. New topics added as new features arrive.

This Microsoft Excel course was recorded with the latest version of Excel365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010and2013 versions.

Enroll now to get over 9 hours and over 70 lessonsof professional training!

Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel.Microsoft Excel is one ofthe most popular spreadsheet and business productivitytools in the world.I willbe your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration.

Stop struggling through your dailytasks at workor wishing you had the skills to advance.Now you can quickly and easily go from beginner to intermediatestep-by-step with clear video lessons and easy to use practice files designed just for this course.

When you have finished this course you will be able to performthe most popular Excel functions and features and have theconfidence to take on new challenges, responsibilities and opportunities.Here are a few of the highly sought afterskills you will acquire in Excel:

Create attractive and effectivespreadsheets
Sortand formatlarge sets of data
Createand formattables quickly
Master usefulfunctions likeSUM, VLOOKUP, IF, AVERAGE, and many others
Create dynamic Pivot Tables and PivotCharts
Automate your tasks with Macros
Secure workbooks and worksheets
Use conditional formatting to highlight data

Enroll now and take the next step in making a real difference in your careerand income potential. You are only a few clicks away from your new future!

Duration 9 Hours 58 Minutes

Paid

Self paced

All Levels

English (US)

2967

Rating 4.25 out of 5 (247 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.