Brief Introduction
Learn the basics of Excel and build a solid understanding of how to use itDescription
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
Requirements
- Requirements
- Should be able to use computer at beginner level
- Should be able to download Microsoft Excel on computer
- Eagerness to learn
Knowledge
- 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