Course Description Microsoft Excel is the most popular spreadsheet application for both personal and professional use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2019 training course because it covers basic, intermediate and advanced topics.This course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. In addition, it will help students understand how to manipulate data within a spreadsheet, validate, and present information using the built-in structure and functions of Microsoft Excel.What you will learnThis course includes six hours of training and 58 videos. Throughout the course, students will learn how to save files, entering and formatting data, how to work with formulas, inserting functions, how to use function, customizing charts and more!Video Content: 5 Hours 38 MinutesTest Questions: 54 Excel 2019 Beginner 1.0 Intro1.1 The Ribbon1.2 Saving Files1.3 Entering and Formatting Data1.4 Printing from Excel andamp; Using Page Layout View1.5 Formulas Explained1.6 Working with Formulas and Absolute References1.7 Specifying and Using Named Range1.8 Correct a Formula Error1.9 What is a Function1.10 Insert Function andamp; Formula Builder1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE1.12 Create and Customize ChartsExcel 2019 Intermediate 2.0 Recap2.1 Navigating and editing in two or more worksheets2.2 View options - Split screen, view multiple windows2.3 Moving or copying worksheets to another workbook2.4 Create a link between two worksheets and workbooks2.5 Creating summary worksheets2.6 Freezing Cells2.7 Add a hyperlink to another document2.8 Filters2.9 Grouping and ungrouping data2.10 Creating and customizing all different kinds of charts2.11 Adding graphics and using page layout to create visually appealing pages2.12 Using Sparkline formatting2.13 Converting tabular data to an Excel table2.14 Using Structured References2.15 Applying Data Validation to cells2.16 Comments - Add, review, edit2.17 Locating errors Excel 2019 Advanced 3.1 Recap3.2 Conditional (IF) functions3.3 Nested condition formulas3.4 Date and Time functions3.5 Logical functions3.6 Informational functions3.7 VLOOKUP andamp; HLOOKUP3.8 Custom drop down lists3.9 Create outline of data3.10 Convert text to columns3.11 Protecting the integrity of the data3.12 What is it, how we use it and how to create a new rule3.13 Clear conditional formatting andamp; Themes3.14 What is a Pivot Table and why do we want one3.15 Create and modify data in a Pivot Table3.16 Formatting and deleting a Pivot Table3.17 Create and modify Pivot Charts3.18 Customize Pivot Charts3.19 Pivot Charts and Data Analysis3.20 What is it and what do we use it for3.21 Scenarios3.22 Goal Seek3.23 Running preinstalled Macros3.24 Recording and assigning a new Macro3.25 Save a Workbook to be Macro enabled3.26 Create a simple Macro with Visual Basics for Applications (VBA)3.27 Outro Courses Include 12 Months Unlimited Online Access to: Expert Instructor-Led Training: Learning247 uses only the industry’s finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7. Visual Demonstrations andamp; Multimedia Presentations: Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. Learning247 always focuses on real world scenarios and skill-set development. Quizzes andamp; Exam Simulators: Learning247’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course. Learning247 courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam. Mobile Optimization andamp; Progress Tracking: Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded. Flash Cards andamp; Educational Games: Learning247 knows that education is not a one size fits all approach. Students learn in different ways through different tools. That is why we provide Flash Cards and Education Games throughout our courses. This will allow you to train in ways that keep you engaged and focused. Each course will have dozens of Flash Cards so you can sharpen your skill-sets throughout your training as well as educational games designed to make sure your retention level of the materials is extremely high. Navigation and Controls: Learnig247’s self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule. Certificate of Completion: Upon completion of your training course, you will receive a Certificate of completion displaying your full name, course completed as well as the date of completion. You can print this out or save it digitally to showcase your accomplishment. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
