Microsoft Excel 2013 – Be the Excel master !!

Course Curriculum

Chapter 1: Chapter 1

Lecture 1: Introduction

Lecture 2: Entering data into cell

Lecture 3: Alignment of entered data

Lecture 4: Formatting the entered data

Lecture 5: Autofill in depth

Chapter 2: Chapter 2

Lecture 1: Inserting and editing shapes

Lecture 2: Cut copy and paste

Lecture 3: Selection of data

Lecture 4: Inserting rows and columns

Chapter 3: Chapter 3

Lecture 1: Formulas

Lecture 2: Functions

Lecture 3: Creating range names

Lecture 4: Using ranges in formulas

Lecture 5: Basic functions

Lecture 6: References

Lecture 7: If Function

Lecture 8: Sumif and Averageif

Lecture 9: General math functions

Lecture 10: More about dates

Lecture 11: Using formula across sheets

Lecture 12: Formula auditing

Chapter 4: Chapter 4

Lecture 1: Conditional formatting

Lecture 2: More on conditional formatting

Lecture 3: Smart art

Lecture 4: Inserting tables

Chapter 5: Chapter 5

Lecture 1: Worksheet Themes

Lecture 2: Printing

Lecture 3: More on printing

Lecture 4: Headers and footers

Lecture 5: Inserting watermarks

Lecture 6: Creating PDF

Lecture 7: Freeze Pane

Chapter 6: Chapter 6

Lecture 1: Introduction to charts

Lecture 2: Inserting Column chart

Lecture 3: Customizing your chart

Lecture 4: Line, area and sparline chart

Lecture 5: Editing the data series of charts

Chapter 7: Chapter 7

Lecture 1: Hiding Rows And Columns

Lecture 2: Outline

Lecture 3: Working with sheets

Lecture 4: Find and select sort and filter

Lecture 5: Comment

Lecture 6: Password Protected

Chapter 8: Chapter 8

Lecture 1: Compound interest rate

Lecture 2: Loan calculations

Lecture 3: Present value,period and rate

Lecture 4: Creating loan schedule

Lecture 5: Using two way data table

Lecture 6: Goal seek

Lecture 7: Joining cells

Chapter 9: Chapter 9

Lecture 1: Splitting the cell data

Lecture 2: Upper and lower case

Lecture 3: Data Validation