Tutorials for MS Excel

This course is created for Excel beginners and has been designed for computer users who are willing to learn Microsoft Excel in simple steps. At the end of this course you will become an Excel Expert for sure. Also, even Excel Experts can improve their Excel Skills by the help of this course.

Tutorials are with English subtitles. Exercise files are included for each lecture. Shorcut Keys indicated for each lecture if available.

You will begin at beginner level and reach to intermediate level. You will use Excel effectively in your daily life, such as job, personal data usage etc.

Course consists of 11 Chapters. New Chapters will be added.

Take this course to make your life easy and organized with Excel.

List of Tutorials (New tutorials will be added for free.)

Chapter 1 - Introduction

1.1 Menu
1.2 Workbook
1.3 Worksheet
1.4 Quick Access Toolbar
1.5 Column Row Cell Status

Chapter 2 - Data Entry

2.1 Entering Data
2.2 Auto Fill and Flash Fill
2.3 Dates and Times
2.4 Undo Redo
2.5 Comments
2.6 New Open Save and Save As

Chapter 3 - Formulas and Functions

3.1 BasicFormulas
3.2 CopyFormulas
3.3 Hierarchy
3.4 Absolute References
3.5 AutoSum

Chapter 4 - Formatting

4.1 Font and Borders
4.2 Column Width and Row Height
4.3 Alignment
4.4 Number
4.5 Date and Time Format
4.6 Conditional Formatting
4.7 Tables
4.8 Illustrations

Chapter 5 - Worksheet Layout

5.1 Insert and Delete Cells
5.2 Hide and Unhide
5.3 Cut Paste Copy Move
5.4 Find and Replace

Chapter 6 - Print

6.1 Page Setup and Scale to Fit
6.2 PageBreakPreview and PageLayout
6.3 Print

Chapter 7 - Charts

7.1 Recommended Charts
7.2 Creating Charts
7.3 Chart Formatting Shortcuts
7.4 Change Chart Type
7.5 Formatting Chart Elements
7.6 Trendline
7.7 Sparklines

Chapter 8 - Worksheet Views

8.1 Freeze Panes and Split
8.2 Auto Outline

Chapter 9 - Multiple Worksheets and Workbooks

9.1 Linking Data
9.2 Edit Links

Chapter 10 - IF, VLOOKUP, and Other Functions

10.1 IF Function
10.2 VLOOKUP Function
10.3 COUNTIF Function

Chapter 11 - Security and Sharing

11.1 Protect Sheet
11.2 Lock Cells
11.3 Protect Workbook
11.4 Workbook Password
11.5 Share Workbook
11.6 Track Changes