Master Microsoft Excel - Excel from Beginner to Advanced

Become an Excel Expert in this Microsoft Excel A-Z Course (Microsoft Excel 2010, 2013, 2016, 2019 and 365).

Bullstrack Bullstrack
Mar 14, 2023 - 11:46 Updated: Mar 12, 2023 - 14:25
4.6 0 5
Master Microsoft Excel - Excel from Beginner to Advanced
Master Microsoft Excel - Excel from Beginner to Advanced

Master Microsoft Excel - Excel from Beginner to Advanced udemy course

Become an Excel Expert in this Microsoft Excel A-Z Course (Microsoft Excel 2010, 2013, 2016, 2019 and 365).

What you'll learn:

  • Learn all Microsoft Excel tools
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Microsoft Excel Interface (menu bar, sheets, cells, columns, rows)
  • Basic functions Microsoft Excel (printing, resizing, Autofill, Fleshfill, Shortcuts)
  • Work with data (find and replacing text, Constant link in formulas, Import text, Linking text)
  • Work with formulas ( brief information about all types of formulas)
  • Studying math formulas SUMM, AUTOSUM, AVERAGE, AVERAGEA
  • Studying logical formulas and statements (TRUE, FALSE, IF, IFERROR)
  • Studying other types of formulas ( VLOOKUP, HLOOKUP, MIN,MAX, DATE, DAY, TODAY
  • Studying advance formulas (SUMIF, SUMIFS, COUNTIF, COUNTIFS)
  • Formatting (Draw, Merging, Splitting text, Bordering, Filing (Coloring), Data grouping, text formatting)
  • Filtering and sorting
  • Working with Smart Tables (and slicing)
  • Creating Charts
  • Extra functions (Protect information, Changing menu bars, Notes and comments)

Requirements:

  • You need PC or MacBook
  • You have to have Microsoft Excel or access to Google Spreadsheets

Description:

Microsoft Excel All-In-One Training               

This Microsoft Excel course includes all three Levels from Beginner to Advanced   

  • Microsoft Excel Level 1 – Beginner   

  • Microsoft Excel Level 2 – Intermediate   

  • Microsoft Excel Level 3 – Advanced   

Material recorded with Excel 2016 but works in 2010, 2013, 2016, 2019 and 365. MAC users, since the videos are recorded with the Windows version of Microsoft Excel, the interface will be a bit different.

As your instructor I will use my 17+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.             

At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both Microsoft's Excel Core and Excel Expert Exams and become certified, like me.  Below are just a few of the topics that you will master:   

  • Creating effective worksheets   

  • Writing and editing formulas and calculations   

  • Use sorting and filtering options   

  • Build a database right the first time and avoid common design flaws   

  • Creating informative and captivating Charts   

  • Eliminate repetitive tasks instantly using Macros   

  • Create many scenarios with varying groups of data   

  • Manage large ranges of data in a List or Table

  • Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH and much more...

Who this course is for:

Course Details:

  • 15.5 hours on-demand video
  • 1 article
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Master Microsoft Excel - Excel from Beginner to Advanced udemy free download

Become an Excel Expert in this Microsoft Excel A-Z Course (Microsoft Excel 2010, 2013, 2016, 2019 and 365).

Demo Link: https://www.udemy.com/course/microsoft-excel-2016-excel-from-beginner-to-advanced/

Login to Download  
Tags: