Please ensure Javascript is enabled for purposes of website accessibility
Learn Simple But Powerful Excel Functions
5.0( 2 REVIEWS )
1 STUDENTS
1h 27m

This course is designed for those interested to learn the basics of Microsoft Excel, functions such as date, generating random numbers, and use the RANDARRAY function.

Read more.
Course Skill Level
Beginner
Time Estimate
1h 27m

Instructor

Based in Scotland, I am a Fellow of the Chartered Institute of Management Accountants. I am a process improvement consultant and course author.


Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

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

Requirements: 

  • 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.

10 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

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
VLOOKUP And XLOOKUP 00:00:00
Pivot Tables 00:00:00

Course Review

5.0

5.0
2 Ratings
  1. Anonymous

    Informative

    5.0

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

  2. Anonymous

    5.0

    Really liked this class!

3954196

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

3954197

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!