Training Doyens

Excel has many built-in functions that help you deal with your business data and it is very important that you know how to use them to get the most out of your data in a time efficient manner. Our upcoming webinar discusses how to use Excel functions to get useful insights from your business data. The webinar covers the following key areas: ·          Relative Formulas and Absolute Formulas ·          VLOOKUP and HLOOKUP ·          COUNTIF, AVERAGEIF, SUMIFS and NETWORKDAYS LEARNING OBJECTIVES If you handle large amounts of data in Excel and want to learn about the most useful Excel functions, this webinar will help you tremendously. You will learn how to use Excel functions to get useful insights from business data. WHO WILL BENEFIT • Business owners • CEO's / CFO's / CTO's • Managers of all levels • Anybody with large amounts of data •...

OVERVIEW In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be. Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of Microsoft Excel formulas and functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. WHY SHOULD YOU ATTEND You should attend this advanced Excel training if you use Microsoft Excel on a regular basis, and want to be more efficient and productive. AREAS COVERED • Relative Formulas • Absolute Formulas • IF • AND • OR • VLOOKUP • HLOOKUP • Match/Index • SUMIF • COUNTIF • AVERAGEIF • SUMIFS • COUNTIFS • NETWORKDAYS LEARNING OBJECTIVES If yo...

Dennis Taylor Dennis Taylor Senior Excel Trainer/Author, Excel Courses Years of Experience:  25+ years Areas of Expertise:  Microsoft Excel Dennis Taylor  is an Excel expert. He has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990s. He’s traveled the United States and Canada giving seminars to help his students unlock the full potential of Excel. Dennis has a unique ability to describe, decode, and demystify the myriad functions of Excel for individuals and businesses. He’s taught hundreds of workshops and authored numerous tomes on this program. Accomplishments: Dennis’s 25-year track record of Excel exploits is nearly overwhelming in scope and volume. He has penned and presented more than 600 webinars on various Excel topics in the past nine years. Dennis has also produced numerous Excel courses on video, CD, and DVD. As if this wasn’t enough contribution to Excel education, he’s taught more than 500 seminar...

Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. Join our upcoming webinar to learn how to use lookup functions that let you work with your data more efficiently and know about powerful new tools that help you manipulate data and make better business decisions. VLOOKUP, MATCH, INDEX, vlookup function in excel LEARNING OBJECTIVES This webinar is for any user of Excel who works with large amounts of data and has data in multiple worksheets. Learning about the lookup functions will allow you to match data between databases. Learn about VLOOKUP function in Excel which enables you to quickly and easily look for a value down a column of data and return a value from the same row in a different column. Perfect for when working with large tabular data. INDEX and MATCH work in a similar way but provide more flexibility. In just one fast-paced and informative training session, you’ll learn how to use lookup functions to let yo...

Excel has many built-in functions that help you deal with a large amount of data in an efficient manner. Join our upcoming webinar to learn howto turn the data into meaningful information and then provide the answers that you need for yourself, your boss, or your organization. Key points to be covered in the webinar: ·          Relative Formulas and Absolute Formulas ·          Vlookup and Hlookup ·          Sumif and Countif Online Excel Training LEARNING OBJECTIVES If you handle large amounts of data in Excel, this webinar will help you tremendously. WHO WILL BENEFIT Business owners CEO's / CFO's / CTO's Managers of all levels Anybody with large amounts of data Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive Accountants CPAs Controllers Financial Consultants IT Prof...

microsoft excel training OVERVIEW In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be. Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. WHY SHOULD YOU ATTEND You should attend this webinar if  you use Microsoft Excel on a regular basis, and want to be more efficient and productive. AREAS COVERED Relative formulas Absolute Formuals IF And Or Vlookup Hlookup Match/Index Sumif Countif Averageif Sumifs Countifs Networkdays LEARNING OBJECTIVES If you handle large amounts of data ...

OVERVIEW VLOOKUP retrieves one result to a match request, if that match can be found in the leftmost column of a large dataset. If the data is not laid out properly, or if the data is held as the wrong type, everything crumbles in the spreadsheet. Instead, you can expand your horizons with text, logical, lookup, and math functions – as well as new ways of referencing the data. This webinar will explore many of the most powerful, dynamic functions available in Excel. All too often, we get our data from clients that don’t understand how to use Excel , or databases that weren’t set up with our goals in mind. We can spend far too long trying to make the data just right, instead of pulling out the right tool from the toolbox. Integrating IFERROR, ISERROR, and IFNA with VLOOKUP immediately makes it more forgiving, and using MATCH with it makes it more flexible. You can replace VLOOKUP entirely, sometimes with INDEX and MATCH, and other times with functions you wouldn’t assume, like MA...