Excel on Steroids 2013 – Formulas and Functions Course

Whether you're new to Microsoft® Excel® or a regular user, you'll soon realize that it's more than just a grid in which you enter numbers in columns or rows. You can use Excel to find totals for a column or row of numbers, but you can also calculate a mortgage payment, solve math problems, or create a best and worst case scenario based on variable numbers that you plug in. Excel quickly and easily does this by using formulas in cells. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.



What’s covered in this course?

  • Data Consolidation
  • Conditional Formatting
  • Worksheet Protection
  • Managing Data
  • Preparing Data
  • Using Cell References
  • Lookup Functions
  • Text Functions
  • Logical Functions
  • Statistical & Mathematical Functions
  • Date & Financial Functions

 

Frequently Asked Questions


How long will this course take to complete?
This course is designed to take you about 3 hours to complete.

My day is jam-packed and I don’t have a lot of time. How long do I have to complete the course?
We give you six months to complete your course, so even if you can’t get to it immediately, that’s okay. You’ll have plenty of time to get it done.

How can I pay for my course?
We offer two payment options on our Academy store.

  1. Online Payment:
    South Africa:

    You can pay with either your credit card (Visa or MasterCard), or using your PayU Wallet.

International:
Pay with your credit card via PayPal.

  1. Manual Payment (EFT / Bank Deposit):
    South Africa:

    You can choose the Manual Payment option when purchasing your course.
    Your course will only be activated once an EFT or Bank Deposit has been made and proof payment has been sent through to accounts.dbn@alchemex.com

International:
Not available.

Will I know when my course is available?
Yes.
If you pay via Credit Card or PayPal, and your payment was successful, your course will be available to you immediately.

If you pay via EFT and have sent through your proof of payment, our Academy administrator will activate your course and you will receive a “Purchase Successful” email from intelligence.enablement@sage.com 

Go on, give it a try!
Good luck!