Microsoft Excel for Beginner to Intermediate and Advanced

About this course

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, SUBTOTAL

Course objectives

• Provide fundamental Excel skills to enhance productivity
• Enable practical application of Excel features in daily tasks
• Build a strong foundation for analyzing and visualizing data