Course Outline Learn the skills every Microsoft Excel user needs to know - no matter how new (or how experienced) you are… Whether you want to learn Excel 2019 or 2016, or upgrade from one version to the next, our expert instructors will use a hands-on, engaging approach to teach you all of Excel’s powerful features. Watch a single title or watch them all, as many times as you like for an entire year - all at one low price. Example Video (From Excel 2016) Many students ask us why we create our larger course bundles, when some people may not have time to complete all the courses inside the 12 month subscription window…Well, essentially they’re created to enable you to dip in and out of multiple related programs and obtain cross-referenced knowledge; the intention is not for you to study it all or sit all the exams! With any kind of technical learning, building your background knowledge on closely related areas makes a lot of sense. Therefore, having access to a wide range of connected programs enables you to research related topics to the actual program you’re studying for (often just watching the video/tutorial), enhancing your overall understanding. This is why we create the larger bundles; to build the breadth of your knowledge. Also, many IT professionals use them as reference material after certification, as we usually provide discounts on subsequent re-subscription - to enable you to have the material as a constant professional reference. Course Description Microsoft Excel 2019 - Beginners With the Microsoft Excel 2019 - Beginners’ course, you will gain a solid grounding in the basics of Excel and progress towards becoming more confident with spreadsheets. Length: 7 hours | Project Files included! This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.What You’ll Learn What’s new in Excel 2019 Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns and cells Cut, Copy and Paste Introduction to functions and formulas Formatting in Excel, including formatting cells and numbers Creating charts and graphs Sorting and Filtering Introduction to PivotTables Logical and lookup formulas - the basics Microsoft Excel 2019 - Advanced In this Microsoft Excel 2019 - Advanced course, you will learn: What’s new/different in Excel 2019 Advanced charting and graphing in Excel How to use detailed formatting tools Lookup and advanced lookup functions Financial functions including calculating interest and depreciation Statistical functions Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web. How to create awesome visualizations using sparklines and data bars Mastery of PivotTables and Pivot Charts Scenario Manager, Goal Seek and Solver Advanced charts such as Surface, Radar, Bubble and Stock Charts Excel 2016 BeginnersThis course assumes you’ve never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you’re using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business.Contents and OverviewThis course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 16 chapters of video lessons and 5 exercise files to gradually become a proficient user.It’s important to note that we don’t assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with Worksheets and formulas and functions.If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process! Microsoft Excel 2016 Intermediate Course Highlights:Picks up where the beginner course left offMore advanced mastery of ExcelPerfect for advancing at workEasy to follow instruction shows you howStep by step tutorials are easy to understandMore advanced use of working with dataMastery of charts and graphsCovers Dynamic Formula and Named RangesHours of fun for anyone interested in ExcelHelps you become an Excel power userPractice what you learned with included exercise files Microsoft Excel 2016 Advanced Course Highlights:Practice what you learned with included exercise filesDetailed easy instruction to master Microsoft Excel 2016Everything explained step-by-step for quick comprehensionThe next step after completing Microsoft Excel 2016 for BeginnersLearn how to import and export data to and from ExcelLearn how to create various charts and graphsEffectively create and use functions and formulasImport and export dataCreate and effectively use Pivot TablesHow to use Excel for data analysisDiscover practical methods for financial andamp; statistical functions Course Format This is a video-led course. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users. For Detailed Course Outlines Visit: Microsoft Excel 2016 Beginner to Advanced Microsoft Excel 2019 Beginner to Advanced * BONUS - Titles Include All Project Files to Work Along with the Instructor Learn anytime, anywhere, at home or on the go.Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
