Complete Excel Tutorial For Beginners

Complete Excel Tutorial For Beginners
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.41 GB
Genre: eLearning Video | Duration: 58 lectures (3 hour, 52 mins) | Language: English

Learn the basics of Excel and build a solid understanding of how to use it

What you'll learn

Enter numbers and formulas in excel
The layout of excel
Creating clean spreadsheets
Use formulas to automate your work
Pivot tables
IF functions
Vlookup & Hlookup
Index & Match
Financial charts
Graphs
Data validation
Forecasting
Data Sorting and Filtering
Absolute References

Requirements

Should be able to use computer at beginner level
Should be able to download Microsoft Excel on computer
Eagerness to learn

Description

Why this course is for you?

You want to learn the basics of Excel for professional or personal reasons but you have little to no knowledge of how Excel works. You have heard that Excel will allow you to automate work and make your life easier but you don't know where to start. You know that a lot of jobs now require Excel skills and you want to build up your skills for these jobs.

What you will learn:

The basics of Excel

How to work with the Excel interface

How to open and save an Excel file

How to enter numbers and text into Excel

How to enter formulas into Excel

How to have your formulas automatically update

Common Excel shortcuts

Creating graphs and charts

How to copy, cut, and paste data

Different formatting options and tools

How to create a budget

Cell referencing

Inserting images and shapes

What you will need:

A computer, laptop, or tablet

Microsoft Excel

No prior Excel knowledge needed

Hunger and willingness to learn

Who this course is for:

Anyone looking to learn Excel for school, work, or personal reasons
Anyone who wants to take their Excel skills from beginner to intermediate