Simon Sez IT – The Complete Excel Bundle

Simon Sez IT – The Complete Excel BundleLearn Excel from Basic to VBA in this 12-Course BundleOur Best Excel Bundle – EVERIf learning Excel has been on your to-do list for years, then now is the time to act! Whether you are an experienced Excel user looking to sharpen your Business Analysis skills, or a complete Excel newbie looking to get your head around this hugely popular spreadsheet tool, this bundle is for you.With 12 full-length courses, hundreds of individual video lectures, and exercise files and tests all included, you do get everything in this Excel bundle. You’ll never need to repurchase another Excel course.Your expert authors have more than 40 years of Excel training experience between them, so you are in good hands.Courses IncludedMicrosoft Excel 2021/365 – Beginners CourseWhat’s new in Excel 2021How to navigate the Excel 2021 interfaceUseful keyboard shortcuts to increase productivityHow to create your first Excel spreadsheetBasic and intermediate Excel formulas and functionsTo effectively apply formatting to cells and use conditional formattingEffective use of Excel lists and sorting and filteringTo work efficiently by using the cut, copy, and paste optionsLinking to other worksheets and workbooksHow to analyze data using chartsHow to insert pictures into a spreadsheetHow to work with views, zooms, and freezing panesSetting page layout and print optionsProtecting and sharing workbooksSaving your workbook in different file formatsMicrosoft Excel 2021/365 – Intermediate CourseDesign better spreadsheets and control user inputUse logical functions to make better business decisionsConstruct functional and flexible lookup formulasUse Excel tables to structure data and make it easy to updateExtract unique values from a listSort and filter data using advanced features and new Excel formulasWork with date and time functionsExtract data using text functionsImport data and clean it up ready for analysisAnalyze data using PivotTablesRepresent pivot data visually with Pivot ChartsAdd interaction to PivotTables and Pivot ChartsCreate an interactive dashboard to present high-level metricsAudit formulas and troubleshoot common Excel errorsControl user input with data validationUse WhatIf analysis tools to see how changing inputs affect outcomes.Microsoft Excel 2019 – Beginners CourseWhat’s new in Excel 2019Creating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns and cellsCut, Copy and PasteIntroduction to functions and formulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas – the basicsMicrosoft Excel 2019 for Mac – BeginnersTo create, open, and save new workbooks in Excel Mac.The basics of how Excel for Mac works, including relative references and order of operations.To set up your workbooks and print the right thing in Excel.To use freeze panes and split screens.To move data around in Excel for Mac.Basic formulas and functions work in Excel for Mac.To format your spreadsheets correctly.To create some fantastic looking charts and graphs.To sort and filter your data in ExcelMicrosoft Excel 2019 – Advanced CourseWhat’s new/different in Excel 2019Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek and SolverAdvanced charts such as Surface, Radar, Bubble and Stock ChartsExcel for Business AnalystsHow to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUPHow to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysisHow to split data using text functions SEARCH, LEFT, RIGHT, MIDHow to standardize and clean data ready for analysisAbout using the PivotTable function to perform data analysisHow to use slicers to draw out informationHow to display your analysis using Pivot ChartsAll about forecasting and using the Forecast SheetsConducting a Linear Forecast and Forecast SmoothingHow to use Conditional Formatting to highlight areas of your dataAll about Histograms and RegressionHow to use Goal Seek, Scenario Manager, and Solver to fill data gapsPower Pivot, Power Query & DAX in ExcelHow to get started with Power QueryHow to connect Excel to multiple workbooksHow to get data from the web and other sourcesHow to merge and append queries using Power QueryHow the Power Pivot window worksHow to set up and manage relationships in a data modelHow to create a PivotTable to display your data from the Power Pivot data modelHow to add calculated columns using DAXHow to use functions such as CALCULATE, DIVIDE, DATESYTD in DAXAll about creating Pivot Charts and PivotTables and using your data modelHow to use slicers to adjust the data you displayAdvanced PivotTables in ExcelHow to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create a basic macro to refresh PivotTable dataVBA for BeginnersIntroduction to VBA as a language (syntax and keywords)How to automate repetitive tasksMacros, sub routines and logical constructsIntroduction to VBA functions including returning values from functionsWriting an array formulaKey Objects and error handling in VBAPivotTable and Chart ObjectsIntermediate VBADeeper dive into the VBA LanguageCore VBA module interactionsAdvanced parameter definitionsExcel events including pre-defined and event parametersCustom Objects including creating and defining a ClassCreating and designing a UserformModifying the Excel interface and UIExternal references and Office InterlopThe ADODB and Scripting LibrariesAdvanced Formulas in ExcelFilter a dataset using a formulaSort a dataset using formulas and defined variablesCreate multi-dependent dynamic drop-down listsPerform a 2-way lookupMake decisions with complex logical calculationsExtract parts of a text stringCreate a dynamic chart titleFind the last occurrence of a value in a listLook up information with XLOOKUPFind the closest match to a valueMacros and VBA for BeginnersExamples of Excel MacrosHow to record your first macroHow to record a macro using relative referencesHow to record a complex, multi-step macro and assign it to a buttonHow to set up the VBA EditorAll about VBA CodeHow to edit Macros in the VBA EditorHow to fix issues with macros using debugging toolsHow to write your own macro from scratchHow to create a custom Macro ribbon and add all the Macros you’ve createdCourse FormatThese are video-led courses. You can preview some videos by selecting a course below.These courses include practice exercises.These courses are aimed at PC Excel users with the exception of the Excel for Mac Beginners CourseWhy Trust Us?Stream Skill is part of the Simon Sez IT family and has been in business 14+ years and taught over 500,000 students in that time. We’ve created over 120 software training courses, 8,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.Your InstructorSimon Sez ITSimon Sez IT makes business and technical software simple to learn.Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.This is why more than a million learners have relied on Simon Sez IT since 2008.Courses Included with PurchaseESSENTIAL VBA TRAINING FOR EXCEL – AUTOMATE REPETITIVE TASKSVBA INTERMEDIATE TRAINING: DISCOVER EXCEL AUTOMATION SECRETSMICROSOFT EXCEL 2019 – ADVANCED COURSEMICROSOFT EXCEL 2019 – BEGINNERS COURSELEARN MICROSOFT EXCEL FOR MAC 2019 – BEGINNERSPOWER PIVOT, POWER QUERY & DAX IN EXCELMICROSOFT EXCEL 2021 INTERMEDIATE TRAINING COURSEADVANCED PIVOTTABLES IN EXCELEXCEL FOR BUSINESS ANALYSTSADVANCED FORMULAS IN EXCELMACROS AND VBA FOR BEGINNERSMICROSOFT EXCEL 2021 – BEGINNER COURSEProof ContentSale Page: https://streamskill.com/p/the-complete-excel-bundleArchive: https://archive.ph/wip/u6LKTDelivery Method– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from esy[GB].– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).Thank You For Shopping With Us!