Excel Topics

The Home Tab – Clipboard Group

April 11, 2017 0

The Home tab is probably where you will spend most of your time as this contains the most common commands like formatting & style commands, commands to insert and delete rows or columns, plus an […]

WORKBOOKS & WORKSHEETS

Microsoft Excel Workbook Formats

February 26, 2017 0

In Excel 2007 Microsoft introduced a new file format, Office Open XML which allows other programs to easily work with Excel workbooks. Listed below is a list of the most common file formats you will […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

April 11, 2015 0

DESCRIPTION See how to: (00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months (02:04) Group By Date: PowerPivot PivotTable: (02:07) Add Revenue Table to PowerPivot Data Model (02:46) […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

April 7, 2015 0

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name […]