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.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
