Description

Just about everyone will find themselves having to use Microsoft Excel at work at one point or another, and 2010 and 2013 are two of the most popular, and powerful, versions around. That means that everyone could benefit from devoting some time to mastering the program, as Excel mastery can not only have a huge impact on your own productivity, but can look hugely impressive to your boss. With our Ultimate Microsoft Excel Training Bundle youll find basic and advanced courses for both Microsoft Excel 2010 and 2013 so that youre ready to go, no matter what version of the software youre faced with. This bundle includes: 33 hours of video tutorials Over 200 individual video lectures 4 quizzes with 165 test questions Certificate of completion Courses included with this bundle: Microsoft Excel 2013 Beginners/Intermediate Training During this 10-hour Online Excel 2013 Training, youll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, youll discover how to enter and format data in the quickest manner possible. Next youll be introduced to the power of Excels functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, youll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise. Learn Microsoft Excel 2013 – Advanced Your expert instructor will kick the course off by leading you through graph and chart basics. Then, youll explore Excels array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, youll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more. Learn Microsoft Excel 2010 Our professional instructor will talk you through Excel 2010s features, starting with the basics, from creating files to editing existing documents. Next youll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. Youll then move onto sorting and filtering data, linking multiple files, and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 – Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. Excels tools are covered in depth which includes discussions on and are setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. You can move columns and rows to understand how the numbers relate more easily than ever before. Where else can you find so many extra tools to help you gain advanced skills in Excel? So start learning today. What People Are Saying: I love how this is broken down into bite sized chunks & the lectures are short & relevant, easy to follow. Andrea Levett Many great tips and tricks – even for the daily user! Allison Daggs “I am now a business analyst and I attribute my promotion directly to your courses. Im much more savvy and confident with Excel. Thanks Simon.”-Daniel Venti Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.