Free Excel Course
Introduction
‘Useful Excel for Beginners’ is a free on-demand video-based course tailored for beginners who are interested in learning Microsoft Excel.
This course is a series of 89 videos running for slightly more than 9.5 hours. You can watch the videos at your own schedule and pause/replay as you would like. The course covers the concepts and features that I believe will help you get started and become a functional user of Excel.
Course Highlights
Highlights of the course
- 9.5 hours of videos covering all the key concepts and topics
- Tailored for those who have never used Excel before and beginner level users
- Easy to follow video demonstrations where all the operations are performed on screen
- Create report on a fictional book store’s employees’ monthly work hours and salaries
- Analyze product sales, customer and sales trends for the book store
- 25 most used functions covered with examples
- Important keyboard shortcuts highlighted
- Includes Conditional Formatting, PivotTables and Tables
- Downloadable exercise files so that you can easily follow the course
Table of Contents
- Introduction (7 m)
- Basics of Excel (11 m)
- Entering Data (2 h 45 m)
- Keyboard shortcuts
- Navigating in a worksheet
- Selecting Cells
- Number Formatting
- Inserting & Deleting
- Formatting (37 m)
- Editing (1 h 10 m)
- Auto Fill
- Cut, Copy, Paste
- Sort & Filter
- Find & Replace
- Saving (10 m)
- Viewing (7 m)
- Calculations (2 h 6 m)
- Formula
- 25 functions
- Errors
- Visualizing (1 h 20 m)
- Charts
- Conditional Formatting
- Illustrations
- Analyzing (31 m)
- Pivot Tables
- Slicers
- Tables (16 m)
- Sharing (12 m)
- Saving and Sending
- Printing
