Chapter 1
  • Introduction
  • Entering data into cell
  • Entering data into cells
  • Alignment of entered data
  • Alignment of entered data
  • Formatting the entered data
  • Formatting the text
  • Autofill in depth
Chapter 2
  • Inserting and editing shapes
  • Inserting shapes
  • Cut copy and paste
  • Cut copy and paste
  • Selection of data
  • Selection of data
  • Inserting rows and columns
  • Inserting rows and columns
Chapter 3
  • Formulas
  • Formulas
  • Functions
  • Functions
  • Creating range names
  • Creating range names
  • Using ranges in formulas
  • Using ranges in formula
  • Basic functions
  • Basic function
  • References
  • References
  • If Function
  • if function
  • Sumif and Averageif
  • Sumif and averageif function
  • General math functions
  • General math function
  • More about dates
  • More on dates
  • Using formula across sheets
  • Using formula across sheet
  • Formula auditing
  • Formula auditing
Chapter 4
  • Conditional formatting
  • More on conditional formatting
  • Conditional formatting
  • More on conditional formatting
  • Smart art
  • Smart Art
  • Inserting tables
  • Inserting table
Chapter 5
  • Worksheet Themes
  • Printing
  • Printing
  • More on printing
  • More on printing
  • Headers and footers
  • Header and footer
  • Inserting watermarks
  • Inserting watermark
  • Creating PDF
  • Creating PDF
  • Freeze Pane
Chapter 6
  • Introduction to charts
  • Inserting Column chart
  • Inserting column charts
  • Customizing your chart
  • Line, area and sparline chart
  • Line area and sparkline charts
  • Editing the data series of charts
Chapter 7
  • Hiding Rows And Columns
  • Outline
  • Working with sheets
  • Working with sheets
  • Find and select sort and filter
  • Sort
  • Comment
  • Comments
  • Password Protected
  • Password
Chapter 8
  • Compound interest rate
  • Loan calculations
  • Loan calculation
  • Present value,period and rate
  • Present value, period and rate
  • Creating loan schedule
  • Using two way data table
  • Goal seek
  • Joining cells
  • Joining cells
Chapter 9
  • Splitting the cell data
  • Upper and lower case
  • Upper and lower case
  • Data Validation