Shopping Cart

No products in the cart.

Back to Course

MS Excel Masterclass

0% Complete
0/0 Steps
  1. Introduction
    Welcome to the course
  2. Course Resources
  3. Excel Basics
    Basics
  4. Worksheet Basics
  5. Entering values and Formulas
  6. Data Formats
  7. Data Handling Basics - Cut, Copy and Paste
  8. Saving and Printing - Basics
  9. Essential Formulas
    Basic Formula Operations
  10. Mathematical Functions
  11. Difference between RANK, RANK.AVG and RANK.EQ
  12. Practice Session 1: Mathematical Functions
  13. Textual Functions
  14. Practice Session 2: Textual Functions
  15. Logical Functions
  16. Practice Session 3: Logical Functions
  17. Date-Time Functions
  18. Practice Session 4: Date-Time Functions
  19. Lookup Functions (V Lookup, Hlookup, Index-Match)
  20. Practice Session 5: Lookup Functions
  21. Data Tools
    Data Tools
  22. Practice Session 6: Data Tools
  23. Formatting data and tables
    Formatting data and tables
  24. Practice Session 7: Formatting
  25. Pivot Tables
    Pivot Tables
  26. Practice Session 8: Pivot tables
  27. Excel Charts
    Excel Charts - Categories of messages that can be conveyed
  28. Elements of charts
  29. The Easy way of creating charts
  30. Bar and column charts
  31. Formating charts
  32. Line Charts
  33. Area Charts
  34. Why we should avoid Pie charts
  35. Scatter plot or XY chart
  36. Frequency Distribution and Histograms
  37. Waterfall Charts
  38. Sparklines
  39. Pivot Charts
    Pivot Charts
  40. Practice Session 9: Charts
  41. Named Ranges
    Named Ranges
  42. Indirect Function
  43. Excel Shortcuts
    Shortcuts
  44. Practice Session 10: Shortcuts
  45. Macros
    Macros
  46. Practice Session 11: Macros
  47. Advanced Excel
    Advanced Excel: Analytics in Excel
  48. Bonus Section
    Congratulations
MS Excel Masterclass Mathematical Functions
Lesson 10 of 48
In Progress

Mathematical Functions

Start-Tech Academy

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • Mention this member in posts

Please allow a few minutes for this process to complete.

Report

You have already reported this .

Course Categories

Quisque velit nisi, pretium ut lacinia in, elementum id enim. 

Connect with us
Facebook Twitter Youtube Icon-linkedin Instagram