Description

Description

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 “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often:

Basic features including products and powers

Key date functions including the calculation of due dates and days past due

Generating random numbers and random dates

The new IFS functions (new to Office365)

Text functions

The most useful logical functions and IS functions

How to create a drop-down list

The new XLOOKUP function

Pivot tables

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.

I hope you find the course helpful.

Learning Outcomes

Participants in this course will 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 Office365

The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS

Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE

Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR

How to create a drop-down list

The new SORT and FILTER functions in Office365

VLOOKUP and the new XLOOKUP function

How to create a Pivot table and analyse data with one

Course Requirements

There are no pre-course requirements.

Additional Resources

Course Spreadsheet with the examples covered.

About Ross

Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants.

Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Course Images

Adventures in Excel

By Ideas Into Action

Booking options

Highlights

Description

Course Content

About The Provider

Tags

Reviews