Technology

It will reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, MAXIFS, and OFFSET functions.

If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query / Get and Transform is a must!

Part 1: You’ll learn how to create a pivot table report and how to change the layout and appearance of the report.
Part 2: If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query / Get and Transform is a must!

Formulas and Functions: Part 1 : Introduces several lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE.
Formulas and Functions: Part 2 : Reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, MAXIFS, and OFFSET functions.

In this webinar we'll be showing the intersection of Excel and PowerPoint - making beautiful data visualizations, and convincing an audience to make the same decision you have.

Excel Spreadsheet - This presentation is designed for those who haven’t worked with Excel spreadsheets before or who haven’t used them in a few years.
Excel Dashboard - Dashboards empower users to quickly assimilate large amounts of data.

Keeping track of all emails is a challenge? How to use Outlook to increase productivity with email and time management best practices? Outlook email management is simplified here. In this training session you will learn the best way to organize Microsoft outlook emails.

Pivot Table Part 1 - Pivot tables are one of the most underutilized features in Excel, primarily because users often believe there’s a long learning curve.
Pivot Table Part 2 - Learn advanced Pivot Table techniques to add more interactivity to pivot tables and minimize repetitive tasks.

Pivot tables are one of the most underutilized features in Excel, primarily because users often believe there’s a long learning curve.

This presentation is designed for those who haven’t worked with Excel spreadsheets before or who haven’t used them in a few years.

How to create a dashboard in Excel. Learn here to create and Use Excel Dashboards to Gain Valuable Business Insights. Improve your Excel and data visualization skills with these tips.

David shares alternatives to the IF function, including IFNA, MINIFS, SUMPRODUCT, and others. David asserts that if you’re nesting more than a couple of IF functions, there’s probably
a more refined and resilient approach you can take.

Overall concept of Excel macros as well as the Visual Basic for Applications (VBA)

Dashboards empower users to quickly assimilate large amounts of data.

Learn how to stay responsible on the Internet with cyber ethics.

Automating an Excel-Based Financial Statement. This course explores the ways of automating periodic financial reporting processes.

This webinar will demonstrate several lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE.

In this webinar you’ll learn how to streamline report clean-up in Excel, and avoid frustration in unlocking data from QuickBooks. And how to overcome the limitations of QuickBooks internal reports.

Learn advanced techniques to add more interactivity to pivot tables and minimize repetitive tasks.

You’ll learn how to create a pivot table report and how to change the layout and appearance of the report.

Why do you need Excel formulas and functions? This collection of guides from the How-To Geek covers moderate to cutting edge lessons on the most proficient method to utilize Excel works and make formulas of your own.

LinkedIn is important to your business because it is a dedicated business network. Have you noticed how other businesses are using LinkedIn lately? Learn how to use Linkedin for business success.

Using Excel to Create Visually Appealing and Meaningful Reports

Excel spreadsheets are invaluable for preparing budgets

Microsoft Outlook can save you time, help you to gain more control

Expediting Excel: Mastering Advanced Excel Formulas

Learn powerful worksheet functions that make quick work of financial reporting in Excel.