Excel Training Online

Copy formula with reference to the right

Tutorial for Beginners

  1. Understanding Excel’s keywords
  2. Resizing rows and columns in Excel
  3. How to do a calculation in Excel?
  4. Inserting and removing rows and columns easily
  5. Copying data, tips and tricks to save time
  6. Moving, swapping, and duplicating rows and columns
Format phone numbers

Tools you must known

  1. How to format numbers in Excel?
  2. Text orientation and alignment to enhance your spreadsheets
  3. Sorting data, tips and tricks
  4. Filtering your data
  5. Automatically extracting or merging cells.
  6. Creating a dropdown menu
Copy a fomula with a dollar

First functions

  1. The SUM functions, from basics to pro tips
  2. AVERAGE, MIN, MAX, COUNT, COUNTA
  3. Study Case – Calculate the weekly profit
  4. How to use the Dollar in your formula?

Excel Training Online

Tutorial for Beginners