Mastering MS Excel® (Beginners/Intermediate)
4.0 (4 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.
140 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering MS Excel® (Beginners/Intermediate) to your Wishlist.

Add to Wishlist

Mastering MS Excel® (Beginners/Intermediate)

Learn MS Excel® in a Weekend
4.0 (4 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.
140 students enrolled
Created by Tech Nitya
Last updated 4/2014
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Description

If you need Excel skills to get a job – but you’ve never used Excel before, this course will get you up to quickly Learn Microsoft Excel.  Anybody can do it in three hours or less.

Just about some years back I was struggling with learning MS Excel myself. I could not even build simple Pivot Tables, lookup formulas, leave aside any analysis. After a lot of regular practice and hard work I now am an expert user.

I am now sharing this Excel Tutorial for Beginners that will make sure you do not have to go through all that hard work and pain.

Give it a try and let me know if this training helps you get a better job or a promotion.

Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 57 Lectures Collapse All 57 Lectures 02:57:18
+
Intro/Promo
2 Lectures 02:01
Intro/Promo
01:23

  • Agenda of this course
  • What will you learn and why?

Preview 00:38
+
Getting Started
3 Lectures 09:23
  • What is a spreadhsheet program
  • How is it different from MS Word
  • Brief example
What Is MS Excel
01:37

What is new in MS Excel 2007 and 2010 versions
Excel work area
Ribbon Menu and its basic features
How to access in-built help
Office Button
Excel Options menu
How to enable macros

Work area and menu
05:21

Most important shortcuts

  • Arrow keys
  • Home key
  • How to select Columns & Rows
  • Page up and page down keys
  • Navigate between worksheets

Where to learn more shortcuts?

Keyboard Shortcuts
02:25
+
Your first MS Excel file
4 Lectures 08:49

Create a new blank workbook
How to use MS Excel online templates

Create A New File
03:33

Cells, Rows, Columns
02:28

Enter Data
02:01

Saving Files
00:47
+
Working with Worksheets
7 Lectures 14:25
Add, Delete, Rename
02:31

Tab Colors
02:11

Split Windows & Freeze Panes
03:22

Hide And Unhide
01:12

Hide And Unhide Contd
00:45

Protect And Un Protect
02:01

Working With Shapes
02:23
+
Cell Formats and Options
14 Lectures 33:45
Height And Width Of Rows & Columns
02:18

Types Of Data
01:52

Align And Indent
01:44

Font Options
01:24

Font Options
01:24

Hyperlinks
01:47

Context Menu
01:17

Insert , Delete And Move Columns, Rows & Cells
03:52

Cut , Copy And Paste
04:34


Clipboard
01:51

Cell Borders
03:14

Merge Cells
02:31

Wrap Text
01:53
+
More on formatting
5 Lectures 25:36
Conditional Formatting
06:33

Data Validation
08:24

Naming Ranges
07:31

Special Characters
01:21

Format Painter
01:47
+
Formulas and Functions
4 Lectures 28:01
Relative and Absolute Cell references
08:08

Other sheet references
03:13

Excel functions
05:00

+
Dealing with data
4 Lectures 14:45
Importing Data in Excel
04:13

Text to Columns
01:44

Handling duplicate data
01:35

Sort and Filter Data
07:13
+
Finalizing the Workbook
5 Lectures 10:32
Check spellings
01:31

Cell comments
02:02

Hide Worksheets
01:23

Excel find and replace
02:52

Excel lock and unlock cells
02:44
+
Printing Your Workbook
5 Lectures 10:54
Print Ranges
01:52

Print Margins in Excel
03:01

Excel Shrink to fit
02:39

Headers and Footers
01:55

Page Breaks
01:27
2 More Sections
About the Instructor
Tech Nitya
4.4 Average rating
16 Reviews
432 Students
3 Courses
Software Training, Tutorials, Instructional Design

Founded by Amit Kumar, TechNitya.com is a London based professionally managed & committed training company.

TechNitya.com is proud of its team of high energy, passionate, and professional IT trainers/consultants drawn from drawn from both the world of academics as well as active industry practice with specialized knowledge in a variety of environments.

Amit Kumar, who is an MBA with more than 16 years of business management experience, is responsible for finding and recruiting experts around the globe in various domains and helping them turn their expertise into easy to follow and inexpensive courses/tutorials.

For further details…please feel free to contact us at the link below

http://technitya.com/contact