This course aims to cover some of the best functions and features of Microsoft Excel.
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.
Business author and consultant, specialising in performance measurement and improvement
I am a Fellow of the Chartered Institute of Management Accountants in the UK and work as an author of business courses and a process improvement consultant. I have over 30 years' experience and live near Stirling in Scotland, with my wife, daughter and Cocker Spaniel. I aim to make my courses accessible and understandable. My courses focus on business topics including KPIs, performance measurement, approaches to business improvement, Agile and Lean. I hope you enjoy my courses.
