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