Overview

This course takes you from beginner to advanced. The course consists of short and concise lectures to keep you focused and engaged. Each lecture has accompanied lecture files for you to practice along. You learn your best with practice and complex subjects will sink in.My objective is for you to grab the fundamental. You learn practical uses of Excel to apply immediately.You'll learn the following: Navigate around Excel workbook, worksheets, the ribbon, quick access tool bar, status barEnter and edit data, move, copy, cut, indent, align, zoomFormat painterAbsolute and relative referencingPrinting set up and sharingData tools for sorting, filtering, totaling, highlight duplicates, uniqueCreate chartsCreate tablesCreate templatesFormat as tableFormat datesShortcutsNamed constant, named rangeData validationText to columnsFlash fillGrouping, consolidateNamed rangeDynamic named rangeSortingWhat-If Analysis with goal seek, data tables, scenario managerUse Power Query to import from text/csv, get-dataFormat as table, auto fill, merge cells, adjust rows and columns, insert bordersFreeze pane, conditional format, Insert shapes and images, templatesLink worksheetProtect worksheetText functions: OFFSET, CONCATENATE, IF, SEARCH, FIND, REPLACE, SUBSTITUTE, REPLACE, LEN, TRIM, FILTERLOWER, UPPER, PROPER, REPT, RIGHT, LEFT,Conditional functions: IF, SEARCH, CONCATENATEIF, FIND DUPLICATES with IF COUNTIF, SUMIF, SUMIFS, COUNTIF,COUNTIFS, COUNT, COUNTA, AVERAGEIF, AVERAGEIFS, SUBTOTALAdvanced functions: MATCH, INDEX, HLOOKUP, VLOOKUP, XLOOKUP, XMATCHDatabase functions: DSUM, DCOUNT, DCOUNTA, DAVERAGECreate from selectionFormula auditingPivot table, Pivot chart, Power Pivot, KPI, slicersCreate sample practice files with ChatGPTMacrosAnd moreWhat you get for enrolling:Risk-free 30-day money-back guaranteeLifetime access that you can review any timeAccess Q & A to get helpCertificate of completion to add to your career pathPractice files are included with the lectures for you to practice while watching. You'll gain confidence and apply what you learn immediately. Excel can be useful for works and promotion or your own business. Start learning today!

Skills

Reviews