Simplify priority tasks by using Excel formulas to streamline work to save time.
Are you new to Excel and struggling to understand formulas? Are you tired of manually calculating data in Excel spreadsheets? Do you want to learn how to use Excel formulas to streamline your work and save time? If so, this online training session is the perfect solution for you.
Think of any scenario that involves addition, subtraction, division, or multiplication and that’s where you’d use a formula. In addition to building formulas, the session will introduce you to Functions which are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula.
Learning Objectives
- You will be able to understand and apply basic arithmetic operations (addition, subtraction, division, multiplication) to create formulas.
- You will be able to explain the purpose of using parentheses in formulas.
- You will be able to identify potential pitfalls and challenges associated with copying formulas.
- You will be able to enhance work efficiency by applying functions appropriately in different scenarios.
Agenda
- Creating Basic Formulas: Addition, Subtraction, Division, Multiplication
- Using Parentheses in Formulas - the What and Why
- Copying a Formula - the Gotchas You Need to Know About
- Make Formulas Logical and Understandable by Assigning Names to Your Important Cells
- Speed up Your Work by Using the Sum, Average, and Count Functions
Speakers
Mike Thomas,
theexceltrainer.co.uk- UK-based IT trainer with a career spanning 30+ years
- Delivered thousands of courses and produced hundreds of written and video-based tutorials
- Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI
- A fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries, including healthcare, pharmaceutical, and public sector
- Designs and develops Microsoft Office®-based solutions that automate key business tasks and processes
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, and accountants.
