Month: October 2022

Building Simple Enterprise Applications | Power Platform Innovation Labs Session 5

Posted on by Annie D

Session 5: Building Simple Enterprise Applications

When is it?
October 4th – 7pm Los Angeles (PDT), 10pm New York (EDT)
October 5th – 1pm Sydney (AEDT), 3pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, CEO & Founder of Enterprise DNA

During This Free Training, You Will Learn:

• How to use Sharepoint to build very quick Power Apps
• How to build Power BI reports around your Power Apps
• Introducing Power Automate into your development to remove manual processes
• How to plan out your enterprise applications before Continue reading “Building Simple Enterprise Applications | Power Platform Innovation Labs Session 5” →

How To Reference Tables In Power Query For Improved Refresh Time & Data Performance

Posted on by Annie D

In this tutorial, Jarrett is going to show how you can reference tables in Power Query to improve your refresh time as well as data performance inside your model.

***** Video Details *****
00:00 Introduction
01:07 Data tables
04:30 Referencing tables
05:40 JobMGMT
06:10 Log Notes
06:44 GLBalanceByDay
07:18 Disabling load
08:24 Performance before and after

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – <a href="https://www.enterprisedna.co/dax-formula-reference-guide-download/" Continue reading “How To Reference Tables In Power Query For Improved Refresh Time & Data Performance” →

Is Excel DATEDIF Gone from Excel? #shorts

Posted on by Annie D

C. R. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Luckily, it is still there, but you have to know the arguments because Excel won’t provide any guidance.

This video answers these questions:
is datedif still in excel
is datedif in excel 2016
why does datedif not work in excel
does datedif still work
can’t find datedif in excel
does datedif still work
datedif how to use
how excel datedif works
how to add datedif function in excel
how to get datedif in excel
how to enable datedif function in excel
what replaced datedif in excel
how to use datedif

Logical Tests: Excel Formulas, Conditional Formatting, PivotTables, Power Query, & More- 365 MECS 07

Posted on by Annie D

Download Excel file: https://excelisfun.net/files/07-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/07-M365ExcelClass.pdf
Download csv file for Power Query example: https://excelisfun.net/files/9112021-2022CallData.csv
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (01:00) What is a Logical Test in Excel?
3. (04:30) Examples of six most common types of logical tests with Filter Feature and PivotTable
4. (04:30) Examples of Single Condition, Contains and NOT Logical Tests
5. (08:44) Description of AND Logical Test and OR Logical Test
6. (17:16) Description of a Complex Logical Test
7. (20:09) Comparative Operators
8. (21:09) Comparative Continue reading “Logical Tests: Excel Formulas, Conditional Formatting, PivotTables, Power Query, & More- 365 MECS 07” →