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
Last week I got an email from one of our readers, with some feedback related to how Monkey Tools’ PivotSleuth works with Measure tables in Power Pivot. Best practices is to set up a disconnected table to house DAX measures.
"Microsoft Excel is not a spreadsheet application anymore, it’s a medium to store, present, and analyze data." - Puneet Gogia The way Excel has evolved in the past few years, it’s almost impossible to work without it in this present
This week Ken is at the Microsoft Business Applications Summit in Atlanta. However, we're super excited that he'll be back on home turf in July for our next public training session. The 3-day Self Service BI Boot Camp in Vancouver
COACHED: Self Service BI Boot Camp Course Description Prepare to change your company’s reporting game forever! We know that data is not usually stored in nicely curated databases and often – even when it is – the data analyst doesn’t
Are you interested in learning how to clean and shape data with Power Query, as well as how to model it using Power Pivot? Don’t know which of these mysterious skills to tackle first? Want to learn about building BI
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 - PivotTables COURSE DESCRIPTION New to Pivot Tables or want to get more out of them? Ken Puls worked with a company called GoSkills to design and build this online course to give you a solid understanding
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
This is a special post to to discuss a suggestion to improve the Pivot Table experience, especially for Power Pivot users. This week I’m at the 2015 MVP Summit in Redmond, WA. It’s a trip I’m lucky enough to make
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
