Category: Excel

Introduction to Microsoft 365 Excel & Conventions for Class – 365 MECS 01

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/01-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/01-M365ExcelClass.pdf
Topics in video:
1. (00:00) Introduction
2. (00:14) Intro Song
3. (00:22) Download Files and Create Class Folder
4. (01:45) Change File Extensions in Windows Explorer
5. (02:30) Color Coding Conventions for Class
6. (04:46) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks
7. (06:17) Naming Convention for all objects in class
8. (07:38) Tabs in the Excel Ribbon
9. (08:26) Quick Access Toolbar = QAT. Build Custom QAT
10. (11:04) Navigating through Workbook
11. (12:26) Keyboards: Desktop or Laptop?
12. (13:36) Keyboard Shortcuts
13. (16:41) First Formula: SUM function using a keyboard
14. (18:27) Cursors
15. (18:37) Data & Alignment and how Continue reading “Introduction to Microsoft 365 Excel & Conventions for Class – 365 MECS 01” →

Excel Improvements To TEXTBEFORE

Posted on by Annie D

Episode 2492
The Calc team at Microsoft released three changes to new functions in late May 2022. The improvements to TEXTBEFORE and TEXTAFTER give you options for dealing with situations where the delimiter that you are searching for is not found.

Table of Contents
(0:00) Former problem with TEXTBEFORE
(0:37) New syntax
(1:11) Using Match End
(1:31) Using If Not Found
(1:47) Why both?
(2:12) Thanks Excel Team
(2:27) Nancy Faust
(2:34) Like & Subscribe
(2:41) Excel Video Courses

Microsoft 365 Excel Complete Class: free from excelisfun at YouTube – 365 MECS 00

Posted on by Annie D

This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike “excelisfun” Girvin. Link to class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
Mike is an Microsoft Excel MVP and a professor at Highline College. This class will cover topics such as:
1. Introduction
2. Worksheet Formula Models
3. Data Analysis with PivotTable, Power Query, Data Model, Power BI…
4. Date and Time formulas
5. SUMIFS, COUNTIFS & Conditional Calculations
6. Logical Formulas: Comparative Operators, IF, AND, OR and IS functions
7. Lookup functions: XLOOKUP and FILTER, Data Validation
8. Array Formulas
9. LET and LAMBDA functions
10. Formulas to Build Reports
11. Visualizing Data with Conditional Formatting, Continue reading “Microsoft 365 Excel Complete Class: free from excelisfun at YouTube – 365 MECS 00” →

Excel Statistical Analysis for Business – Busn 210 – Summer 2022 Quarter Introductory Video

Posted on by Annie D

Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in summer quarter, 2022.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Data From Picture is here in Excel!

Posted on by Annie D

Episode 2490:
The Android phone has had it for a long time, but the new Data From Picture has finally reached the Office Insiders beta channel on desktop Excel. Bill gives this new feature a spin with various pictures of data.

Table of Contents
(0:00) Speech Recognition 1989 to today
(1:10) From Picture near Power Query tools
(1:35) Creating data picture
(2:00) Data From Picture no gridlines
(3:40) Cleaning the results
(4:15) The numbers all match
(4:30) Gridlines don’t help
(5:35) Right-align headings
(7:20) Need to proof
(7:50) With real photo test 1
(8:40) From clipboard test 2
(10:03) This will improve

excelisfun e-Book release: The Only App That Matters: Microsoft 365 Excel. Preview of Book!

Posted on by Annie D

Buy the e-Book today: https://lnkd.in/gZMZMSYD
e-book out June 15. Physical book out Aug 1.
This is a preview of Michael “excelisfun” Girvin’s new 800 page Excel and Power BI book. Two years in the making. Every topic you ever wanted in Excel, PivotTables, Array Formulas, Data Analysis, Power BI Desktop and much more.

Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1793.xlsx
Learn how to determine if there are duplicates in a row.
Topics:
1. (00:00) Introduction
2. (00:09) Logical Formula to indicate if duplicates are in row. OR and COUNTIFS functions.
3. (03:02) Conditional Formatting to indicate if duplicates are in row. COUNTIFS function.
4. (05:54) Count Unique Items with UNIQUE and COLUMNS functions.
5. (06:45) Logical Formula to indicate if duplicates are in row. COLUMNS and UNIQUE functions.
6. (07:29) Count Unique Items with FREQUENCY, MATCH, COLUMN and SUM functions. Old School Formula.
7. (07:59) Summary
8. (08:20) Closing, Video Links

Dad & Son Seattle Jefferson Sunday Skatepark Rad: Boneless-Ones Skate Music Pumps The Action!

Posted on by Annie D

Isaac “Iceman” Girvin and his dad, Mike “Magic” Girvin (excelisfun at YouTube), ride at Jefferson Skate Park on Sunday, June 12, 2022.
The Boneless Ones Skate Punk Band Sond Back To The Grind pumps the action and creates rad!
Washington BMX / Skate Adventure 16.

Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch14-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch14-ESA.pdf, Download Deductive Proof 1 PDF: https://excelisfun.net/files/Linear%20Regression%20Slope%20Deductive%20Proof.pdf Download Deductive Proof 2 PDF (short version): https://excelisfun.net/files/Linear%20Regression%20Slope%20Deductive%20Proof-Shorter.pdf

Learn about the 12 important calculations for Linear Regression: Covariance, Correlation, Slope, Y Intercept, Sum of Squares Total = SST, Sum of Squares Regression = SSR, Sum of Squares Error (Residual) = SSE, R Squared = Coefficient of Determination, Mean Square Error, Standard Error of Estimate, p-value for F. See many diagrams, pictures and animations to help make the complicated math easy to understand.

Learn Continue reading “Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50” →

Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1792.xlsx
Learn how to create a report that lists a unique list of case sensitive items with the frequency for each.
Learn how to create an Expandable Range in a Spilled Array Formula:
1. (00:00) Introduction
2. (00:49) Power Query Solution. Learn that Power Query is case sensitive by default and that the Group By feature makes the task easy.
3. (02:04) Dynamic Spilled Array Formula Solution. See the powerful Array Functions: BYROW, LAMBDA, LET, VSATCK, HSTACK, INDEX and more.
4. (05:45) Expandable Range in a Spilled Array Formula using BYROW, LAMBDA and INDEX functions.
5. (11:04) Test Solution with Continue reading “Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792” →

Excel To Schedule Prison Haircuts Only On Saturday – 2484

Posted on by Annie D

This video is all about the Excel function for WORKDAY.INTL. It allows you to make sure that you are always scheduling an event to occur on a Saturday, or Tues/Thurs or Friday.
The secret here is the alternate syntax for the Weekend argument.
Table of Contents
(0:00) Find a particular Saturday in Excel
(0:25) WORKDAY introduction
(1:37) Find a particular Saturday in Excel
(2:32) Find the next Tuesday
(5:02) Find next Tuesday or Thursday
(5:46) Handling holidays
(6:58) Wrap-up