YoVDO

Microsoft Excel - Improve your skills quickly

Offered By: Udemy

Tags

Microsoft Excel Courses VLOOKUP Courses PivotTables Courses Sparklines Courses PivotCharts Courses

Course Description

Overview

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours

What you'll learn:
  • Create Tables, PivotTables, PivotCharts and Sparklines
  • Add Conditional Formatting, Filters - and even use a bit of Visual Basic for Applications
  • Use SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT functions
  • Find out what you need to know about Excel to continue your learning.

Welcome to this course about Microsoft Excel. You can use any version of Excel in this course, whether it is Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, Itake my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting - they can improve the presentation of your spreadsheets with just a few clicks.

  • Create tables, PivotTables, Chart, PivotCharts and Sparklines - create analyses very quickly.

  • Find out how powerful Visual Basic for Applications (VBA) is - automate your code.

  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

There are also a couple of Practice Activities, so that you can do these exercises and see how much you have learned.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Afterwards, we'll investigate what you should know about Excel, having a look at the official Microsoft exams for a guide.


Taught by

Phillip Burton

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Analyze Data with Microsoft Excel
Codecademy
Conditional Formatting, Tables and Charts in Microsoft Excel
Coursera Project Network via Coursera
Data for Business Analysts Using Microsoft Excel
Microsoft via Coursera
Create Charts and Dashboards Using Microsoft Excel
Coursera Project Network via Coursera