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

138 followers
About
MasterExcel's interests
MasterExcel's posts

Post has attachment
DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See two situations: 1) Criteria is Mon, Tue, Wed and so on, and 2)…

Post has attachment
Highline Excel 2013 Class Video 23

VLOOKUP and IFNA for Commissions DESCRIPTION Topics in this video: VLOOKUP and IFNA for Commissions: VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the flat commission rate when there is no contractual rate.…

Post has attachment
DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for when there are duplicates and Power Query:…

Post has attachment
DESCRIPTION Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? See Mr Excel and excelisfun use two methods to create Dynamic Range For Last Ten Numbers in Coulmn: 1. OFFSET function to create dynamic range 2. INDEX function to create dynamic…

Post has attachment
DESCRIPTION Calculate Retirement Date with EDATE and EOMONTH functions Learn how to Calculating Retirement Date with EDATE and EOMONTH functions. The rule for calculating the retirement date is: 1. Retirement age is 60 years. 2. Employee retire last day…

Post has attachment
DESCRIPTION An overview of Excel 2010’s Ribbon interface.

Post has attachment
DESCRIPTION Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables to the PivotTable Field list and drag and…

Post has attachment
DESCRIPTION Worksheets with a lot of content can sometimes feel overwhelming and even become difficult to read. Fortunately, Excel can organise data in groups, allowing you to easily show and hide different sections of your worksheet. You can also…

Post has attachment
WReferences: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09)…

Post has attachment
DESCRIPTION Power Query M Code: 10 Cross Tabulated Transformed into 1 Proper Data Set Tabulated Transformed into 1 Proper Data Set. These are the steps in using Power Query: 1. Select A1, Ctrl + Shift + End (31 date columns and 1 Species Column) 2. Ctrl +…
Wait while more posts are being loaded