Latest videos by dannyrocksexcels

Introduction to Excel Pivot Tables
Posted by: DannyRocksExcels

Video duration: 420 seconds

Are you curious about Pivot Tables? But... you are a little intimidated by the thought of creating and manipulating one?
Well, this video Lesson will ease your fears. And... show you how easy it is to create your first Pivot Table!
If you can "drag and drop" you can create a Pivot Table.
View all of my Excel Training Videos on my website -
http://thecompany rocks.com/excels

Related: 2003, analysis, and, cross-tabulation, data, drag, drop, excel, field, fields, filter, microsoft, ms, pivot, reports, settings, summary, tables

What-if Analysis in Excel with a 2-input data table
Posted by: DannyRocksExcels

Video duration: 255 seconds

Create as many "what-if" analysis scenarios as you wish - with just one formula!
In this video lesson, you will learn how to set up a 2-input data table to find multple possible monthly loan payments. We are basing this on the =PMT() function.
To see all of my video lessons I invite you to visit my website -
http://thecompany rocks.com/excels

Related: analysis, analytics, arrays, data, excel, financial, functions, inputs, microsoft, ms, scenarios, spreadsheet, substitute, table, tables, technology, tutorial, two, two-inputs, values, variables, what-if

$Excel\$

Excel's Advanced Filter Finds Unique Records & Copies Them
Posted by: DannyRocksExcels

Video duration: 217 seconds

I frequently use this technique when I am preparing names for a mailing list. I can quickly spot some "glaring errors" due to data entry, for example.
If you would like to view all of my Excel training videos, I invite you to visit my website:
http://thecompany rocks.com/excels

Related: advanced, copy, criteria, data, excel, filter, help, lessons, list, mailing, microsoft, ms, records, tutorial, unique

$Use Excel\$

Use Excel's VLOOKUP Function to Build an Invoice
Posted by: DannyRocksExcels

Video duration: 311 seconds

Vertical Lookup (vlookup) functions are a part of every day business life. It is hard to imagine an invoice system, for example, that does not use some variation of =vlookup()
Watch as I demonstrate how to build your invoice using =vlookup()
I invite you to visit my website - http://thecompanyroc ks.com/excels to view all of my Excel Video Lessons.

Related: absolute, cell, excel, function, invoices, lookup, microsoft, ms, references, spreadsheet, vertical, vlookup

The =SUMIF() Function in Excel
Posted by: DannyRocksExcels

Video duration: 271 seconds

What if? What if sales are less than expected? What is my exposure?
The =SUMIF() function is easy to use and produces powerful results.
Watch this short video lesson to see how to employ the power of SUMIF in your Excel Spreadsheets.
To see all of my Excel Video Lessons, I invite you to visit my website -
http:thecompanyro cks.com/excels

Related: 2003, analysis, excel, finance, functions, microsoft, ms, spreadsheets, what-if

$Excel\$

Excel's Conditional Formatting Dynamically Highlights Data
Posted by: DannyRocksExcels

Video duration: 330 seconds

I like to use Excel's Conditional Formatting to:
1) Dynamically highlight the cells that meet my criteria e.g. Above Average, 5 highest values, etc.
2) Apply special formatting to my spreadsheet - e.g. shade every other row to make it easier to read the data.
Visit my website - http://thecompanyroc ks.com/excels to view all of my Excel video lessons.

Related: 2003, alternate, analysis, cell, cells, conditional, data, excel, formatting, formula, highest, highlight, is, istext, lessons, microsoft, ms, row, shading, tutorial, value, values

Paste Special Options in Excel Save You Time!
Posted by: DannyRocksExcels

Video duration: 448 seconds

I love the time-saving options available in the "Paste Special" dialog box! In this video lesson, I demonstrate how you, too, can learn how to save time - and have some fun doing it!
I invite you to visit my website to view all of my Excel training videos -
http://thecompany rocks.com/excels

Related: 2003, excel, formats, formatting, links, ms, paste, special, transpose, value

It is Easy to Add a Calculated Field to Your Pivot Table
Posted by: DannyRocksExcels

Video duration: 244 seconds

With Pivot Tables in Excel, you are not restricted to using just the fields in your data list. With a few mouse clicks, you can created your own "calculated field" to answer the question "Can you show me this...?"
Visit my website -
http:thecompanyro cks.com/excels
to view all of my video lessons

Related: 2003, calculated, excel, field, pivot, tables, what-if

Let Excel recognize your data as a List
Posted by: DannyRocksExcels

Video duration: 282 seconds

Excel introduced the valuable - but underutilized - List Command in version 2003. In version 2007, Lists are now called "Tables."
If you use AutoFilter or Custom Filter, you should take a few minute to view this video to see why the List command is so valuable.
To view all of my MS Excel Video Lessons, I invite you to visit my website -
http://thecompany rocks.com/excels

Related: advanced, automatic, data, excel, expand, extend, filtering, filters, finance, help, lessons, lists, microsoft, ms, multiple, range, row, spreadsheets, toggle, total, tutorial

$When to use Excel\$	When to use Excel's =IF() Function Posted by: DannyRocksExcels Video duration: 369 seconds In this video I demonstrate how you can use the =IF Function to Grade Test Scores, Calculate Shipping Charges and "Trap" errors in formulas. Related: 2003, conditional, excel, formulas, functions, help, lessons, logical, microsoft, tutorials

Bizarre videos :: Social Bookmarking