Mastering Microsoft Excel - Essential Training for all
4.3 (856 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.
44,934 students enrolled

Mastering Microsoft Excel - Essential Training for all

Learn all the tools and tricks you can use in day-to-day needs in your office or personal life using Microsoft Excel
4.3 (856 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.
44,934 students enrolled
Created by Navin Soneja
Last updated 5/2020
English
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
  • 3.5 hours on-demand video
  • 30 downloadable resources
  • 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
  • Full Excel Essentials required for everyday
  • Formatting, Header Footers, Print, Page Layouts
  • Basic Formulas, Sorting, Styles, Filters
  • Charts, Chart Styles, Chart Elements
  • Orientations, Alignements, Fill Handle, Borders
  • Navigations, Conditional Formatting, Data Entry
Requirements
  • No
Description

This course intends to help you in your understanding of using Microsoft Excel. After taking the course you will be confident to us the tool in your everyday life. The knowledge of Excel improves efficiency in the workplace you can gain mastery over crucial Microsoft Excel tools and functions that will enhance efficiency and accelerate performance.

You will learn all about formulas and functions in Microsoft Excel. You will learn how to manipulate both numbers and text. You will be able to create charts so you can share the information graphically to your clients and colleagues.

Who this course is for:
  • Anyone who wants to move ahead in life
Course content
Expand all 32 lectures 03:33:09
+ Excel Basics / Fundamentals
3 lectures 24:12
Relative and Absolute Cell References
08:34
Number Formats
07:09
Navigation and Selection
08:29
+ Microsoft Excel Basic Functions, Formulas and Calculations
4 lectures 25:59
Average, Min and Max Function
06:02
Sum Function
07:19
Basic Formulas in Microsoft Excel
05:43
Calculations Across Worksheets
06:55
+ Formatting in Microsoft Excel
3 lectures 14:14
Formatting
03:58
Format Painter and clear tools
04:19
Styles
05:57
+ Data Handling in Microsoft Excel
2 lectures 09:53
Data Entry in Microsoft Excel
05:30
Saving Options
04:23
+ Handling Printing, Layouts, Page Views, Print Preview, Margins, Page Breaks
4 lectures 23:09
Print Preview in Microsoft Excel
04:04
Page Breaks
09:15
Print Titles
05:25
Orientation margins and scale
04:25
+ Tools for Day to Day Work
3 lectures 25:44
Cut and Paste
12:51
Alignment Tools
05:16
Borders
07:37
+ Working with Charts in Microsoft Excel
4 lectures 28:30
Simple Charts
04:55
Moving Charts
06:23
Sharing Charts
09:15
Chart Style and Chart Elements in Microsoft Excel
07:57
+ Extending Data
3 lectures 21:13
Fill Handle
08:12
Conditional Formating
08:08