Total Training for Microsoft Excel 2007 Essentials and Advanced

One of the best courses I’ve done. How many of us use excel day in and out? I use it for my SMART/SWOT analysis, goal setting, workout progress, clocking my hours when I had to… all sorts. And now I feel like Super Excel Man! I’ve saved a couple of videos below which were just wow moments for me. Great teacher and Total Training as usual delivers another great course.

I couldn’t find the Essentials DVD Table of Contents but it’s pretty much the basics (which is not really basic if you’re starting in excel but very easy to learn and catch up on).

Bonus from Hema – Excel Shortcuts You Probably Don’t Know


Advanced DVD
Lesson 1: SUMMARIZING DATA (58 min)
Advanced Subtotals
Formatting the Subtotal Rows
Adding and Copying with Subtotals
Consolidating Data
Introducing the SUMIF Command
Working with the SUMIF Command
Using Array Formulas
Looking at AutoSum Tricks
Utilizing Fill Handle Tricks

Lesson 2: WORKING WITH PIVOT TABLES (52 min)
Creating a Pivot Table
Rearranging Fields in a Pivot Table
Explaining the Report Layout Options
Using the Report Filters Feature
Using Top 10 & Date Filters
Handling Blank Cells
Drilling Down in the Pivot Table
Sorting a Pivot Table
Formatting a Pivot Table
Creating Custom Formats
Explaining the Grouping Options
Adding Formulas to a Pivot Table
Changing a Calculation in a Pivot Table
Replicating a Pivot Table
Counting with a Pivot Table
Using Pivot Charts

Lesson 3: CHARTING IN EXCEL (75 min)
Charts Refresher
Moving, Sizing & Copying Charts
Formatting Charts
Formatting a Series
Exploring the Home & Format Ribbons
Deciding What Chart Format to Use
Show a Time Series with Column or Line Charts
Using Combination Charts
Using Line Chart Accessories
Using Bar Charts to Show Comparisons
Using Component Charts
Using Correlation Charts
Exploring Other Charts
Chart Lies Revealed & Advanced Chart Types
Creating a Custom Layout

Lesson 4: GETTING VISUAL (28 min)
Using Conditional Formatting
Using Advanced Conditional Formatting
Highlighting, Sorting & Filtering Columns
Using SmartArt Functions
Using Different SmartArt Graphics
Embedding a Formula into a Shape

Lesson 5: CREATING POWERFUL FORMULAS (85 min)
Using Goal Seek to Find an Answer
Auditing Formulas
Shrinking the Formula Bar
Understanding Errors
Joining Text Columns
Using Custom Formatting Codes
Pasting Values
Using Paste Special
Breaking Apart Text
Converting Text to Numbers
Using Date Functions
Using Bizarre Date Functions
Using Exponents
Using the VLOOKUP Function
Using Index Match
Using the Offset Function
Using the Convert Function
Looking at Interesting but Obscure Functions
Using the Rand Function
Working with Regression
Ranking & Sorting Formulas

Lesson 6: RECORDING MACROS (18 min)
Displaying the Developer Tab
Recording a Simple Macro
Simplifying the Macro
Recording Using Relative References

Lesson 7: TIPS & TRICKS (28 min)
Showing Off New Tips in Excel 2007
Tips for Handling Worksheets
Using Excel as a Word Processor
Miscellaneous Tips
Validating Data
Changing Text Entry Direction
Using Speak Cells
Final Comments & Credits

AND SO MUCH MORE

Share

Don’t Pursue Your Passion. Chase Opportunity – Mike Rowe of Dirty Jobs

Click to get the DVD

Don’t Pursue Your Passion. Chase Opportunity – Mike Rowe of Dirty Jobs

Paras note: So Mike Rowe says don’t follow your passion but bring it with you. A popular quote by the ‘herd’ is do what you love. I say love what you do because you’re going to do what you love anyway. Like when you’re unhappy in a job … you love being unhappy in the job that is why you do it! Lol. I love pushing who I ‘think’ I am and being in others shoes to experience as much as I can.
Mike Rowe: Learning from dirty jobs

Mike Rowe: Don’t Pursue Your Passion. Chase Opportunity.

Bonus – Mike Rowe From ‘Dirty Jobs’: Don’t Follow Your Passion, Live It
This one might just sound like the ones above so just called it bonus.

Here is another reason why I don’t go with the herd that says do what you love or follow your passion.
http://99u.com/workbook/42757/dont-follow-your-passion-follow-your-contribution

Share

The Edible Garden (Full Series)

Click to get the book

The Edible Garden (Full Series)

Alys Fowler attempts to avoid shop-bought fruit and vegetables and live off her own, home-grown produce.

1/6 – Peas and Beans

Edible Garden – Peas & Beans by Braggle

2/6 – Salads

Edible Garden – Salads by Braggle

3/6 – Roots and Leafy Greens

Edible Garden – Roots and Leafy Greens by Braggle

4/6 – Juicy Fruits

Edible Garden – Juicy Fruits by Braggle

5/6 – Flowers and Herbs

Edible Garden – Flowers and Herbs by Braggle

6/6 – The Winter Larder

Edible Garden – The Winter Larder by Braggle

Share