Training Doyens

OVERVIEW No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, MS Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer.  Thistraining focuses on what you need to know to create an interactive professional-looking dashboard using MS Excel.  You'll learn how to: make the Excel Dashboards maintenance-free when new data becomes available; create the pivot tables needed to drive the dashboard; create great looking visuals; add interactivity using slicers; automate elements of the dashboard with a macro and protect the cells containing critical formulas. WHY SHOULD YOU ATTEND In this advanced Excel training session, you'll learn how to create a stunning, interactive professional-looking dashboard using MS Excel. AREAS COVE...

OVERVIEW Whether you need to calculate loan repayments, generate a profit-and-loss account, solve maths or engineering problems, in fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you’ll find that Excel is the best tool for the job. Functions are built-in formulas that have been programmed to perform a specific calculation. They range from the simple such as SUM and AVERAGE (used to calculate the total and average of numbers in a range of cells) to the powerful IF and VLOOKUP.  Functions aren’t limited to calculating numeric data. They can save you a ton of time when working with text and dates too. For example, you can quickly calculate someone’s age from their date of birth, combine text items from several cells into a single cell or convert a list of lower case text items to capital letters. Do you create financial or data models?  Excel is the perfect tool for that. Build the model using formulas and w...

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 delighted to invite you for our upcoming webinar where Tom Fragale discusses how to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. The webinar provides a clear and deep understanding about: ·          Creating and managing Pivot Tables. ·          Creating custom calculations ·          Creating daily, monthly, quarterly and yearly summaries Excel as a Business Intelligence Too l LEARNING OBJECTIVES In this webinar, you will learn how to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. We will start with the basics and bu...