Excel Fundamentals
- Description
- Curriculum
- Reviews
- Grade
Overview & Introduction
Interface
Data Entry & Working with Cells
- 15
Remember, the worksheet area is... - 16Data is arranged in rows and columns
- 17Rows
- 18Columns
- 19Cell References
- 20Cell Reference vs Cell value
- 21
Basic Data Entry in Excel - 22Review: How to do Data Entry
- 23Data Entry Tips
- 24
Data entry assignment - 25Data Entry Tip: Content in the formula bar
- 26
Excel Data entry and structuring checklist
Cell and Data Formatting
- 27Quick data entry and formatting
- 28Basic Formatting located In the Home Tab
- 29Basic Formatting you can do
- 30Data (Number, text…) formatting
- 31Screencast: How to format cells
- 32Data (Number, text…) formatting option by data type
- 33How to select cells to format
- 34How to access formatting options
- 35Excel built-in table Formatting
- 36Excel built-in table Formatting
- 37Formatting assignment
Formulas and Functions
- 38The Problem
- 39Solution: The little Excel helpers
- 40Formulas
- 41Using formulas in Excel
- 42Functions
- 43Functions' Usefulness
- 44Using functions in Excel
- 45Referencing multiple cells
- 46Benefits of formulas & functions
- 47Cheat sheet - Popular Basic Functions
- 48Tips for using formulas and functions
- 49Formulas and functions
Basic Charts and Graphs
Data Organisation and Summary
Saving, Printing, Closing
Tips, Shortcuts and Best MS Excel Practices
Please, login to leave a review
Course details
Lectures 71
Assignments 4
Quizzes 1
Level Beginner
Course requirements
- know how to use a computer
- know how top launch software
- know how to go online and browse the web
Popular courses
