Udemy 100% Discount Coupon Code | Udemy Free Course | Udemy Free Coupon Code

Excel - Microsoft Excel Beginner to Advanced [2021]

Excel Course: Microsoft Excel From Beginner to Advanced, Ms Excel Formulas, Chart Tips & Tricks in Excel 2019/Office 365


Description

In this special Microsoft Excel - Excel From Beginner to Advanced course you can learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016 versions.

If you're a beginner, in the first section you can learn Excel basics in 30 minutes.

Topics covered in the 30-min Getting Started With Excel lecture:

  • quick overview of the user interface

  • how to save your excel worksheet

  • drag & drop gesture

  • excel rows, columns, cells

  • how to move between cells quickly

  • excel data entry

  • excel data types

  • excel formulas & references

  • excel operators

  • how to select cells, ranges, columns, rows in excel

  • copy & paste data

  • AutoComplete feature

  • AutoFill feature

  • what is function

  • define Name

  • how to sort & filter your data in excel

  • how to create a simple chart with a few clicks

  • multiple worksheets

  • zoom function

Then we're going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience.

Projects covered:

  • highlight max value dynamically on an Excel chart

  • discover Excel's conditional formatting feature to highlight key data in your table

  • how to create a map chart that reads well by the viewer

  • how to use icons in your bar charts to make it exciting

  • how to create a progress chart in infographic style

I dedicated an entire section to Excel shortcut keys showing you over 100 Excel shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and more productive you can be.

Shortcuts covered in seven categories:

  • general shortcuts

  • shortcuts for navigation

  • shortcuts for data entry

  • Excel formatting shortcuts

  • selection shortcuts

  • shortcuts for formulas

  • miscellaneous shortcut keys

I created a section for the most frequently used Excel formulas/functions. You will find lots of real-world examples in these topics:

  • Relative vs Absolute cell references explained

  • working with date functions

  • SUM(), SUMIF(), SUMIFS() functions

  • MIN(), MAX(), AVERAGE(), COUNT() functions

  • VLOOKUP(), HLOOKUP() functions examples

  • INDEX(), MATCH(), XLOOKUP() functions to search data

In the last section we're getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to use it, but I'll make it simple for you. We're going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables. So, you'll be able to use Excel as a real database.

By taking this course you can really take your Excel skills to way above the average.

Don't worry if you're an absolute beginner. I'll explain everything step by step.

If you're already familiar with Excel, this course is a great refreshing session, and I'm pretty sure I will be able to show you new, interesting things.

Please watch the Intro video to see what you can expect from this course. Enjoy learning!

Collect out of below 3 offers !
Card image cap
Udemy 24-Hour Flash Sale

Udemy online courses start at $11.99

  • Limited period offer
  • New courses included
  • Courses from all categories eligible
OR
Card image cap
New Customer Offer

Top courses from $13.99 when you first visit Udemy.

  • Region: Global (Exclude: Japan).
  • Get skills that fulfill. Biggest sale of the season.
  • All courses eligible
OR
Get this course offer on Udemy
42 People Already Collected this Offer
Support our work with a coffee if you like the offer
Also, have a look at below Guaranteed Offer box and grab all. !
Join our Telegram Group and get instant coupon notifications. Click here to join !
Udemy Coupons Telegram Group

10000 + People are already collecting the coupons just within 1 minute of posting on groups !

Join the group now if you don't want to miss any coupon

Join above Telegram Channels to get daily alerts on new coupon codes