![]() Using Paste Special Options in Excel 2010.Working with Excel 2010 Formulas and Functions.Working with Structured Data Sets in Excel 2010.Applying Styles and Formatting to Excel 2010 Worksheets.Creating and Using Named Cell Ranges in Excel 2010.Selecting Cell Ranges Efficiently in Excel 2010.Entering Data Efficiently in Excel 2010.These are the 9 Essential Skills that I have identified for my video tutorial: List of the “9 Essential Excel 2010 Skills”ĩ Essential Skills for Excel 2010 Video Tutorial ![]() The “9 Essential Excel 2010 Skills” – Downloadable version.The “9 Essential Excel 2010 Skills” on a DVD-ROM.I am convinced that once you see the scope of the training in Excel 2010 that I offer, you will want to purchase the video tutorial. Read the Instructional Guide and then Purchase my Video! I created my Instructional Guide using the free Adobe Acrobat Reader.So, once the download is completed, be sure to “unzip” this file! You will be downloading a “zipped” file.Shortly after you complete the checkout process you will receive an email that contains a hyperlink to the file that you will download.Even though you will be downloading this product, I had to set it up as a physical product with “Free Shipping.”.You will need to provide a valid email address in order to receive the actual link to download my Instructional Guide.During Checkout, you can choose to either Register or Shop as a Guest.Add this product to your secure shopping cart at my website.Instructions for Downloading the Free Instructional Guide Link to The Company Rocks Free Resources PageĬlick on this link to begin the download process for the Instructional Guide. I want you to discover the scope of the Excel Training that I offer on my new video tutorial, “9 Essential Excel 2010 Skills.” So, I am offering the PDF of the Step-by-Step Instructional Guide that accompanies the video tutorial. Instructional Guide “9 Essential Excel 2010 Skills” 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įollow this link to watch my tutorial in High Definition on my YouTube Channel – DannyRocksExcels Watch Video Tutorial Now Learn More About My Video Training Resources Free Instruction Guide – “9 Essential Excel 2007 Skills”.Free Instruction Guide – “9 Essential Excel 2010 Skills”.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: Download the Complete Step-by-Step Instruction Guide – for Free! 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. Many Excel users have never used the “little gem” that is the Fill Series Dialog Box. For example, to AutoFill Weekdays Only! I am confident that you will gain many productivity tips from the video tutorials in this Skills chapter. I demonstrate – in detail – how to take advantage of the many AutoFill Options that are available. Use AutoFill to quickly – and accurately – fill in the Months of the Year and the Days of the week. Watch this Excel Video Tutorial in High Definition on my YouTube Channel – DannyRocksExcels!Ĭlick below to watch this video now on YouTube!ĪutoFill Options – Weekdays Only Speed Up Data Entry with AutoFill Options I invite you to visit my secure online shopping website – – to discover the many resources that I offer you! Nevertheless, I find that Excel users at all levels of experience will benefit from this 7 minute video tutorial. So, as a start to a class discussion, I created this YouTube Excel Tutorial where I demonstrate three ways to “Paste the Formatting Only” from one location to multiple locations in an Excel Worksheet.īefore I presented my course work for Week #1, I surveyed my class and realized that the majority of students were either novice or “rusty” users of Excel. While I was grading my Week #1 assignments, I found that many students were unfamiliar with Excel’s AutoFill Option for “Filling the Formatting Only” in a contiguous range of cells. Now, when I assign my weekly assignments to my class, I can quickly spot the common “stumbling blocks” or questions that many student have. This is a robust framework for presenting course work and interacting with my students! One of my clients, VanderCook College of Music, has recently adopted Schoology for their Learning Management System (LMS). For the past several months, I have been teaching MS Excel online for the Continuing Education Courses at several major colleges here in the USA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |