Overview

**This bundle includes practice exercises, downloadable files, and LIFETIME access**Learn all the tools you'll need to become a Microsoft Excel 2021/365 power user with this great value 3-course training bundle for beginner to advanced users from Simon Sez IT.Let us take you on a journey from being an Excel novice to an Excel guru. By the end of these training courses, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more!All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.This Excel ultimate bundle is designed for students of all levels. If you are brand new to Microsoft Excel or are upgrading from a previous version and want to keep up to date with Excel 2021 developments, then this bundle is for you.If you already have a good understanding of Excel, you might want to check out the intermediate and advanced sections where our expert instructor will help you take your spreadsheet skills to the next level.What's included?Excel 2021 for BeginnersBecome familiar with what's new in Excel 2021Navigate the Excel 2021 interfaceUtilize useful keyboard shortcuts to increase productivityCreate your first Excel spreadsheetUse basic and intermediate Excel formulas and functionsEffectively apply formatting to cells and use conditional formattingUse Excel lists and master sorting and filteringWork efficiently by using the cut, copy, and paste optionsLink to other worksheets and workbooksAnalyze data using chartsInsert pictures in a spreadsheetWork with views, zooms, and freezing panesSet page layout and print optionsProtect and share workbooksSave your workbook in different file formatsExcel 2021 IntermediateDesigning 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.Excel 2021 AdvancedUsing the NEW dynamic array functions to perform tasksCreating advanced and flexible lookup formulasUsing statistical functions to rank data and to calculate the MEDIAN and MODEProducing accurate results when working with financial data using math functionsCreating variables and functions with LET and LAMBDAAnalyzing data with advanced PivotTable and PivotChart hacksCreating interactive reports and dashboards by incorporating form controlsImporting and cleaning data using Power QueryPredicting future values using forecast functions and forecast sheetsRecording and running macros to automate repetitive tasksUnderstanding and making minor edits to VBA codeCombining functions to create practical formulas to complete specific tasks.This bundle includes:30+ hours of video tutorials270+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Skills

Reviews