Видео 303
Просмотров 2 059 945

5:41

Excel Python LOC Function

5:15

Excel Power Pivot Hierarchies

4:26

Excel Power Pivot KPIs

5:52

Excel Python Query on List Criteria

4:38

Excel Python Join Query

7:55

Excel Power Pivot Dashboard

This video looks at how easy it is to create a slicer controlled dashboard in excel in under 8 minutes. Excel's power pivot makes creating a dashboard a breeze with calculated columns and measures.
Learn more about Excel Functions & Features with the purchase of this book at Amazon:
amzn.to/3xtLmXp
Purchase a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#excelpowerpivot
#excelPowerPivotDashboard
#ExcelDashboardIn8Minutes

Видео

5:41

Excel Python Wildcard Search

Просмотров 174Месяц назад

This video illustrates how to perform a wildcard search in Excel Python. Excel Python has several string functions that allow regular expression pattern searches. Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links. #ExcelPythonWildcardSearch #ExcelPythonPatternMatch...

5:15

Excel Python LOC Function

Просмотров 178Месяц назад

This video takes a look at the LOC Function in Excel Python. The Python LOC function allows you to select certain rows and columns within an excel dataframe. This function also allows user to add custom filters to an excel python dataframe. Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission for every...

4:26

Excel Power Pivot Hierarchies

Просмотров 279Месяц назад

This video illustrates how to create Hierarchies in Power Pivot with Excel. Power Pivot Hierarchies allow users to quickly drill into detail level data on Pivot Tables and Charts. This can help end users see what's behind the summary level figures. Learn more about Excel Functions & Features with the purchase of this book at Amazon: amzn.to/3xtLmXp Purchase a Microsoft Office 365 Personal Subsc...

5:52

Excel Power Pivot KPIs

Просмотров 4042 месяца назад

This video covers how to create KPIs in Power Pivot in Excel. KPIs (Key Performance Indicators) provide visual aids to pivot table fields making it easier for end users to quickly interpret data. Learn more about Excel Functions & Features with the purchase of this book at Amazon: amzn.to/3xtLmXp Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLA...

4:38

Excel Python Query on List Criteria

Просмотров 2872 месяца назад

This video covers how to create a Query in Excel Python based on a List of Criteria. In this example we have a dataset of grocery store inventory items. The objective is to return records that match a criteria list of different product descriptions. Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission ...

7:55

Excel Python Join Query

Просмотров 5242 месяца назад

This video illustrates how to perform a Join Query in Excel Python. The lesson begins with an example joining two tables, but later includes how to add in a third table. This video also covers how to query on multiple criteria in excel python. Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission for ev...

8:02

Excel Power Pivot

Просмотров 4782 месяца назад

This video is a beginners guide to Power Pivot in Excel. This lesson includes how to link tables together in Excel using Power Pivot. It also covers adding calculated fields and measures using Power Pivot. Learn more about Excel Functions & Features with the purchase of this book at Amazon: amzn.to/3xtLmXp Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9...

6:43

Excel Python If Statement

Просмотров 7682 месяца назад

This video covers how to use an IF Statement in Excel Python in order to add a custom output column onto a Dataframe. The example includes calculating a bonus amount based on certain conditions. Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links. #ExcelPython #Excel...

Excel Group By Function Month & Year on Date Column

2:09

Excel Group By Function Month & Year on Date Column

Просмотров 2763 месяца назад

This video covers using the Excel Group By Function to categorize a full date column by Month and Year groupings. Note: The Group By Function is only available to 365 users who have the insiders version. If you have 365 and want to get the insiders version, it's completely free to do. The link on how to do this is below: insider.microsoft365.com/en-us/join/windows Learn more about Excel Functio...

3:31

Excel Group By Function

Просмотров 1613 месяца назад

This video looks at the Excel Group By Function and how it can be used to quickly total values by certain categories. The lesson also shows how to use the Group By Function for Multiple Value and Category Outputs. This video also illustrates how to use the Filter argument of the Group By Function to filter on multiple criteria. Note: The Group By Function is only available to 365 users who have...

5:50

Google Sheets Regex Match Query

Просмотров 2063 месяца назад

This video looks at combining the Regexmatch function with the Query Function in Google Sheets for more advance wildcard searches. Using the Regexmatch in a Google Sheets query allows for pattern matches such as: certain sequences, list criteria, contains numbers and many others. Learn more about Google Sheets Functions with this Book at Amazon. amzn.to/3HkHcGa Buy the complete Google Workspace...

Excel Pivot Table With Weighted Average Field

3:30

Excel Pivot Table With Weighted Average Field

Просмотров 4873 месяца назад

This video covers how to add a weighted average field to a pivot table in excel based on certain categories. The lesson also includes a method on how to check the figures to confirm the averages are correct. Learn more about Excel Functions & Features with this book at Amazon: amzn.to/3xtLmXp Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIMER...

Excel Filter Function With RegexTest Function

5:33

Excel Filter Function With RegexTest Function

Просмотров 2364 месяца назад

This video looks at the new RegexTest Function in Excel 365 and how to use it with the Filter Function for dynamic wildcard searches. These two functions combined can produce all sorts of pattern matches with the filter function such as : Begins With, Ends With, Contains, List Criteria, Or Criteria, Number Patterns, etc. Note: The Regextest Function is only available to 365 users who have the i...

4:39

Google Sheets Query Not in List

Просмотров 2604 месяца назад

This video covers how to create a query in google sheets where the criteria is anything NOT in a list of items or everything is in a list. In addition the criteria list for the query is linked directly to a range of criteria cells. The query is also driven by a dropdown search type option for two query types: In the list or Not in the list. Learn more about Google Sheets Functions with this Boo...