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 session you will learn how to create and edit macros, create macros that can b ...

The training will focus on 3 areas - creating summary reports using Pivot Tables; creating eye-catching charts and presenting geographic-based data. In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a ...

In this training, you will learn how to build Queries in Microsoft Access. Queries let you ask questions about your data. Queries allow you to select specific data from your database. Queries are the key to generating effective and powerful report ...

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 the reports, dashboards and cha ...

For many people, the holy grail of organization is a world where email overload doesn't exist and where all those sticky notes and paper notepads are magically replaced by a digital paperless system. Using OneNote, a free application that you ...

Booking forms, sales order forms, invoices, loan agreement forms and surveys. These are just a few examples of forms that can be created using Excel (although the list of examples is endless). By adding a splash of co ...

No matter what business you are in, 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 ...

Do you work with "Big Data"? Do you import and manipulate large datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Query, (known as getting and Transform in Excel 2016) i ...

For many people, the holy grail of organization is a world where email overload doesn't exist and where all those sticky notes and paper notepads are magically replaced by a digital paperless system. Using OneNote, a free app ...

There is a saying, “a picture is worth a thousand words”. In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart, a graph o ...