Microsoft Excel - Beginner to Advanced Crash Course.

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365/2023

4.39 (241 reviews)
Udemy
platform
English
language
Other
category
instructor
6,008
students
2 hours
content
Jan 2024
last update
FREE
regular price

What you will learn

Master Microsoft Excel from Beginner to Advanced

Learn the most common Excel functions used in the Office

Maintain large sets of Excel data in a list or table

Daily Used Excel formula - formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Build a solid understanding on the Basics of Microsoft Excel

Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA

Description

Hello All,

I will use my 8+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023

At completion of this course you will very familiar with most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will make you advance in excel:


  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA


So, what are you waiting for, enroll now and take the next step in mastering Microsoft Excel.


I wish you all to success in your life whatever you learn.

Content

Introduction

Introduction
Microsoft Excel workbook Overview.
Learn Microsoft Excel Range.
Learn Filling Data In Excel.
Learn Filling Data In Excel Sequences.
Learn Moving, Adding and Deleting Cells In Excel.
Learn Formulas and Arithmetic Operation in Excel - Part 1
Learn Formulas and Arithmetic Operation in Excel - Part 2
Learn How to add Parentheses In Excel step by step.
Learn Undo and Redo In Excel.

Excel Functions

Learn Microsoft Excel SUM Function.
Learn Microsoft Excel SUMIF Function.
Learn Microsoft Excel SUMIFS Function.
Learn Microsoft Excel AVERAGE Function.
Learn Microsoft Excel AVERAGEIF Function.
Learn Microsoft Excel AVERAGEIFS Function.
Learn Microsoft Excel CONCATENATE Function.

Screenshots

Microsoft Excel - Beginner to Advanced Crash Course. - Screenshot_01Microsoft Excel - Beginner to Advanced Crash Course. - Screenshot_02Microsoft Excel - Beginner to Advanced Crash Course. - Screenshot_03Microsoft Excel - Beginner to Advanced Crash Course. - Screenshot_04

Reviews

Kenechukwu
January 4, 2024
This course helped me understand how to fully utilize microsoft excel and use its functions and features properly
Hafizur
December 30, 2023
My self Hafiz. I'm doing the course and learning much better than any other courses. This should be a perfect course for beginners who do not no nothing about excel. It helps. Respect for this tutor.
Nowell
December 29, 2023
The main issue is that the description is misleading. You will not cover the topics listed. The descriptions are ok, however, the instructor goes really slow over very basic aspects and then rushes through more advanced topics
Abigail
December 15, 2023
It was a good course that gave good explanations and had easy-to-follow instructions. The only reason it wasn't 5 stars is because they stated they would go over certain concepts and then the video cuts off and moves onto another concept. The videos also sometimes had weird background noises or the instructor would repeat themselves 3-4 times before moving on. Overall helpful, just a couple small things that could have been fixed when editing.
Nikolaos
November 2, 2023
Certainly. A good opportunity to remember tricks and formulas in Excel. Clear explanation by the presenter.

Charts

Price

Microsoft Excel - Beginner to Advanced Crash Course. - Price chart

Rating

Microsoft Excel - Beginner to Advanced Crash Course. - Ratings chart

Enrollment distribution

Microsoft Excel - Beginner to Advanced Crash Course. - Distribution chart
5622220
udemy ID
10/22/2023
course created date
10/28/2023
course indexed date
Bot
course submited by