You last viewed this video on at (). You have now viewed this lesson time. ** IMPORTANT ** When you have completed this course you will be able to download and print a completion certificate to certify your achievement. Because you are not logged in, this video view cannot be used as a credit towards your certification. You'll have to watch it again in order to receive your certificate at the end of the course. Click Here To Register Now (you'll then be able to print your certificate at the end of the course). for a video lesson teaching a specific Excel feature to ask an Excel expert for the solution to your Excel problem How to Use Our Courses The Smart Method is a teaching methodology developed after many years of running classroom courses for many of the world's largest corporations. We've had a 100% success rate when teaching our students Excel in our classroom courses. If you follow our learning recommendations, there is absolutely no doubt that you will master Excel. If you don't follow our recommendations it's possible that you will learn Excel eventually. But if you're serious about mastering Excel as quickly and efficiently as possible you should follow the recommended learning method suggested on this page. Three Important Rules #1 - Complete the course from beginning to end It is always tempting to jump around the course completing lessons in a haphazard way. We strongly suggest that you start at the beginning and complete lessons sequentially. That's because each lesson builds upon skills learned in the previous lessons and one of our goals is not to waste your time by teaching the same skill twice. If you miss a skill by skipping a lesson you'll find the later lessons more difficult, or even impossible to follow. This, in turn, may demoralize you and make you abandon the course. #2 - If possible, complete a session in one sitting The courses are arranged into Sessions and Lessons. Most Sessions are less than two hours (of video play time) in duration. You'll learn better if you lock yourself away, switch off your telephone, and complete the whole session without interruption. The memory process is associative and we've ensured that every lesson within each session is very closely coupled (contextually) with the others. By learning the whole session in one sitting, you'll store all of that information in the same part of your memory and will find it easier to recall later. The experience of being able to remember all of the words of a song as soon as somebody has got you "started" with the first line is an example of the memory's associative system of data storage. #3 - Rest at least every hour In our classroom courses we have often observed a phenomena that we call "running into a wall". This happens when a student becomes overloaded with new information to the point that they can no longer follow the simplest instruction. If you find this happening to you, you've studied for too long without a rest. You should take a 15 minute break every hour (or more often if you begin to feel overwhelmed) and spend it relaxing rather than catching up with your e-mails. Ideally you should relax by lying down and closing your eyes. This allows your brain to use all of its processing power to efficiently store and index the skills you've learned. We've found that this hugely improves retention of skills learned. How to work through the lessons Use a book-to-video or video-to-book sequence when working through the lessons There are two methods that work well with our courses. You'll need to experiment with both in order to decide the one that works best for you. Book-to-video This is the fastest way to learn but can be more stressful. Because you can watch the videos on any online mobile device (such as an iPad or Android tablet device) it is possible to do the recap anywhere (for example when travelling to and from work). Lessons that have subtitles can even be viewed in noisy environments (or in those where silence must be maintained). At the end of each session Keep attempting the exercise at the end of each session until you can complete it without having to refer to any of the video (or book) lessons in the session. Don't start the next session until you can complete the exercise without assistance. If you follow these recommendations there is no doubt that you will master Excel. A little time and effort is needed but the skills you'll acquire will be hugely valuable for the rest of your life. Enjoy the course.
The following 6 areas form the core of basic Excel skills. These basic Excel skills are – familiarity with. Getting Started with Excel – 10 minute video tutorial ..
Excel 2013 is the spreadsheet application in the newest Microsoft Office suite. This tutorial will show you how to use the powerful tools in Excel 2013 for organizing, visualizing, and calculating your data. If you'd like more practice creating formulas, you may also want to check out our Excel Formulas tutorial!
