Excel – Beginner

Basics

  • Getting Started
  • Explore Window
  • Backstage
  • Entering Values
  • Move Around
  • Save Workbook
  • Create Worksheet
  • Copy Worksheet
  • Hiding Worksheet
  • Delete Worksheet
  • Close Workbook
  • Open Workbook
  • Context Help

Editing Worksheet

  • Insert Data
  • Select Data
  • Delete Data
  • Move Data
  • Rows & Columns
  • Copy & Paste
  • Find & Replace
  • Spell Check
  • Zoom In-Out
  • Special Symbols
  • Insert Comments
  • Add Text Box
  • Undo Changes

 Formatting Cells

  • Setting Cell Type
  • Setting Fonts
  • Text Decoration
  • Rotate Cells
  • Setting Colors
  • Text Alignments
  • Merge & Wrap
  • Borders and Shades
  • Apply Formatting

 Formatting Worksheets

  • Sheet Options
  • Adjust Margins
  • Page Orientation
  • Header and Footer
  • Insert Page Breaks
  • Set Background
  • Freeze Panes
  • Conditional Format

 Working with Formula

  • Creating Formulas
  • Copying Formulas
  • Formula Reference
  • Using Functions
  • Bultin Functions

 Advanced Operations

  • Data Filtering
  • Data Sorting
  • Using Ranges
  • Data Validation
  • Using Styles
  • Using Themes
  • Using Templates
  • Using Macros
  • Adding Graphics
  • Cross Referencing
  • Printing Worksheets
  • Email Workbooks
  • Excel- Translate Worksheet
  • Workbook Security
  • Data Tables
  • Pivot Tables
  • Simple Charts
  • Pivot Charts