Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • Students of business
  • Anyone wanting to develop their Microsoft Excel skills

What you’ll learn: 

  • Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT
  • Useful date functions including TODAY, EOMONTH, EDATE, and DAYS
  • Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table
  • The new RANDARRAY function in Office 365


  • No prior knowledge is required to take this course

There is so much in Microsoft Excel that I can’t cover it all in one course – that might need 100 courses. Instead, in this course – Learn Simple But Powerful Excel Functions – I start with some simple calculations and move onto some of the features and functions that I use most often. There’s no visual basic or macros in here, just powerful but simple to use functions. These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time.

Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In this course, I cover the simple-to-use but powerful functions that I use most often.

Our Promise to You

By the end of this course, you will have learned about Excel functions.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Microsoft Excel.

Course Curriculum

1h 27m

Section 1 - Introduction And Course Lessons
Introduction 00:00:00
Downloadable Course Workbook 00:00:00
Basic Functions 00:00:00
Date Functions 00:00:00
Random Numbers 00:00:00
IFS So Many IFS 00:00:00
Text Functions 00:00:00
Logical Functions 00:00:00
Creating A Drop-Down List 00:00:00
Pivot Tables 00:00:00

Course Reviews


2 ratings
  1. Anonymous



    Lots of great information and even though I’ve used Excel I learned a lot. Thank you!

  2. Anonymous


    Really liked this class!