MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 58 lectures (3 hour, 52 mins) | Size: 1.41 GB
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
Screenshots
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction