MS EXCEL-2013 Bangla Tutorial Part-4 Creating Chart

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

Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More…

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

Microsoft Excel 2013 pt 9 (Pie/Column Chart, Pivot Table)

Link to sample file: In this tutorial learn to create Pie and Column Chart. And also learn to create Pivot Table.

005 External Formula References – EXCEL 2013 ADVANCED FORMULA TOOLS

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