As part of the November 2021 Power BI update, Microsoft included a new feature called Bookmark Navigator which allows you to easily and quickly create button sets corresponding to your bookmarks, and format them in a wide variety of ways. Continue reading “Bookmark Navigator Tutorial And Review – Power BI November 2021 Updates”
Month: November 2021
Old Guy BMX Park Adventure #13: Lake Stevens BMX Park, Sunday, November 21, 2021
Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad at Lake Stevens BMX Skatepark on Sunday November 21, 2021. No big tricks, just Old Guy BMX fun!
Washington BMX Old Guy Adventure 13.
Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions
ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Download CSV File: https://excelisfun.net/files/Ch01-ESA-AutoData.csv
Learn about how to use Power Query to import and transform CSV File data Continue reading “Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions”
Excel Search In Reverse (Jenny) – feat. Tommy Tutone – 2444
How can you reverse text in Excel? There is not a REVERSE function. You’ve recently seen me do this with a VBA loop. Lianna Gerrish from the Financial Modeling World Cup Semi-Finals would flip it and reverse it with strREVERSE Continue reading “Excel Search In Reverse (Jenny) – feat. Tommy Tutone – 2444”
Page Navigator Tutorial And Review – Power BI November 2021 Updates
One of the most interesting features in the November 2021 Power BI update is the new Page Navigator feature, which dramatically expedites the creation of page navigation buttons throughout your report. In this video, I walk through how to access Continue reading “Page Navigator Tutorial And Review – Power BI November 2021 Updates”
Excel Two Way Lookup Three Ways – 2443
Matching data between two Excel worksheets where you need to match both the city and the tax rate in order to find the match. This video shows three different methods.
Table of Contents
(0:00) Welcome
(1:01) Using XLOOKUP for two-way match
(2:15) Using VLOOKUP Continue reading “Excel Two Way Lookup Three Ways – 2443”
Advancing Your Data Analytics Career – Pt. 1: The Interview – Experts Round Table
In today’s video, a panel of Enterprise DNA Experts discusses their answers to common questions drawn from real Data Analyst job interviews. In addition, they share their own career paths in the data field, and talk about some of the Continue reading “Advancing Your Data Analytics Career – Pt. 1: The Interview – Experts Round Table”
Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Learn the fundamentals of Excel worksheet formulas, functions and how to build worksheet models.
Topics:
(00:00) Introduction
(00:19) Topics in video
(00:45) Worksheet Formula Elements: what can go into a formula
(01:57) Excel Formula Order of Operations
(03:23) Guidelines for Continue reading “Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video”
Excel Find Last Item In List Using MATCH But Not XMATCH – 2442
There are a pair of well known Excel tricks with MATCH:
Find the last item in a long list of items that might contain empty cells.
Find the only number in a range of Error or Text values.
Excel tricksters have made use Continue reading “Excel Find Last Item In List Using MATCH But Not XMATCH – 2442”
Excel List All Lottery Combinations – 2441
Reid would like to list all 6-number combinations of the numbers 1 to 44. For example, 1-2-3-4-5-6, 1-2-3-4-5-7, and so on up to 39-40-41-42-43-44. The first thing to realize is that all lottery combinations are a lot of numbers. Over Continue reading “Excel List All Lottery Combinations – 2441”
Global Power Generation Insights – Power BI Freestyle Session
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
November 10th, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
November 11th, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Global Power Generation Insights – Power BI Freestyle Session”
Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:15) Open Excel file using Windows Explorer
(00:46) Navigating through large Workbook File with many Sheet Tabs
(02:27) Structure of an Excel Worksheet and Workbook
(04:21) Conventions for Workbook files in this class
(06:09) Excel Continue reading “Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more”