Now I know that not everyone is going to want to do this, but one of the things that I find which really helps me understand complex calculations or visuals, is to manually replicate the values used. It helps me
Introduction I’m a big fan of building Box and Whisker plots (also known as Box plots to those in the statistics world) to interpret certain data sets. While I tend to use these for charting Power Query refresh times, they
Introduction I’m a big fan of Excel's Box and Whisker chart (also known as Box plots to those in the statistics world). While they can be used in a variety of applications, my personal use case is to try and
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: Excel Dashboards COURSE DESCRIPTION Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. Ken Puls has worked with a company called GoSkills to help design and
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
Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
