Microsoft Excel Training-Learn By Doing Approach.
4.4 (46 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.
5,034 students enrolled

Microsoft Excel Training-Learn By Doing Approach.

Interactive course on Microsoft Excel for all levels [Regular Updates].
4.4 (46 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.
5,034 students enrolled
Created by FARHAD HAQUE
Last updated 5/2018
English
English [Auto-generated]
Current price: $11.99 Original price: $119.99 Discount: 90% off
4 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 8 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • The only learn by doing excel course.
  • Very specific-No overloaded information.

  • Study-skills support.

  • Knowledge and application of Excel Menu System.
  • Working with formula.
  • Most common excel functions.
  • Formatting options.
  • Adjusting worksheet layout.
  • Printing guidelines from excel.
  • Working with charts.
  • Worksheet views.
  • Multiform workbook.
  • "IF" function.
  • Vlookup.
  • Security and protection.
  • Sharing options.
  • Data Management.
  • Data Analysis.
  • Pivot tables.
  • Macros.
  • Exercise files.
  • Shortcut command in Mac and Windows.
Requirements
  • Software: Microsoft Excel.
  • Internet Access.
  • Eagerness and ability to learn a new skill.
Description

Microsoft excel is the mostly used spreadsheet package that can turn your data into insights. This is the  learn by doing excel course that will help you to gain the skills in an interactive way. In this course everything is organised in such a way that will make your learning process effective and enjoyable without consuming overloaded information. You will get all the relevant exercise files and downloadable resources in the bonus section of this course that will help you to practice like a pro. Under the proper guidance and training methodology students will be able to learn the following core skills of Microsoft excel:

  • In-depth understanding of excel menu system and ribbon.
  • Working with formula.
  • Mostly used excel functions in our day to day life.
  • How to format properly.
  • Adjusting worksheet layout properly.
  • How to print from large data sources.
  • How to create charts with in a single click.
  • Know how the "worksheet view" works.
  • How to create multiform workbook.
  • Working with "If" functions.
  • Vlookup function.
  • How to implement security and proper protection on your excel workbook and worksheet.
  • How to share the workbook with multiple users.
  • Proper ways of managing data.
  • Proper ways of managing data analysis.
  • How to create pivot table.
  • How use macros in excel.

Learn from an excel pro with 6 years of experience in training on Microsoft excel. So lets get started!

Who this course is for:
  • Beginner to advanced level learner who wants to enhance the skills of this software.
Course content
Expand all 77 lectures 02:26:33
+ Getting Started With Excel.
9 lectures 17:50
Quick Access Toolbar.
02:57
Workbook and Worksheet.
03:40
Status Bar.
02:18
Shortcut Menus and Mini Toolbar.
00:57
New Workbook.
01:43
Save and Save As
01:31
+ Working With Formula.
6 lectures 14:19
Formula Bar.
01:22
Creating Simple Formula.
05:21
Copying A Formula.
02:03
Calculating Year To Date Total.
01:26
Percentage Change.
02:56
Working With Functions under Formula.
01:11
+ Formatting
11 lectures 23:40
Fonts
01:18
Row Height and Column Width.
02:16
Font colour and toggle button.
01:29
Alignment and Text Wrapping.
02:57
Borders.
01:20
Numeric and Special Formatting.
03:16
Formatting dates and time.
03:10
Conditional Formatting.
03:14
Inserting Table.
01:24
Shapes and Visual Effects.
02:04
Smart Art.
01:12
+ Adjusting Worksheet Layout.
4 lectures 05:58
Inserting Rows and Columns.
01:20
Shifting Rows and Columns.
01:56
Hiding and Unhiding Rows and Columns.
01:45
+ Printing.
3 lectures 04:46
Print Preview.
01:28
Page Layout.
02:32
Final Print.
00:46
+ Charts.
5 lectures 06:51
Creating Charts.
01:22
Changing Chart Types.
01:10
Formatting Chart.
01:03
Chart Design.
01:39
Creating Spark lines.
01:37
+ Worksheet Views.
2 lectures 03:58
Freezing and Unfreezing Panes.
01:54
Splitting Rows and Columns Horizontally and Vertically.
02:04
+ Multiform Workbook and Worksheets.
3 lectures 04:16
Renaming Worksheet.
01:00
Inserting and Deleting Worksheet.
01:52
Moving and Copying Worksheet.
01:24