Mr. Tom Fragale

If you work with data, you’re likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources. Luckily there are two Microsoft tools- PowerPivot and PowerQuery—tha ...

Learning how to use efficiently use Excel is so critical in many of today’s office jobs. Many people know the basics of Excel. This webinar will show you how to use some of the advanced functions of Excel to really help get the most out of ...

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 In this webinar, you will learn how to ...

In today's fast-paced, high-tech, competitive business environment, analytics, data visualization and Business Intelligence (BI) are the hot topics many firms and professional recruiters seek Over the last few years, data has become the ...

We will then make Pivot Charts, to graphically show the data We will start with the basics and built up to more complex pivot tables Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, o ...

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. Even though Excel give ...

Don’t be afraid of macros – learn how to create and use them. When you find yourself repeating actions in Excel – whether it’s a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, a ...

PDF has become the standard digital file format for long term archive and storage of documents. At the same time, it has become the most common format for sharing and collaborating on documents. Many business professionals do not understand how th ...

SharePoint has become the standard way for companies and organizations to share relevant info and files with other people in the company and with people outside of the company as well. In this webinar, you will learn how to set up and manage a Sha ...

In this webinar, you will learn how to use some of the most popular functions in Excel. This includes : Relative formulas, Absolute Formulas,IF,And,Or, Vlookup, Hlookup, Match/Index, Sumif, Countif, Averageif, Sumifs, Countifs, PMT, Networkdays