Technology

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.

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.

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.

Skilled data analysts are some of the most sought-entry level professionals in the world. The demand is growing, and the supply of people who can truly do this job well is so limited,

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.

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.

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)

This course is suitable for IT professionals looking to understand more about online security, but is also a good introductory course for those from a non-IT background who need to understand more about the protection of company systems and data.

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!

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.

SEO Training, SEO Audit, Keyword Research, On Page SEO, Link Building, WordPress SEO & More !!

Excel expert David Ringstrom, CPA, explains helpful ways you can improve the integrity of your spreadsheets using Excel’s lookup functions and pivot tables. In

In this presentation Excel expert David H. Ringstrom, CPA brings his prior commercial real estate experience to the foreground again. In this presentation David will walk you through building a simplified real estate proforma.

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!

Learn advanced 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.

Want to know How to make a budget spreadsheet that has everything you need and will never give you any fuss? In this presentation, Excel expert David Ringstrom, CPA, demonstrates how to create effective and resilient budget spreadsheets.

Dashboards empower users to quickly assimilate large amounts of data.

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

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.

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

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

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

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.

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