Microsoft Excel For Beginners
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled

Microsoft Excel For Beginners

Excel Basics and Advanced
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled
Published 4/2019
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Microsoft Excel For Beginners
Requirements
  • no
Description

We will begin with basics like how to create pivot tables,and how we can format pivot tables.Pivot Tables is one of the most important and interesting feature in microsoft excel .We will then move on to the advanced level in a gradual way.We will learn how to work with conditional formatting,pivot tables,pivot charts.

We will learn excel formulas and functions.

Who this course is for:
  • beginners
Course content
Expand all 28 lectures 47:32
+ Excel Pivot Tables
12 lectures 22:35
Pivot Table Design Options
02:38
Pivot Table Field Settings
02:42
Pivot Table Options
01:41
Pivot Table Slicer and Timeline Options
02:01
Sorting Data in Pivot Table
02:00
+ Conditional Formatting
3 lectures 04:56
Highlighting Cells
01:12
Top-Bottom Rules
01:36
Icon Sets
02:08
+ Functions
9 lectures 11:52
IF Function
01:28
AND Function
01:55
OR Function
01:53
LEFT Function
00:51
RIGHT Function
00:52
VLOOKUP
01:28
INDEX Function
01:05
MATCH Function
00:55
INDEX MATCH Function
01:25
+ PIVOT CHARTS
4 lectures 08:09
Formatting Pivot Chart
01:49
Format Chart Area
03:00
Change Colour and Switch Row
01:23
Secondary Axis and Move Chart Options
01:57