Mastering MS Excel® (Beginners/Intermediate)

Learn MS Excel® in a Weekend
  • Lectures 57
  • Video 3 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course 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.

What am I going to get from this course?

  • Over 57 lectures and 3 hours of content!

What you get with this course?

Not for you? No problem.
30 day money back guarantee

Forever yours.
Lifetime access

Learn on the go.
Desktop, iOS and Android

Get rewarded.
Certificate of completion

Curriculum

Intro/Promo
01:23
00:38
  • Agenda of this course
  • What will you learn and why?

Section 1: Getting Started
01:37
  • What is a spreadhsheet program
  • How is it different from MS Word
  • Brief example
05:21

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

02:25

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?

Section 2: Your first MS Excel file
03:33

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

Cells, Rows, Columns
02:28
Enter Data
02:01
Saving Files
00:47
Section 3: Working with Worksheets
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
Section 4: Cell Formats and Options
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
Paste Special
Preview
04:04
Clipboard
01:51
Cell Borders
03:14
Merge Cells
02:31
Wrap Text
01:53
Section 5: More on formatting
Conditional Formatting
06:33
Data Validation
08:24
Naming Ranges
07:31
Special Characters
01:21
Format Painter
01:47
Section 6: Formulas and Functions
Relative and Absolute Cell references
08:08
Other sheet references
03:13
Excel functions
05:00
Excel functions example
Preview
11:40
Section 7: Dealing with data
Importing Data in Excel
04:13
Text to Columns
01:44
Handling duplicate data
01:35
Sort and Filter Data
07:13
Section 8: Finalizing the Workbook
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
Section 9: Printing Your Workbook
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
Section 10: Charts and Labels
Excel Charts
07:12
Section 11: Pivot Tables
Build
07:13
Excel Pivot Options
02:44
Pivot Charts
01:58

Instructor Biography

Tech Nitya , 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

Join the biggest student community

6,400,000

Hours of video content

29,000,000

Course Enrollments

7,900,000

Students

Reviews

Average Rating
4.0
Details
  1. 5 Stars
    2
  2. 4 Stars
    0
  3. 3 Stars
    2
  4. 2 Stars
    0
  5. 1 Stars
    0
    • Essohgnas@gmail.com

    nice course

    this is the best course ever.i like it

    • Abhishek Prakash

    Excellent Course for working professionala

    Excellent Course both for amateurs who want to learn Excel Skills and for professional who want to impress everyone with their Advanced Excel skills

Ready to start learning?
Preview this course