Page 2 of 8
Macros 101: Automate Tasks & Streamline Your Workflows
Being able to create and edit a macro is one of the must have skills for Excel users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. No more wasting time on repetitive actions in Excel!
July 10, 2023
10 Essential Excel Functions You Need to Know to Increase Productivity
This program is designed to unlock the power of Excel’s most popular productivity-boosting functions. Master these ten essential functions and you’ll find yourself overcoming challenges, automating tasks, improving efficiency, and drastically reducing your time spent on manual data management processes.
July 5, 2023
Excel Features No Accountant Can Live Without
In this dynamic, 60-minute program, Excel expert David Ringstrom, CPA demonstrates the best features in Excel that will make even the most experienced accountants more productive. Learn how to tame unwieldy worksheets, shortcuts that will save you time, and gain must-have tools to ensure accurate reports.
June 27, 2023
Advanced PowerPoint: Keys to Creating Better Presentations Part 2
This 90-minute webinar takes you beyond simple decks and organized content to producing slick and professional looking decks that grab and hold an audience’s attention, no matter the venue or platform.
June 20, 2023
Excel for Accountants: Boost Accuracy and Efficiency
In this 100-minute program, you will learn how to save valuable time and avoid headaches by learning invaluable Excel tips, techniques, and shortcuts to better navigate masses of financial data. You will be able to work more efficiently, plus share pertinent data more clearly with decision-makers.
May 29, 2023
Automatically Adding Serial Numbers in Excel
Serial numbers are an essential part of many datasets because you can use them to identify specific entries in your sheet. Adding them manually can…
Tags: Excel 2013, formulas, formulas and functions, functions
May 25, 2023
Excel for Financial Forecasting: Build Better Spreadsheets & Models
Our Excel expert, David H. Ringstrom, says “Either you work Excel, or it works you”. In this jam-packed, 100-minute webinar you will discover everything you need to know about a variety of Excel features and worksheet functions to ultimately help you utilize Excel in a more effective manner.
May 10, 2023
Excel Dashboards 101 for Beginners
Learn the basics to create Dashboards with Excel, showing patterns that are relevant to all managers and industries. This 90-minute training will give you the skills you need to make cleaner reports, better data analysis and drive key business decisions. Advance your excel knowledge and your career with Excel Dashboards.
May 9, 2023
Inserting Images in Excel Worksheets
Placing images into your Excel worksheets can be beneficial for several reasons. For one, doing so can help pair product photos with their inventory descriptions…
Tags: customizing, excel, Excel 2013
May 5, 2023
VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 3: XLOOKUP Formula
The XLOOKUP function is relatively new, and it was introduced to provide solutions for some of the issues that commonly occur when using the VLOOKUP…
Tags: Excel 2013, formatting, formulas, formulas and functions, functions
April 28, 2023
VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 2: HLOOKUP Formula
HLOOKUP is a function that Excel users can key in to look up and retrieve data from a specific row in a table. This function…
Tags: Excel 2013, excel tools, formatting, formulas, formulas and functions, functions
April 21, 2023
VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 1: VLOOKUP Formula
VLOOKUP is a relatively common Excel function that aims to simplify locating a specific piece of information located within a spreadsheet. For example, if you…
Tags: Excel 2013, formulas, formulas and functions, functions
April 14, 2023
10 Reasons to Use Excel Tables
Excel tables come with a variety of features that make data recording and management a breeze. Instead of handling your data processes manually, save time…
Tags: excel, Excel 2013, excel tools
March 10, 2023
Mastering Excel Lookup Functions: What Every User Should Know
After this interactive 90-minute, instructor-led training, you’ll have mastered the use of Excel’s VLOOKUP, HLOOKUP and XLOOKUP functions. You’ll know when and how to use them and be able to confidently employ them to save time, work with data more efficiently and be more productive. BONUS: You’ll also get great ideas on structuring your data that will help you going forward.
March 2, 2023
Reviewing Formulas and Functions Part 3: COUNT in Excel
Most working professionals want to save time when writing reports and copying data into spreadsheets, yet worrying about making mistakes can slow progress to a…
Tags: Excel 2013, formulas, formulas and functions, functions
Reviewing Formulas and Functions Part 2: AVERAGE in Excel
Learning a selection of Excel formulas can take your reports to the next level. Mastering a few tips and tricks can not only save time…
Tags: Excel 2013, excel tools, formulas, functions
February 23, 2023
Reviewing Formulas and Functions Part 1: SUM in Excel
Mastering Excel formulas can make a world of difference for working professionals. Not only does using formulas save time, but it also ensures that the…
Tags: Excel 2013, formulas, formulas and functions, functions
February 16, 2023
Simply Excel Part II: Tips, Tricks, Shortcuts and More…
This course, built in bite-size pieces, is intended for Excel users at a beginner-intermediate level.
Each self-paced module ranges from 10 to 20 minutes and includes a knowledge review quiz. You will learn the most useful shortcuts, as well as all the common functions, which will empower you to work more efficiently and effectively. Additionally, we’ll guide you through the best practices for formatting and analyzing your data, in a snap!
February 14, 2023
Creating Basic Formulas Part 3: Division
Excel formulas can simplify the essential mathematical operations of addition, subtraction, multiplication, and division. In Part 2 of this series, we covered creating basic multiplication…
Tags: Excel 2013, formulas
February 8, 2023
Creating Basic Formulas Part 2: Multiplication
Addition, subtraction, multiplication, and division are essential mathematical functions that can be made easy by using Excel formulas. In Part 1 of this series, we covered…
Tags: excel, Excel 2013, formulas, formulas and functions
December 23, 2022
Page 2 of 8
