My latest Excel Video Training Resource is “Nine Essential Excel Skills.” I have published versions for both Excel 2010 and Excel 2007. You can purchase them as either a DVD-ROM that I ship to you; or in a version that you can Download immediately.
Why Nine Essential Excel Skills?
As I created this Excel Video Training Resource, I had two distinct customers in mind:
- Everyday Excel users who know that they could get more out of Excel if only they had a structured approach to training that used “real life” business examples.”
- Experienced Excel users who want to prepare to take the Microsoft Office Specialist (MOS) 2010 or 2007 Certification Examinations for Excel.
Essential Skill #1 Video Lessons
Essential Excel Skill #1
I have identified Essential Excel Skill # 1 as “Entering Data Efficiently.” In the world of business there is a common acronym – GIGO – which means, “Garbage In delivers Garbage Out.” In order to produce accurate and meaningful reports in Excel, you MUST begin with data that is entered correctly.
Entering Time and Date Values
In my experience, many Excel users incorrectly enter Time values and Date values. Times and Dates are “Numeric Values.” When Time and Date Values are entered correctly, they align to the right-side of the cell. Once they are entered correctly, you can change their formatting to suit your purpose.
Keyboard Shortcuts for Current Date & Time
- Ctrl + ; (semi-colon) enters the Current Date into the cell. This creates a “Date Stamp.”
- Ctrl + Shift + : (colon) enters the Current Time into the cell. This creates a “Time Stamp.”
AutoFill Options – Weekdays Only
Speed Up Data Entry with AutoFill Options
Use AutoFill to quickly – and accurately – fill in the Months of the Year and the Days of the week. I demonstrate – in detail – how to take advantage of the many AutoFill Options that are available. For example, to AutoFill Weekdays Only! I am confident that you will gain many productivity tips from the video tutorials in this Skills chapter.
Fill Series Dialog Box
Many Excel users have never used the “little gem” that is the Fill Series Dialog Box. As you will learn in the video tutorial, you can quickly fill in a long series of numeric values by using the “Step Value” and “Stop Value” fields in this dialog box.
Download the Complete Step-by-Step Instruction Guide – for Free!
I am so confident that you will want to purchase my video training resource, that I am offering you the opportunity to download – for Free! – the 29 page Instruction Guide that is included in “Nine Essential Excel Skills.” Click on the link to begin to download either version as a PDF:
- Free Instruction Guide – “9 Essential Excel 2010 Skills”
- Free Instruction Guide – “9 Essential Excel 2007 Skills”
Learn More About My Video Training Resources
My “Master Excel in Minutes – Not Months” series of video training resources is growing quickly! Follow this link to see the resources that are available now!
Watch My Excel Tutorial in High Definition
Follow this link to watch my tutorial in High Definition on my YouTube Channel – DannyRocksExcels
Watch Video Tutorial Now
