Excel Is Fun

Highline Excel 2013 Class Video 23

February 17, 2017 0

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 […]

Excel Is Fun

Excel Magic Trick 1271

February 16, 2017 0

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 […]

Dueling Excel

Dueling Excel 129

February 15, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Change Excel Default Settings For New Workbook

February 14, 2017 2

Change Excel Default Settings For New Workbook DESCRIPTION When you create a new workbook in Excel the default font type, font size, worksheet view and number of new worksheets to display are all added. In […]

Excel Is Fun

Excel Magic Trick 1270

February 13, 2017 0

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. […]

Excel Features

Using AutoFill In Excel

February 12, 2017 0

Introduction AutoFill can be used to enter text or numbers such as days of the week, dates, months, text or a series of numbers. Excel has some predefined lists like days and months but you […]

Excel Is Fun

Excel Magic Trick 1269

February 9, 2017 0

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot […]

Dueling Excel

Dueling Excel 128

February 8, 2017 0

DESCRIPTION Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF See Mr Excel and excelisfun use two methods to count the occurrences of items in a list: 1. PivotTable 2. Advanced Filter Extract Unique […]

ANALYSING DATA

Excel Groups and Subtotals

February 7, 2017 0

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 […]