Useful Excel for Beginners -

INDZARA
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
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 stores 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
1. Introduction (7 m)
2. Basics of Excel (11 m)
3. Entering Data (2 h 45 m)
o Keyboard shortcuts
o Navigating in a worksheet
o Selecting Cells
o Number Formatting
o Inserting & Deleting
4. Formatting (37 m)
5. Editing (1 h 10 m)
o Auto Fill
o Cut, Copy, Paste
o Sort & Filter
o Find & Replace
6. Saving (10 m)
7. Viewing (7 m)
8. Calculations (2 h 6 m)
o Formula
o 25 functions
o Errors
9. Visualizing (1 h 20 m)
o Charts
o Conditional Formatting
o Illustrations
10. Analyzing (31 m)
o Pivot Tables
o Slicers
11. Tables (16 m)
12. Sharing (12 m)
o Saving and Sending
o Printing
Table of Videos
Useful Excel for Beginners - Course - Overview
Useful Excel for Beginners - Chapter 1 Lesson 1 - Introduction
Useful Excel for Beginners - Chapter 2 Lesson 1 - Launching Excel
Useful Excel for Beginners - Chapter 2 Lesson 2 - Workbooks and Worksheets
Useful Excel for Beginners - Chapter 2 Lesson 3 - Fundamentals of Excel
Useful Excel for Beginners - Chapter 3 Lesson 1 - How To Enter Data
Useful Excel for Beginners - Chapter 3 Lesson 2 - AutoFit
Useful Excel for Beginners - Chapter 3 Lesson 3 - Keyboard Navigation
Useful Excel for Beginners - Chapter 3 Lesson 4 - Auto Complete
Useful Excel for Beginners - Chapter 3 Lesson 5 - Entering Numbers
Useful Excel for Beginners - Chapter 3 Lesson 6 - Navigating Edges
Useful Excel for Beginners - Chapter 3 Lesson 7 - Navigating First & Last Used Cells
Useful Excel for Beginners - Chapter 3 Lesson 8 - Selecting Cells - Introduction
Useful Excel for Beginners - Chapter 3 Lesson 9 - Selecting Cells - ShiftArrow
Useful Excel for Beginners - Chapter 3 Lesson 10 - Selecting Cells - CtrlShiftArrow
Useful Excel for Beginners - Chapter 3 Lesson 11 - Selecting Cells - Mouse Click Drag
Useful Excel for Beginners - Chapter 3 Lesson 12 - Selecting Cells MouseClick ShiftClick
Useful Excel for Beginners - Chapter 3 Lesson 13 - Selecting Cells - All Cells & Used Cells
Useful Excel for Beginners - Chapter 3 Lesson 14 - Selecting Cells - Rows Columns All
Useful Excel for Beginners - Chapter 3 Lesson 15 - Selecting Cells - Non-Contiguous Cells
Useful Excel for Beginners - Chapter 3 Lesson 16 - Selecting Cells - Summary
Useful Excel for Beginners - Chapter 3 Lesson 17 - Number Formatting - Introduction
Useful Excel for Beginners - Chapter 3 Lesson 18 - Number Formatting General Text
Useful Excel for Beginners - Chapter 3 Lesson 19 - Number Formatting Number Fraction
Useful Excel for Beginners - Chapter 3 Lesson 20 - Number Formatting Currency
Useful Excel for Beginners - Chapter 3 Lesson 21 - Number Formatting Accounting
Useful Excel for Beginners - Chapter 3 Lesson 22 - Number Formatting - Percentage
Useful Excel for Beginners - Chapter 3 Lesson 23 - Number Formatting Date
Useful Excel for Beginners - Chapter 3 Lesson 24 - Number Formatting Time
Useful Excel for Beginners - Chapter 3 Lesson 25 - Number Formatting Summary
Useful Excel for Beginners - Chapter 3 Lesson 26 - Inserting Deleting Rows Columns Cells
Useful Excel for Beginners - Chapter 4 Lesson 1 - Formatting Introduction
Useful Excel for Beginners - Chapter 4 Lesson 2 - Formatting Bold Italics Underline
Useful Excel for Beginners - Chapter 4 Lesson 3 - Formatting Borders
Useful Excel for Beginners - Chapter 4 Lesson 4 - Formatting Fill Font
Useful Excel for Beginners - Chapter 4 Lesson 5 - Formatting Alignment
Useful Excel for Beginners - Chapter 4 Lesson 6 - Formatting Format Painter Clear Formats
Useful Excel for Beginners - Chapter 5 Lesson 1 - Editing Cell Content
Useful Excel for Beginners - Chapter 5 Lesson 2 - Multiple Lines of Text
Useful Excel for Beginners - Chapter 5 Lesson 3 - Same Data In Multiple Cells Ctrl Enter
Useful Excel for Beginners - Chapter 5 Lesson 4 - Same Data In Multiple Cells Auto Fill
Useful Excel for Beginners - Chapter 5 Lesson 5 - Same Data In Multiple Cells Copy Paste
Useful Excel for Beginners - Chapter 5 Lesson 6 - Cut Paste
Useful Excel for Beginners - Chapter 5 Lesson 7 - Auto Fill Series
Useful Excel for Beginners - Chapter 5 Lesson 8 - Sort
Useful Excel for Beginners - Chapter 5 Lesson 9 - Editing - Filter
Useful Excel for Beginners - Chapter 5 Lesson 10 - Find Replace
Useful Excel for Beginners - Chapter 6 Lesson 1 - Saving Excel Documents
Useful Excel for Beginners - Chapter 7 Lesson 1 - Viewing - Freeze Panes
Useful Excel for Beginners - Chapter 8 Lesson 1 - Calculations - Intro to Formulas
Useful Excel for Beginners - Chapter 8 Lesson 2 - Calculations - Editing Formula
Useful Excel for Beginners - Chapter 8 Lesson 3 - Calculations - Introduction to Functions
Useful Excel for Beginners - Chapter 8 Lesson 4 - Calculations - Entering Functions
Useful Excel for Beginners - Chapter 8 Lesson 5 - Calculations - Types of Functions
Useful Excel for Beginners - Chapter 8 Lesson 6 - Calculations - MIN MAX AVERAGE
Useful Excel for Beginners - Chapter 8 Lesson 7 - Calculations - Copying Formulas
Useful Excel for Beginners - Chapter 8 Lesson 8 - Calculations - Cell References
Useful Excel for Beginners - Chapter 8 Lesson 9 - Calculations - Paste Formulas
Useful Excel for Beginners - Chapter 8 Lesson 10 - Calculations - Counting
Useful Excel for Beginners - Chapter 8 Lesson 11 - Calculations - Looking Up
Useful Excel for Beginners - Chapter 8 Lesson 12 - Calculations - Date Functions
Useful Excel for Beginners - Chapter 8 Lesson 13 - Calculations - Text Functions
Useful Excel for Beginners - Chapter 8 Lesson 14 - Calculations - SUMIF function
Useful Excel for Beginners - Chapter 8 Lesson 15 - Calculations - IF function
Useful Excel for Beginners - Chapter 8 Lesson 16 - Calculations - Errors
Useful Excel for Beginners - Chapter 8 Lesson 17 - Calculations - Summary
Useful Excel for Beginners - Chapter 9 Lesson 1 - Visualizing - Introduction to Charts
Useful Excel for Beginners - Chapter 9 Lesson 2 - Visualizing - Creating a Chart
Useful Excel for Beginners - Chapter 9 Lesson 3 - Visualizing - Chart Components Chart Labels
Useful Excel for Beginners - Chapter 9 Lesson 4 - Chart Components Chart Background
Useful Excel for Beginners - Chapter 9 Lesson 5 - Chart Components Chart Axes
Useful Excel for Beginners - Chapter 9 Lesson 6 - Chart Components Format Design
Useful Excel for Beginners - Chapter 9 Lesson 7 - Chart Types
Useful Excel for Beginners - Chapter 9 Lesson 8 - Conditional Formatting Introduction
Useful Excel for Beginners - Chapter 9 Lesson 9 - Conditional Formatting Format All Cells
Useful Excel for Beginners - Chapter 9 Lesson 10 - Conditional Formatting Format Only Cells
Useful Excel for Beginners - Chapter 9 Lesson 11 - Conditional Formatting More RuleTypes
Useful Excel for Beginners - Chapter 9 Lesson 12 - Conditional Formatting Formula Based
Useful Excel for Beginners - Chapter 9 Lesson 13 - Conditional Formatting Summary
Useful Excel for Beginners - Chapter 9 Lesson 14 - Visualizing Illustrations
Useful Excel for Beginners - Chapter 10 Lesson 1 - Analyzing Intro to PivotTables
Useful Excel for Beginners - Chapter 10 Lesson 2 - Creating PivotTable
Useful Excel for Beginners - Chapter 10 Lesson 3 - Analyzing - PivotTable Summarization Types
Useful Excel for Beginners - Chapter 10 Lesson 4 - Analyzing PivotTable Tools
Useful Excel for Beginners - Chapter 10 Lesson 5 - Analyzing - PivotTable PivotCharts
Useful Excel for Beginners - Chapter 11 Lesson 1 - Tables - CreatingTable
Useful Excel for Beginners - Chapter 11 Lesson 2 - Tables Functionality
Useful Excel for Beginners - Chapter 12 Lesson 1 - Sharing - Save Send
Useful Excel for Beginners - Chapter 12 Lesson 2 - Sharing - Printing
Useful Excel for Beginners - Chapter 13 Lesson 1 FinalThoughts

Simple and Effective Excel Templates: http://www.indzara.com/