Excel Training Online

Tutorial for Beginners

Popular subjects

CONDITIONAL FORMATING
Excel charts
Excel test
Excel functions
Dynamic Arrays
finance
Lookup
Pivot table

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. Exercise – Quarterly result with basic formula
  3. AVERAGE, MIN, MAX, COUNT, COUNTA
  4. Study Case – Calculate the weekly profit
  5. How to use the Dollar in your formula?

Most Viewed Posts

  1. Displaying Negative Numbers in Parentheses in Excel
  2. Top 10 Excel Functions You Must Know
  3. How to make automatic calendar in Excel
  4. Dash for a zero in Excel automatically
  5. Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel
  6. Date Format in Excel
  7. Use Excel Online for Free
  8. Excel Split Date and Time
  9. How to calculate VAT in Excel?
  10. Exchange rate in Excel 🏛️
  11. Add Emojis to your Excel charts or slicers
  12. Master XLOOKUP function in Excel
  13. Why Excel Formulas Use Comma or Semi-Colon
  14. UNIQUE Function – Remove duplicates with formulas
  15. Change the default Date format in Excel
  16. Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
  17. Add filter option for all your pivot table columns
  18. Compare Two Columns in Excel Easily
  19. How to do Percentage in a Pivot Table in Excel?
  20. Dynamic SUM in Excel

Recent Posts