Training Doyens

OVERVIEW Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what they, how to use them, and that they are not difficult, and they can give you tremendous results. We will then make Pivot Charts, to graphically show the data. Then, we will add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way. You and your staff will be instantly more productive in Excel. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session. WHY SHOULD YOU ATTEND Attend this webinar if you use Microsoft Excel on a regular basis and want to take your knowledge to the next level. AREAS COVERED ...

  Excel charts and graphs are visual representations of data and such representations make the data less confusing and increase comprehension. Our upcoming webinar discusses the types of charts and graphs along with their significance and how to create basic and combination charts. The webinar covers the following key areas: ·          Defining the components of a chart ·          Formatting and modifying a chart and adding, editing, and removing data ·          Using sparkline chart and annotating with trendlines LEARNING OBJECTIVES You will learn how to create charts in Excel based on a variety of data sets. There are so many chart types to choose from, and you will understand which chart type presents the data from which perspectives. We will start with very basic charts, modify the data being represented in the chart and advance into more compl...

Simple VLOOKUP function in Excel is a powerful tool but if the data is not laid out properly, or if the data is held as the wrong type, everything crumbles in the spreadsheet. Our upcoming webinar discusses how to tweak it to make it more powerful or to bypass it for more flexible, useful functions. The webinar covers the following key areas: ·          Making Microsoft Excel VLOOKUP work well in every scenario, even when it can’t handle the request ·          Replacing VLOOKUP with more flexible functions ·          Supplementing your lookups with alternative tools LEARNING OBJECTIVES Simple VLOOKUP function in Excel is a powerful tool, but there are a thousand ways to tweak it to be more powerful – or to bypass it for more flexible, useful functions. Supplementing MS Excel VLOOKUP with functions like IFERROR, MATCH, and CONCAT, or using tools like S...

OVERVIEW MSExcel 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 Microsoft Excel training program 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 formula in Excel entirely, sometimes with INDEX and MATCH, and oth...

OVERVIEW Simple VLOOKUP is a powerful tool , but there are a thousand ways to tweak it to make it more powerful – or to bypass it for more flexible, useful functions. Join our upcoming webinar to be presented by Neil Malek to learn how to use VLOOKUP in Excel and many other powerful, dynamic functions available in Excel. Webinar Highlights ·          Making VLOOKUP work well in every scenario, even when it can’t handle the request ·          Replacing VLOOKUP with more flexible functions ·          Supplementing your lookups with alternative tools LEARNING OBJECTIVES Simple VLOOKUP is a powerful tool, but there are a thousand ways to tweak it to be more powerful – or to bypass it for more flexible, useful functions. Supplementing Microsoft Excel VLOOKUP with functions like IFERROR, MATCH, and CONCAT, or using tools like SUMIFS, LARGE, INDEX,...