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

Excel Is Fun

Excel Magic Trick 1268

February 6, 2017 0

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

GETTING STARTED IN EXCEL

Change the Theme in Excel 2013

February 3, 2017 0

Excel 2013 allows you to change the background theme. The default theme is white and can come across to some users as very bright and difficult to work with for long periods of time. Fear […]