Udemy Certificate 0

Microsoft Excel - Ms Excel from Beginner to Advanced Course

About this course

In this special Microsoft Excel - Ms 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, 2019, 2021, 2022 versions.If you're a beginner, in the first section you can learn Excel basics from scratch in 30 minutes.Topics covered in the 30-min Getting Started With Excel lecture:quick overview of the user interfacehow to save your excel worksheetdrag & drop gestureexcel rows, columns, cellshow to move between cells quicklyexcel data entryexcel data typesexcel formulas & referencesexcel operatorshow to select cells, ranges, columns, rows in excelcopy & paste dataAutoComplete featureAutoFill featurewhat is functiondefine Namehow to sort & filter your data in excelhow to create a simple chart with a few clicksmultiple worksheetszoom functionThen 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 chartdiscover Excel's conditional formatting feature to highlight key data in your tablehow to create a map chart that reads well by the viewerhow to use icons in your bar charts to make it excitinghow to create a progress chart in infographic style

56/100

CourseAsk score

What the provider tells you: 32/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

understand the Excel interface
perform basic data entry and manipulation
create and customize charts
apply conditional formatting
use Excel functions and formulas

Data Analysis #data visualization #excel #data analysis #pivot tables #excel 365 #conditional formatting #charts #data entry #formulas #excel 2019

Discounted on Udemy

List price $99.99. Udemy runs frequent sales, so the checkout price is usually far lower. We do not receive the live sale price, so we do not guess it — open the course to see today's.

See today's price

You'll be redirected to Udemy to complete enrollment.