Excel Formulas and Functions

Course Outline:

  • The 3 Golden rules of Excel
  • The structure of a Formula or Function
  • There are 13 methods to add numbers
  • Types of Cell References
  • Financial Functions: PMT, FV, PV
  • Logical Functions IF, OR, AND, IFs.
  • Date and Time Functions.
  • Naming Cells and Ranges
  • TEXT functions: TRIM, LOWER, UPPER, PROPER, REPLACE, SUBSTITUTE, SEARCH, FIND
  • LOOKUP Functions
  • Conditional SUM Functions: SUMIF, SUMIFS, SUMPRODUCT
  • Building an Amazing project using all above techniques.

With the course you receive:

  • Practice files
  • Multiple resources and references.
  • Lifetime access to the course recording
  • Certificate of Completion
  • Regular price: USD 130.00 – Sale Price: USD 79.00

Course Price

Sale Price: USD 79.00
Regular Price: USD 130.00
*You will be charged the equivalent in Canadian Dollars
Equivalent price in Canadian Dollars is
Regular 169 CAD - Sale Price 104 CAD
Upcoming Course Date:
Saturday, 16 Apr 2022 (Fully Booked)

Saturday, 14 May 2022 (Fully Booked)

More dates coming soon
Start Time: 9:00 AM (EST)

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.