Excel Tutorial: Concatenate & Text to Columns

This is video tutorial on how to use the concatenate formula and the text to columns feature in Excel for Mac 2011. These tools are helpful when you need to separate or combine the text in...

Excel 2013 Tutorial 15: Creating Gantt Charts

Excel 2013 Tutorial 15: Creating Gantt Charts. Demo on how to create a Gantt chart in Excel.

Excel 2010 Tutorial For Beginners #1 - Overview (Microsoft Excel)

Visit MotionTraining at http://www.motiontrainingweb.com. In this updated tutorial for Excel 2010 users learn how to create a simple spreadsheet in Excel 201...

Excel Dashboards with PowerPivot Tutorial

Quick intro to how to take your own data and quickly turn it into great presentations, charts, and dashboards, using the PowerPivot feature of Excel. This is...

Excel on iPad

Tutorial shows how to use Microsoft Excel (or Word / PowerPoint) on iPad with the application CloudOn.

Tutorial - Excel 2013 - 10 Things you must know

Tutorial explaining 10 of the most common must-know features in Microsoft Excel 2013, Excel is used world-wide and this tutorial shows slightly beyond the ba...

CARA MEMBUAT RANKING EXCELL DAN MENGURUTKANNYA

Tips tutorial excell tentang cara membuat ranking kemudian mengurutkannya mulai dari yang rangkin pertama dan seterusnya.

Import Data, Copy Data from Excel to R, Both .csv and .txt Formats (R Tutorial 1.3)

Learn how to import data or copy data from excel (or other spreadsheets) into R using both comma-separated values and tab-delimited text file. You will learn...

How to make a good looking Excel Dashboard : Part 2

This is the second part of how to make a good looking Excel Dashboard part 2.

Microsoft Excel Pivot Table Tutorial for Beginners - Excel 2003, 2007, 2010

This video introduce how to use the Pivot Table in Microsoft Excel.

How to make a good looking Excel Dashboard - Part 1: Introduction

Found series of videos where the owner going to show you how to make a decent looking dashboard in excel. Enjoy!

Microsoft Excel Template as productivity tool

Last week we have a meeting, a planning meeting. A lot of thing to plan. When we do planning we usually do planning for 5 years ahead.

It takes two meetings, actually one meeting last week and two days planning workshop this week for the planning purpose.

Planning can be very time consuming.

Yesterday, i opened microsoft excel. Put all the data and began automating the process.

Guess what?

We can actually save a lot of time, just by using COUNTIF and simple mathematics in microsoft excel. Today me and some few friends, decided to make a working template by improving the excel file so that other people in our workplace can use it for planning.

Creating a .CSV File using Microsoft Excel

SUM OF 3 , 4, 5 or N largest value in a range

Yesterday i need to find the SUM of 3 largest value in a range using EXCEL. 

This is how to find the SUM of 3 largest value from 7 value in a range of 7 number. 

= SUM(LARGE (A1:A7, {1,2,3})) 

SUM is used for summation 

LARGE is used to find largest number 

Let say with this number from A1:A7 

1,2,3,4,5,6,7 

using  = LARGE (A1:A7, {1,2,3}) alone will result 

 7 (current cell ) 6 (next cell) 5(next 2 cell)  

Using  = SUM(LARGE (A1:A7, {1,2,3}))  will result in 7+6+5 = 18 in current cell