The page you are looking for no longer exists. Perhaps you can return back to the site's homepage and see if you can find what you are looking for. Or, you can try finding it with the information below.
Pages:
- About The Company Rocks
- Archived Newsletters
- Index to Excel Video Lesson Topics
- Index to PowerPoint Video Lessons
- Membership Content
- Secure Shopping Site
- The Excel Home Page
- The PowerPoint Home Page
- WishList Member
- Training Courses
Categories:
- Access Tips and Timesavers
- Add Video to Your Website
- Advocacy
- Associations
- Business Communications
- Business Practices
- Career
- Change Management
- Communications
- Conditional Formatting
- Consolidate Excel Data
- Consulting
- COUNTIF and SUMIF Functions
- Customer Service
- Data Filters and Queries
- Data Validation
- Date Functions and Formats in Excel
- Download Files from Video Lessons
- Essential Excel Skills
- Everyday Calculations in Excel
- Excel 2003 Video Lessons
- Excel Basics
- Excel Charts
- Excel Data Tables and Lists
- Excel Date and Time Functions
- Excel Financial Tools
- Excel Forms
- Excel Formulas
- Excel Functions
- Excel Macros
- Excel Training
- Excel VBA Macros
- Ezine Articles
- Format Cells in Excel
- Goal Seek in Excel
- Goals
- Grants
- How to Lead Effective Meetings
- Import Data into Excel
- Integrating MS Office Programs
- Interactive Webpages
- Keyboard Shortcuts
- Leadership
- Lessons Learned
- Lookup Functions in Excel
- Main Page
- Managing
- Marketing
- Membership Content
- Mentors
- Merchandising
- Most popular articles
- Most Viewed Excel Videos
- Motivation
- MS Excel 2007 DVD
- MS Excel Tips
- MS Excel Training
- MS PowerPoint
- MS PowerPoint 2007
- MS Word
- Names for Cells and Ranges
- NAMM Show
- NAMM University
- New in Excel 2007
- New in Excel 2010
- Non-Verbal Communications
- Online Store for The Company Rocks
- Persuasion
- Photos
- Pivot Tables
- Podcast Tips & Timesavers
- Political Strategy
- PowerPoint
- Powerpoint Techniques
- PowerPoint Video Training
- Presentations
- Press Releases
- Public Speaking
- Quotations
- Reviews
- Sales
- Small Business
- Speaking
- Speeches
- Subtotals and Outlines in Excel
- SUMIF and SUMIFS Functions
- Survey Results
- Text Functions
- The Idea Center at the NAMM Show
- Tips and Time Savers
- Training
- Uncategorized
- Video Response to Viewers
- Video Training Courses
- WebEx by Cisco
- WebEx Recordings & Webinars
- What-if Analysis
- Word Tips
- Words per Minute
- Work with Multiple Worksheets
- Workbooks and Worksheets in Excel
- YouTube Videos by Danny Rocks
Authors:
Monthly:
- June 2014
- October 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- December 2009
- November 2009
- October 2009
- September 2009
- June 2009
- April 2009
- March 2009
- February 2009
- December 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- August 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
Recent Posts:
- How to Quickly Rearrange the Order of Columns in an Excel Worksheet
- 4 Million Views on My YouTube Channel – DannyRocksExcels
- Working with Worksheets in Excel Workbooks – Part 1
- How to Copy and Paste Cell Formatting Only in Excel
- 2.9 Million Views for My YouTube Channel – DannyRocksExcels
- How to Edit an Excel Macro that You Recorded
- Excel Macros: When to Use Relative Cell Referencing When Recording
- The 4 Steps to Take Before Recording an Excel Macro
- How to Work with Numeric Values in an Excel Pivot Table
- Excel Pivot Tables Tutorials: My YouTube Playlist
- How to Prevent Empty Cells from Displaying in a Pivot Table
- How to Use Multiple Sorting Options in Excel
- How to Use a Data Validation Formula When Creating a Budget
- Learn How Excel Stores and Formats Dates
- Essential Excel Skill #3: Creating and Using Named Cell Ranges in Excel
- Essential Excel Skill #2: Selecting Cells Efficiently
- Survey Results – Which Version of Excel Are You Using
- Essential Excel Skill #1: Entering Data Efficiently
- Two Glowing Reviews for my Excel Video Tutorials
- How to Correct #N/A Error Messages for Excel’s VLOOKUP Function
- The 10 Most Watched Excel YouTube Videos for September 2012
- How to Clear Cell Formatting In Excel
- How to Quickly Clear All Text Formatting from PowerPoint Slides
- How to Use Lookup Functions in Excel – Take a Free Lesson from My Latest Video Training Resource
- Instructional Guide “9 Essential Excel 2010 Skills” – Download for Free
- How to Use a Check Box to “Toggle” Conditional Formatting On or Off in Excel
- How to Dynamically Color-Code Dates with Conditional Formatting in Excel
- Review for my Latest Publication – “9 Essential Skills for Excel 2010”
- Take a Complete,10 Minute, Video Lesson from my Latest Publication
- How to Highlight Different Values in a Row with Excel’s Go To Special
- DannyRocksExcels on YouTube Recognized as a Top 10 Channel for MS Excel Tutorials
- How to Combine 2 Excel Workbooks Using VLOOKUP Function
- How to Use Excel’s Histogram Tool and The 80/20 Rule of Analysis
- My Top 10 Most Viewed Excel Tutorials on YouTube Year-to-Date in 2012
- How to Use an Array Function in Excel – Learn How to Use the Frequency Function
- How to Group People by Age Bracket Using an Excel Pivot Table
- How to Group an Excel Pivot Table Field to Summarize By Hours
- How to Create a Series of 30 Minute Time Intervals in Excel
- How to Calculate the Calendar Year Quarter for a Date in Excel
- How to Place Dates in a Fiscal Year Quarter
- How to Add Summary Information for Excel Workbook Properties
- How to Create Hyperlinks in Excel
- Microsoft Access – A Quick Video Tour of my DVD, The 50 Best Tips for Access 2007
- How to Perform Time Period Calculations in Excel
- How to Roll Up a Summary by Month to Filter an Excel Pivot Table
- Use Conditional Formatting in Excel to Highlight Cell Values that Match Criteria
- How to Analyze Point-of-Sale Data with an Excel Pivot Table
- How to Protect Cells that Hold Formulas in Excel
- How to Use Named Ranges in Existing Excel Formulas
- 3 Reasons to Create and Use Named Ranges in Excel Formulas
- How to Use Excel Formulas and Functions to Analyze Inventory for a Retail Store
- The Basics for Creating and Copying Formulas and Functions in Excel
- How to use Wrap Text and Merge Cells Formatting to Improve Excel Worksheet Appearance
- How to Apply Alternate Row Shading Using Conditional Formatting in Excel
- How to Create Custom Views of a Worksheet in Excel
- How to Freeze Row and Column Labels While Scrolling an Excel Worksheet
- How to Clear All Underlying Cell Formatting in Excel
- Summarizing Employee Hours Worked and Vacation Time over 52 Weeks in Excel
- Use an Excel Template to Customize a Worksheet with 52 Weeks of Employee Time Cards
- Tips for Creating 52 Weeks of Employee Time Cards in Excel
- Excel Keyboard Shortcuts for Navigating Between Cells, Worksheets, Documents and Programs on your Computer
- How to Distinguish Cell Content from Cell Formatting in Excel
- How to SUM Values in One Field Based on Criteria from Multiple Fields in Excel
- How to Return Either an Approximate or Exact Match for VLOOKUP Function
- How to AutoFill the Letters in the Alphabet in Excel
- How to Use the New Natural Language Date Filters in Excel
- How to Automatically Add a Time / Date Stamp Whenever You Add or Edit a Record in Excel
- 20 Tips for Delivering a Successful Presentation
- Tips for Working with Array Formulas and Functions in Excel
- How to Use the Offset Function Inside a VLookup in Excel
- Structured Formula References in Excel 2007 and Excel 2010 – Part 2
- Master Excel Pivot Tables in 90 Minutes: Announcing My New Extended Length Video Tutorials!
- How to Use Structured Formula References for Tables in Excel 2007 and Excel 2010
- How to Use the Show As Values Dialog Box for an Excel Pivot Table
- How to Take Advantage of the Go To Special Dialog Box Options in Excel
- How to Use the Solver Add-in for Excel – Part 2
- How to Use the SOLVER Tool in Excel to Produce the Optimal Result for a Formula
- How to Create a Summary Report from an Excel Table
- How to Identify and Then Delete Duplicate Records in Excel
- How to Prevent Duplicate Entries in Excel with Data Validation
- Keyboard Shortcuts to Enter and Edit Data Efficiently in Excel
- How to Use Criteria in Excel Functions and Filters
- Record a Macro in Excel to Fix an Imported Text File
- Excel Keyboard Shortcuts to Fill a Series
- Excel Keyboard Shortcuts to Hide, Unhide, Insert and Delete Cells, Columns and Rows
- How to Use Excel Keyboard Shortcuts to Cut, Copy and Paste Formulas and Formatting
- How to Use Keyboard Shortcuts in Excel to Control Basic File Operations
- How to Customize the Quick Access Toolbar in Excel 2007
- Tips to Help You Remain Productive When Upgrading to Excel 2007
- Use the Show Values As Formulas in Excel Pivot Tables
- 3 Work-Arounds for Shortcomings in Calculated Fields in Excel Pivot Tables
- How to Drill Down in a Pivot Table to Display the Details for a Summary Cell
- Create a Pivot Chart to Present a Frequency Distribution Report
- Formatting an Excel Pivot Table Frequency Report
- Use Excel Pivot Table to Determine Frequency Distribution of Invoice Amounts
- My Two Most Popular Excel Tutorials on YouTube
- Three and a Half Ways to Average Excel Data Using Criteria
- Use Excel’s AutoFill Tools and Formulas to Increment Time Intervals
- Use Excel’s AutoFill Options and Formulas to Increment a Series of Dates
- How to Embed a PowerPoint Presentation on Your Blog or Website