Microsoft Excel for Beginner to Intermediate and Advanced

Microsoft Excel for Beginner to Intermediate and Advanced free download

Fundamental step-by-step, format worksheets, tables, functions, charts, pivot table, conditional format, import, macros

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 bar

• Enter and edit data, move, copy, cut, indent, align, zoom

• Format painter

• Absolute and relative referencing

• Printing set up and sharing

• Data tools for sorting, filtering, totaling, highlight duplicates, unique

• Create charts

• Create tables

• Create templates

• Format as table

• Format dates

• Shortcuts

• Named constant, named range

• Data validation

• Text to columns

• Flash fill

• Grouping, consolidate

• Named range

• Dynamic named range

• Sorting

• What-If Analysis with goal seek, data tables, scenario manager

• Use Power Query to import from text/csv, get-data

• Format as table, auto fill, merge cells, adjust rows and columns, insert borders

• Freeze pane, conditional format,

• Insert shapes and images, templates

• Link worksheet

• Protect worksheet

• Text functions: OFFSET, CONCATENATE, IF, SEARCH, FIND, REPLACE, SUBSTITUTE, REPLACE, LEN, TRIM, FILTER

• LOWER, UPPER, PROPER, REPT, RIGHT, LEFT,

• Conditional functions: IF, SEARCH, CONCATENATEIF, FIND DUPLICATES with IF COUNTIF, SUMIF, SUMIFS, COUNTIF,

• COUNTIFS, COUNT, COUNTA, AVERAGEIF, AVERAGEIFS, SUBTOTAL

• Advanced functions: MATCH, INDEX, HLOOKUP, VLOOKUP, XLOOKUP, XMATCH

• Database functions: DSUM, DCOUNT, DCOUNTA, DAVERAGE

• Create from selection

• Formula auditing

• Pivot table, Pivot chart, Power Pivot, KPI, slicers

• Create sample practice files with ChatGPT

• Macros

• And more

What you get for enrolling:

• Risk-free 30-day money-back guarantee

• Lifetime access that you can review any time

• Access Q&A to get help

• Certificate of completion to add to your career path

Practice 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!