Essentials of Microsoft Excel – Beginner to Advanced

24

Essentials of Microsoft Excel – Beginner to Advanced , Fundamental step-by-step, format worksheets, tables, functions, charts, pivot table, conditional format, import, macros.

What you”ll learn ,

  • Learn the essentials of Microsoft Excel
  • Hands-on practice files while watching lectures
  • Learn at your own pace with concise lectures
  • Create charts, reports, Pivot Table, Power Pivot, Power Query import, Insert slicers and time lines,
  • Learn common functions to simplify tasks, dive into database functions, HLOOKUP, VLOOKUP, MATCH, XMATCH, XLOOKUP and more.
  • Use AI – ChatGPT to create sample datasets, charts
  • Create What-If Analysis: goal seek, data table, scenario manager, automate tasks with macros, shortcuts
  • Customize ribbon, quick access toolbar, status bar, link worksheets, protect worksheets, understand relative and absolute referencing
  • Conditional formatting, create data validation, named ranges, link worksheets, consolidate, grouping, format painter, printing techniques
  • Format table and borders, create template, insert shapes, images, smart arts, format dates, freeze pane, filtering, sorting, flash fill, texts to columns
  • Build a solid foundation of Excel to advance your career

Course Description

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!

Who this course is for:

  • Anyone who wants to have a good fundamental of Excel
  • To be productive at works, schools or self-improvement
  • Promotional opportunities
  • Anyone who wants to take the skill to a high level
$9.99 $34.99 Redeem Coupon
We will be happy to hear your thoughts

Leave a reply

100% Off Udemy Coupons
Logo