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. How to calculate VAT in Excel?
  8. Excel Split Date and Time
  9. Exchange rate in Excel 🏛️
  10. Master XLOOKUP function in Excel
  11. Add Emojis to your Excel charts or slicers
  12. UNIQUE Function – Remove duplicates with formulas
  13. Why Excel Formulas Use Comma or Semi-Colon
  14. Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
  15. Change the default Date format in Excel
  16. Compare Two Columns in Excel Easily
  17. Add filter option for all your pivot table columns
  18. Dynamic SUM in Excel
  19. COUNTIFS Function: Mastering Multi-Criteria Counting
  20. SUMIFS Function in Excel

Recent Posts