Duration 10 h 14 m 24 s
Unlock the full potential of Microsoft Excel and embark on a transformative journey from novice to master with our comprehensive course, "Microsoft Office Excel: Beginner to Advance."
Whether you're an absolute beginner or seeking to upgrade your Excel skills, this course is your gateway to becoming a proficient Excel user.
Course content
Excel from A-Z3 m 21 sWhat is Microsoft Excel4 m 16 sWho is this Course for?3 m 30 sMicrosoft Excel Marketplace4 m 9 sMicrosoft Office Excel Job Opportunities2 m 43 sExcel Job Types3 m 51 sFinding and Opening Excel1 m 4 sExcel Workbook vs Excel Worksheet2 m 13 sExcel Shortcut Keys1 m 43 sAdjusting Height and Width4 m 34 sHiding and Unhiding Excel Rows and Columns4 m 28 sRenaming, Moving and Deleting Excel Worksheets5 m 27 sAdding Protection to Specific Cells4 m 24 sProtecting the Structure of a Workbook2 m 12 sAdding a Workbook Password2 m 10 sGrab User's Attention using Illustrations8 m 39 sCustomizing Icons4 m 41 sCreate Compelling Graphics with SmartArt5 m 36 sExcel Page Layout Preview6 m 37 sPrinting a Specific Range of Cells2 m 38 sConverting Spreadsheets to PDF2 m 28 sFormatting Fonts and Cell Background Colour4 m 55 sAdding Cell Borders4 m 47 sFormatting Data Appropriately5 m 21 sThe Magic Behind Excel's Format Painter3 m 30 sCreating Styles for Formatting Efficiency5 m 56 sMerging Cells for a Cleaner Look3 m 27 sThe Power of Conditional Formatting6 m 9 sExcel Functions Explained2 m 35 sMin()-Max() Function3 m 44 sSUM() Function7 m 31 sAVERAGE() Function2 m 1 sCOUNT() Function4 m 57 sExcel IF Function5 m 17 sIF() Function with AND()5 m 23 sIF() with OR()5 m 14 sNesting Multiple IF()7 m 24 sCOUNTIF() Function4 m 6 sWhat is Excel Data Validation?1 m 56 sCreating a Dropdown List7 m 9 sDifferent Types of Data Validation5 m 39 sAdding Custom Alerts to Data Validation6 m 53 sCreating a Dynamic Dropdown List3 m 10 sComplex Validation8 m 39 sCreating an Excel PivotTable5 m 31 sModifying Excel PivotTables5 m 39 sGrouping6 m 30 sDrilling Down into PivotTable Data2 mCreating Pivot Charts8 mWhat is Power Pivot?3 m 46 sActivating the Excel PowerPivot Add in1 m 34 sCreating Relationships Between Data Tables6 m 22 sUsing Data Models to Create Pivot Tables4 m 31 sHow to Create PowerPivot KPI's8 m 26 sLEFT(),RIGHT() and MID() Function7 m 8 sExtracting Specific Text Using LEN() and SEARCH()12 m 45 sCombining Text with CONCATENATE()6 m 5 sQuick Tips5 m 49 sSUMIF() Function8 m 42 sDSUM() Function7 m 47 sDSUM() Function Cont.7 m 6 sSUBTOTAL() Function6 m 29 sVlookUp() Function9 mBeauty of Excel's IFERROR() Function3 m 56 sHLookUp() Function6 m 21 sINDEX() Function4 m 43 sMATCH() Function4 m 56 sTwo-Way Lookup4 m 10 sEntering Numerical Values in Excel3 m 25 sFormatting Date Values in Excel5 m 19 sTracing Precedents4 m 28 sShowing Formulas1 m 53 sGrouping Data2 m 42 sReferencing in Formulas5 m 4 sUtilizing the Watch Window in Excel2 m 44 sFreeze Panes in Excel2 m 56 sIntroduction to VBA2 m 14 sModules and Procedures6 m 34 sObjects, Methods and Properties5 m 59 sExcel VBA Variables4 m 39 sReferencing a Range13 m 30 sInputBox5 m 33 sUsing Variables in VBA Code4 m 32 sIf then Else Statement10 m 23 sWorksheet Functions inside VBA7 m 32 sCreating User Defined Functions9 m 19 sUser Defined Functions within VBA Script6 m 9 sFind Last Row of Data5 m 46 sFind Last Column of Data3 m 12 sWith Statement4 m 51 sDebugging_Error Handling6 m 36 sDebugging Error Handling (Cont.)6 m 45 sFor Next Loop9 m 12 sDo Until Loop6 m 3 sFor Each Loop3 m 36 sAssigning Macros to Shapes3 m 33 sForm Controls vs ActiveX Controls7 m 50 sWorksheet Events3 m 44 sWorkbook Events2 m 54 sFun with VBA Events6 m 55 sExcel's Scenario Manager5 m 56 sGoal Seek in Excel6 m 15 sCompare Results with Excel Data Tables4 m 24 sSolver Tool10 m 59 sCommonly Used Column Chart2 m 46 sChanging Chart Design1 m 58 sFormatting Elements of a Chart6 m 24 sModifying the Data6 m 6 sLittle Slice of Pie Charts5 m 12 sCreating an Excel Resume4 m 51 sGetting Started with Freelancing6 m 16 sHow to Become an Excel Freelancer5 m 12 sTop Freelance Websites5 m 12 sHow to Get Your First Client7 m 45 sPersonal Branding6 m 47 sNetworking Do's and Don'ts4 m 22 sThe Importance of Having a Website4 m 24 s
Director and Owner
