Overview

***Exercise and demo files included***We've combined our Excel 2021/365 for Absolute Beginners and Excel 2021/365 Intermediate courses to give you the ultimate starter pack to jump-start your spreadsheet journey!Whether you're an Excel novice or already have some Excel knowledge, this course can help you get the ball rolling. This course bundle will give you a great Excel foundation or build on those skills you already have. It's also perfect for students who have beginner to intermediate skills in an older version of Excel and are looking to explore the newest features.Excel 2021 is Microsoft's latest stand-alone version of Excel, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.The only prerequisite for this course is a working copy of Excel 2021 or Excel 265.This course covers:Becoming familiar with what's new in Excel 2021Navigating the Excel 2021 interfaceUtilizing useful keyboard shortcuts to increase productivityCreating your first Excel spreadsheetUsing basic and intermediate Excel formulas and functionsEffectively applying formatting to cells and using conditional formattingUsing Excel lists and master sorting and filteringWorking efficiently by using the cut, copy, and paste optionsLinking to other worksheets and workbooksAnalyzing data using chartsInserting pictures in a spreadsheetWorking with views, zooms, and freezing panesSetting page layout and print optionsProtecting and sharing workbooksSaving your workbook in different file formatsDesigning better spreadsheets and controlling user inputHow to use logical functions to make better business decisionsConstructing functional and flexible lookup formulasHow to use Excel tables to structure data and make it easy to updateExtracting unique values from a listSorting and filtering data using advanced features and new Excel formulasWorking with date and time functionsExtracting data using text functionsImporting data and cleaning it up before analysisAnalyzing data using PivotTablesRepresenting data visually with PivotChartsAdding interactions to PivotTables and PivotChartsCreating an interactive dashboard to present high-level metricsAuditing formulas and troubleshooting common Excel errorsHow to control user input with data validationUsing WhatIf analysis tools to see how changing inputs affect outcomes.This course includes:20+ hours of video tutorials180+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Skills

Reviews