About this tutorial: Video duration: 8:33 This video covers the following topics along with the timeline: 0:5 Learn how to get started with Excel 2013 and get the big picture first. 7:06 Learn about Basic Calculations: SUM, AVERAGE, MAX, MIN in Excel 2013 24:50 Learn how to use Arithmetic Calculations: Subtraction, Multiplication, Division Excel 2013 […]
About this tutorial: Video duration: 10:25 Download Excel File: See how to: 1. (00:08 minute mark) Problem Set Up 2. (00:55 minute mark) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula 3. (02:38 minute mark) Remove Duplicates, Screen Tip Trick and COUNT function 4. (03:42 minute mark) Array Formula with […]
Link to sample file: http://simpletek.ca/files/excel-2013-files/ In this tutorial learn to create Pie and Column Chart. And also learn to create Pivot Table.
About this tutorial: Video duration: 4:25 How to use intermediate to advanced Excel functions from various categories (counting/summing/averaging, math, text, date/time, statistical, financial, reference, and logical) to solve practical problems More advanced tips for working with formulas, including formula auditing and formula evaluation How to use Excel’s many powerful tools for data analysis, including tables, […]