Training Doyens

If you have good-to-excellent Excel skills you’ll stand a better chance in today’s highly competitive job market. Our upcoming webinar discusses Logic functions in Excel and how they help in automating your task and saving time. The webinar covers the following key areas: ·          The COUNTIF and COUNTIFS function in Excel ·          The SUMIF and SUMIFS function in Excel ·          The IFERROR function in Excel LEARNING OBJECTIVES In this advanced Excel training you will learn about Logic functions in Excel and how they help in automating your task and saving time. WHO WILL BENEFIT This training is categorized as intermediate. It is aimed at users who want to learn about the Logic functions in Excel. Although the training will be delivered using the latest version of Excel, this training is relevant for users of Excel 2010 and above. Speaker P...

OVERVIEW Excel's Logic functions will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. No more using the calculator app on your Smartphone!  Let Excel do the work for you! WHY SHOULD YOU ATTEND No-one learns Excel for fun. But if you have good-to-excellent Excel skills you’ll stand a better chance in today’s highly competitive job market. If this is your goal, then having a good understanding of Excel's Logic functions is critical. AREAS COVERED • The IF logic in Excel • The COUNTIF and COUNTIFS function in Excel • The SUMIF and SUMIFS function in Excel • The IFERROR function in Excel LEARNING OBJECTIVES In this advanced Excel training you will learn about Logic functions in Excel and how they help in automating your task and saving time. WHO WILL BENEFIT This training is categorized as intermediate. It is aimed at users who want to learn about the Logic functions in Excel. Although the tr...

Where the macro recorder's functionality ends, VBA takes over enabling you to build your own worksheet functions, create automated workflows and control and interact with other applications. Our upcoming webinar discusses how to get started with VBA and how it automates at a more advanced level. The webinar covers the following key areas: ·          Understanding VBA jargon such as procedures, modules, methods and properties ·          How to edit an existing macro in spreadsheets ·          How to write a simple macro from scratch using VBA LEARNING OBJECTIVES This webinar helps you in getting started with VBA in Excel. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder. The advanced Excel training will be delivered using the latest version o...

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro in Excel. VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - and if that sounds like a macro - well it is. Although Excel has a macro recorder, there's a limit to what it can do. So, where the macro recorder's functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications. This webinar is aimed at advanced users of Excel, with little or no programming experience, who wish to "dip their toe into the VBA water" WHY SHOULD YOU ATTEND VBA is ...

Where the macro recorder's functionality ends, VBA takes over enabling you to build your own worksheet functions, create automated workflows and control and interact with other applications. Our upcoming webinar discusses how to get started with VBA and how it automates at a more advanced level. The webinar covers the following key areas: ·          Understanding VBA jargon such as procedures, modules, methods and properties ·          How to edit an existing macro in spreadsheets ·          How to write a simple macro from scratch using VBA LEARNING OBJECTIVES This webinar helps you in getting started with VBA in Excel. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder. The advanced Excel training will be delivered using the latest version...

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro in Excel . VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - and if that sounds like a macro - well it is. Although Excel has a macro recorder, there's a limit to what it can do. So, where the macro recorder's functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications. This webinar is aimed at advanced users of Excel, with little or no programming experience, who wish to "dip their toe into the VBA water" WHY SHOULD YOU ATTEND VBA ...

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If yes then it’s time to learn how to create a macro. Join our upcoming webinar to learn the techniques for creating a macro and how to make simple changes to a macro using the built-in programming language called VBA. Key points to be covered in the webinar: ·          Introduction to VBA & Excel macros ·          Using the Macro Recorder to create a macro ·          Saving a file as a macro enabled Excel workbook LEARNING OBJECTIVES In this advanced excel training you will learn how to create and edit macros in Excel using both the Macro recorder and the VBA Editor. WHO WILL BENEFIT This webinar gets you started with macros and VBA. It's aimed at intermediate-to-advanced users of Excel and is relevant to all industries and job roles....

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro. In this advanced Excel training you will learn how to create and edit macros, create macros that can be re-used across multiple files and create macros that run automatically based on an event such as opening or closing a file. You'll learn how to create a macro the easy way by using the built-in macro recorder. You'll then progress on to learn how to make simple changes to a macro using the built-in programming language called VBA. You will also learn about getting started with VBA in Excel. WHY SHOULD YOU ATTEND Being able to create and edit a macro is one of the must have skills for Excel Power Users. Having this knowledge will save you, your colleagues and your customers hours of time by allowing you to automate any Excel-based task or process. If you've never created macros or used ...

VLOOKUP formula is one of the most popularformulas in Excel. In this webinar Excel expert Dennis Taylor discusses the use and limitations of VLOOKUP to help you expand your use of this function. Join the webinar and upgrade your skills. Thursday, December 21st, 2017 01:00 PM E S T | 10:00 AM P S T Duration: 90 minutes VLOOKUP Excel Training AREAS COVERED Perform dual lookups, where you look across columns and down rows to cross reference the data you need See how to arrange two worksheets from within the same workbook onscreen at the same time See why the MATCH and INDEX combination is often superior to the VLOOKUP or HLOOKUP function Uncover the limitations of VLOOKUP, along with alternatives Use the SUMIFS function to sum value based on multiple criteria LEARNING OBJECTIVES Understand how to use VLOOKUP to perform both exact and approximate matches Use the MATCH function to overcome a data integrity risk with VL...