Mike Thomas - In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.
Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes
Monday
02Often perceived as a mere number-crunching tool, Excel's true prowess lies in its capacity to organize and manage list-based data efficiently and this training session is designed to unveil Excel's full potential beyond arithmetic computations.
Friday
06"How do I look up a value in list ONE and pick up a related value from list TWO"
Tuesday
10An Excel formula is an equation or calculation that is stored in a worksheet cell. A formula enables you to perform simple or complex calculations on numbers. So think of any scenario that involves addition, subtraction, division, or multiplication and that's where you'd use a formula.
Friday
13Few people learn or use Excel for fun. In fact, many people see it as a necessary evil. So if you have to use it, why not learn to use it faster and more effectively? How often have you found yourself in Excel thinking, "there must be a better and faster way to do this?"
An Excel formula is an equation or calculation that is stored in a worksheet cell. A formula enables you to perform simple or complex calculations on numbers. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.
Although it is perfectly possible to use Excel without ever creating a formula or using a function if you don't, you're missing out on a huge part of the application’s power.
An Excel formula is an equation or calculation that is stored in a worksheet cell. A formula enables you to perform simple or complex calculations on numbers. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.
In this session, participants will learn how to visually represent your data using both traditional charts (bar charts, line charts etc.) as well as how to do the same using some of Excel's non-charting tools.