Adventures in Excel

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.