Training Doyens

What will be discussed? By learning how to use the most useful Excel functions you can turn your data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. Our upcoming webinar discusses advanced Excel functions for efficiently dealing with large datasets and getting the most out of them. What you’ll learn? ·          Relative formulas and Absolute formulas ·          Vlookup, Hlookup and Match/Index ·          Sumif, Countif, Averageif, Sumifs, Countifs and Networkdays Microsoft excel formulas LEARNING OBJECTIVES If you handle large amounts of data in Excel, this webinar will help you tremendously. You can learn advanced Excel formulas for efficiently dealing with large datasets. WHO WILL BENEFIT Business owners CEO's / CFO's / CTO's Managers of all levels An...

OVERVIEW A dashboard is a critical tool in your communication armory and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer. WHY SHOULD YOU ATTEND In this Microsoft Excel training , you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports. AREAS COVERED Best practice for setting up data sources Using Pivot Tables to summarize data Visual communication using charts Using formulas to create KPI summaries Creating interactive filters with Slicers Automating the dashboard with a simple macro Using protection to prevent accidental changes LEARNING OBJECTIVES This training focuses on wh...

Your business landscape might be exacting but you don’t have to compromise on your aspirations. Just brush up your skills with our upcoming webinar. Learning how to create Pivot Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. Join the webinar to learn how to build appealing pivot tables and reports. Key points to be covered in the webinar: ·          What is a pivot table – a few examples of pivot tables ·          Creating a simple pivot table in 6 clicks ·          Sum, count and percent – how to change what is displayed advanced excel course LEARNING OBJECTIVES In this Microsoft Excel training, you'll learn How to create a pivot table report in just 6 clicks! How to change the layout and appearance of the report to make it inviting to read How to display data in differen...

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 Although it is perfectly possible to use Excel without ever creating a formula or using a function, if you don’t, you’re missing out on a huge part of the application’s power. Join our upcoming webinar to be presented by Mike Thomas to learn how to use Excel formulas and functions to automate your calculations and save tons of time. Webinar Highlights ·          Mastering Excel and creating formulas to perform mathematical calculations ·          Copying formulas and the difference between absolute and relative references ·          Assigning names to cells and using them in formulas LEARNING OBJECTIVES Use formulas to perform calculations on numbers Use formulas to perform calculations on dates Use formulas to manipulate text WHO WILL BENEFIT This session is aimed at anyone who uses Excel at a basic level and wants to lear...

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 Excel has many built-in functions that help you deal with large amounts of data efficiently. Tom discusses how to turn the data into meaningful information. The webinar provides a clear and deep understanding about: ·          Relative formulas and Absolute formulas ·          Vlookup and Hlookup ·          Networkdays and more 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 Professionals Auditors Human Resource Personnel Bookkeepers Marketers Admins Secretaries SPEAKER...

OVERVIEW Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build reports and charts that summarize and analyze large amounts of raw data and help you to spot trends and get answers to the important questions on which you base your key business decisions. WHY SHOULD YOU ATTEND Learning how to create Pivot Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This training will provide you with a solid foundation that you can use to build your own pivot tables and reports. Excel Training Classes Online AREAS COVERED What is a pivot table – a few examples of pivot tables Creating a simple pivot table in 6 clicks Sum, count and percent – how to change what is displayed Making a pivot table report eye-catching appealing Changing the layout of a pivot t...