Share Description
In this course, you will learn:-
- A step-by-step approach to using Microsoft Excel, starting with the fundamentals.
Syllabus:-
-
Opening Excel and creating a new sheet
-
Saving Excel files
-
The important file types
-
The formula bar
-
Adding, Modifying, and Deleting data in cells
-
Creating a new workbook
-
Develop the habit of using file... save as
-
The important data types
-
Before we start: Let's zoom in and out
-
How Excel works
-
The relative cell reference
-
Review: Enter and leave edit mode
-
Example using relative cell references
-
Relative vs. absolute cell references
-
Test your skills | Create cell references
-
Test your skills | Copy and paste a cell reference
-
Add | Subtract | Multiple | Divide
-
Add numbers using a more complicated formula
-
Review: Cut and Paste | "Moving" Cells
-
Recap: Select | Move (cut and paste) | Copy and paste
-
Very! Fast Overview: Creating a budget
-
Building the budget | Part 1
-
Building the budget | Part 2
-
How to make good formulas even better
-
Building the budget | Part 3
-
Very! fast overview: Creating a personal budget
-
Getting set up
-
Creating the Income Row
-
Creating the expenses
-
Calculating savings/loss
-
Expressing expenses as a % of income
-
Easily calculate a multi-year budget
-
Formatting text: changing font
-
Review: Cut and paste | Move text
-
Resizing columns
-
Cleaning up | Wrap text
-
Adding fake values
-
Formatting text: centering
-
Selecting all text at once
-
Review: Adding a SUM function
-
Review: Copy and paste the function
-
Formatting text: center | fill with color | sort
-
Improve the first function
-
Review: Use the fill feature | Merge cells and center text
-
Improve the formula using the SUMPRODUCT function
