Excel - A Step by Step Complete Course
3.5 (20 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,844 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel - A Step by Step Complete Course to your Wishlist.

Add to Wishlist

Excel - A Step by Step Complete Course

Learn Microsoft Excel 2016. Excel is the best tool for Data Analysis. Excel 2016 from Beginner to Advanced
3.5 (20 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,844 students enrolled
Created by TELCOMA !
Last updated 7/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master Microsoft Excel 2016
  • Get Accustomed with Excel dashboard, tabs and ribbons.
  • Learn Formatting Options
  • Create Charts & Add Graphics
  • Use the most commonly used Excel functions
  • Learn Pivot Tables
  • Create Data Lists
  • Master Linking, Automating & Sharing
  • Implement Macros
View Curriculum
Requirements
  • Microsoft Excel 2016 Trial or Full Version
Description

Microsoft Excel is the most popular and widely used spreadsheet software. 

Employee having a good knowledge of Excel is beneficial for any company. 

This course will build a solid understanding on the basics of Microsoft Excel. It will cover all important topics of Microsoft Excel 2016 from Beginner to Advanced in a Step by Step approach.

Topics include Working with the Excel interface, Entering data, Creating formulas and functions, Formatting rows, columns, cells, and data, Creating charts and PivotTables, Inserting and deleting sheets and Creating and running macros

Lifetime access to this Excel class allows you to easily continue learning new version, whenever they are launched.

Join in, As for learning Excel 2016, this course is the authority and equally important you will even get a certification of completion that validates your skills.

Who is the target audience?
  • Anyone who wants to learn Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
53 Lectures
05:46:42
+
The Excel 2016 Introduction
3 Lectures 18:53

Tabs of Ribbon
06:45

Ribbon User Interface
09:11
+
The Excel 2016 - User Experience
13 Lectures 01:32:42
Entering Data
09:08

Customising Quick Access Toolbox
09:29

Surfing Work Area
09:39

Formula Bar
07:15

Keyboard Keys
06:02

Entering Date Time
04:45

Fabricating Formulas
08:15

Formula Flub-ups
10:36

Autofill
06:53

Inserting Functions
03:56

Autofill and Flash
07:02

Finding Totals
05:27

Saving Excel File
04:15
+
To Make it all Look Pretty
7 Lectures 47:54

Format as Table
06:50

Custom-able Style & Cell Formatting
08:56

Number Formats
09:28

Rows and Columns
06:17

Fonts and Alignment
04:25

Formatting via Quick Analysis Tool
04:24
+
Going Through Changes
7 Lectures 46:56

Drag, Drop & Copying
07:04

Find Workbook Files
04:07

Cut & Paste
07:13

Paste from Clipboard Task Pane
06:50

Deleting & Inserting Stuff
08:01

Spelling Errors
04:35
+
Printing the Sheets
3 Lectures 17:37
Preview Pages & Print Screen
05:32

Page Set Up
05:44

Header and Footer
06:21
+
Maintaining the Worksheet
5 Lectures 31:42
Page Breakup Problems
04:34

Zooming In and Out
09:16

Managing Comments
04:13

Range Name
08:55

Controlling Recalculation and Protection
04:44
+
Maintaining Multiple Works
3 Lectures 15:40

Opening Windows
03:20

Shifting Sheets
07:14
+
What-If Analysis
2 Lectures 13:46
Goal Seek and Scenarios
09:00

One & Two Variable Data Table
04:46
+
Charts & Graphics
2 Lectures 18:28
Charts
08:27

Adding Graphics
10:01
+
Pivot Tables
1 Lecture 05:51
Pivot Tables
05:51
2 More Sections
About the Instructor
TELCOMA !
3.8 Average rating
797 Reviews
23,063 Students
16 Courses
Fanatical Services to the IT Industry Since 2007

TELCOMA (An ISO 9001:2008 Certified Company) is a provider of IT and Telecommunication based solutions, including Network Solutions, System Integration services, Software Solutions, Consultancy and Education.

TELCOMA has been providing fanatical services to the IT industry and our clients Since 2007

TELCOMA offers industry recognized trainings and global certifications with best in class course content delivered by the certified expert trainers. Earning your  Certification gives you a well-respected Expert credential that validates your expertise and enhances your professional credibility.

With TELCOMA certification, you hold the power to move ahead in your career, increase your earning potential and add value to any organization.