Profile cover photo
Profile photo
MasterExcel
157 followers -
Everyday is a learning day
Everyday is a learning day

157 followers
About
Communities and Collections
Posts

Post has attachment
DESCRIPTION Topics in this Video: (00:01) Introduction to Excel Charts & Graphs (02:46) Excel Chart Terminology (04:00) What is Chart Junk? (05:35) Column and Bar Charts for comparing numbers across categories (11:35) Formatting Chart Elements with…
Office 2016 36
Office 2016 36
masterexcel.net
Add a comment...

Post has attachment
DESCRIPTION Topics in this Video: (00:01) Introduction about Data Analysis features (01:40) Sorting (11:45) Filtering (21:50) Flash Fill (29:01) Summary NOTES
Add a comment...

Post has attachment
DESCRIPTION Learn about how to set Default Layout for a PivotTable in Excel 2016 Office 365 or later versions. NOTES
Add a comment...

Post has attachment
DESCRIPTION In this video learn about how to use Excel Tables, One-To-Many Relationships and the Data Model as a substitute for a VLOOKUP Function Helper Column for a Large Data Set. Discuss pros and cons. Introduction to One-To-Many Relationships in the…
Add a comment...

Post has attachment
DESCRIPTION Learn how to look up an item in a list of items and list all the relative positions for that item in a single cell. See the functions TEXTJOIN, IF, ISNA, MATCH. See extensive discussion about Array Formulas. Learn different Formula Element…
Excel Magic Trick 1460
Excel Magic Trick 1460
masterexcel.net
Add a comment...

Post has attachment
DESCRIPTION Learn how to create use SUMIFS and SUMPRODUCT functions to add the costs for each dog based on whether the expense is for Food or it is an Accessory. This video shows how to use SUMIFS to add with with one condition or another condition, using…
Excel Magic Trick 1459
Excel Magic Trick 1459
masterexcel.net
Add a comment...

Post has attachment
DESCRIPTION Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. The INDIRECT Function allows us to use the table…
Add a comment...

Post has attachment
DESCRIPTION In the English United States Regional Settings, SUMIFS seems to be recognizing Text and Number Dates as equivalent Criteria. But when we change the Reginal Settings, SUMIFS correctly interprets Text Dates and Number Dates as different.…
Add a comment...

Post has attachment
DESCRIPTION Learn about how different functions in Excel and Direct Operations interact and interpret Date and Time Values with the different Data Types: Number or Text. Learn how the Functions: SUMIFS, COUNTIFS, COUNT, SUM, EOMONTH, MROUND, DATE and…
Add a comment...

Post has attachment
DESCRIPTION Topics in this video: (00:01) Introduction (01:51) Review of PivotTables we have already completed in this class. (03:15) What is Data Analysis in one sentence (03:34) What’s is Proper Data Set in Excel? (03:50) Example 1: Use VLOOKUP to Add…
Add a comment...
Wait while more posts are being loaded