Okebiz Video Search



Title:How to Use Multiple Sorting Options in Excel
Duration:07:14
Viewed:122,898
Published:20-11-2012
Source:Youtube

Do you ever need to rearrange the order of your columns in an Excel Data Set? For example, to move the Employee Field to Column A in order to perform a VLOOKUP()?

Rather than using the familiar "Insert Column, Cut Colum, Paste Column" procedure, I demonstrate how to Sort your Data Set "Horizontally" to accomplish this result more efficiently.

Other techniques that I demonstrate in this video include:
1) Sorting your data using "built-in" Custom Lists - e.g. Months of the Year
2) Creating your own Custom Lists in Excel
3) Sorting by Cell Icon - introduced in Excel 2007

I invite you to visit my secure online shopping website - http://shop.thecompanyrocks.com - to learn about the many video training resources that I offer.

Danny Rocks
The Company Rocks

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Excel 2007 - Sorting Data In Single Columns And Whole Tables Excel 2007 - Sorting Data In Single Columns And...
07:25 | 310,913
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) Introduction to Pivot Tables, Charts, and Dashb...
14:48 | 10,793,872
Compare Two Excel Lists to Spot the Differences Compare Two Excel Lists to Spot the Differences
05:53 | 741,448
How to Quickly  Rearrange Column Order  in Excel How to Quickly Rearrange Column Order in Excel
03:35 | 215,624
MS Excel - Data Sorting MS Excel - Data Sorting
09:05 | 438,300
How to easily automate boring Excel tasks with Power Query! How to easily automate boring Excel tasks with ...
17:10 | 371,546
When Should you Use the Hash Sign (#) in Excel Formulas? When Should you Use the Hash Sign (#) in Excel ...
10:53 | 379,291
Create a Searchable Drop Down List in Excel Create a Searchable Drop Down List in Excel
22:18 | 53,280