COACHED TRAINING: Excel Fundamentals Boot Camp Course Description In the Fundamentals Boot Camp, you will begin with a review core skills for the Excel analyst. This section is geared to teach critical skills to less experienced users and review those
ON-DEMAND: Microsoft Excel - Advanced COURSE DESCRIPTION Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? This online course Ken Puls has built with GoSkills will help you learn intermediate and advanced
ON-DEMAND: Microsoft Excel - Basic COURSE DESCRIPTION New to Excel or need a refresher? Ken Puls has worked with a company called GoSkills to design and build a targeted Excel course which is offered in an online format. This online
ON-DEMAND: Microsoft Excel - Basic & Advanced COURSE DESCRIPTION Looking for an Excel course online to improve your skills and save you time? Ken Puls has worked with a company called GoSkills to help design and build Basic and Advanced
In this post I’m going to show one of my favourite financial modeling tricks: how to use Aggregate to Count Visible Rows. Background Often, when I’m building models in Excel, I like to group key assumptions at the top of
I’m working on a spreadsheet where users will be able (required) to insert new rows at a later date. When they do so, it’s critical that the section subtotals always… well… subtotal correctly. The challenge, of course, is that you
Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different
The purpose of the VLOOKUP function is simple: it looks up data in tables and returns results from a different column. So if you have a table of products, for example, you could ask VLOOKUP to return the price for
The following article is courtesy of Yoav Ezer, who volunteered to do a guest post for me while I am at the summit. Thanks Yoav! User Defined Functions versus Formulas in Excel Which are better, Excel functions or UDFs? Use
Today I realized that one of my GETPIVOTDATA formulas was returning an error, since there wasn't any result in the Pivot Table it was checking for data. Unfortunately, during the design of the spreadsheet I never wrapped the function with
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
