Mastering MS Excel® (Beginners/Intermediate)

Learn MS Excel® in a Weekend
4 reviews
TAUGHT BY
  • 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

WHAT'S INSIDE
  • Lifetime access to 57 lectures
  • 2+ hours of high quality content
  • A community of 100+ students learning together!
SHARE

Mastering MS Excel® (Beginners/Intermediate)

Learn MS Excel® in a Weekend
4 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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.

    • Over 57 lectures and 3 hours of content!

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

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

  • SECTION 1:
    Getting Started
  • 3
    What Is MS Excel
    01:37
    • What is a spreadhsheet program
    • How is it different from MS Word
    • Brief example
  • 4
    Work area and menu
    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

  • 5
    Keyboard Shortcuts
    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
  • 6
    Create A New File
    03:33

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

  • 7
    Cells, Rows, Columns
    02:28
  • 8
    Enter Data
    02:01
  • 9
    Saving Files
    00:47
  • SECTION 3:
    Working with Worksheets
  • 10
    Add, Delete, Rename
    02:31
  • 11
    Tab Colors
    02:11
  • 12
    Split Windows & Freeze Panes
    03:22
  • 13
    Hide And Unhide
    01:12
  • 14
    Hide And Unhide Contd
    00:45
  • 15
    Protect And Un Protect
    02:01
  • 16
    Working With Shapes
    02:23
  • SECTION 4:
    Cell Formats and Options
  • 17
    Height And Width Of Rows & Columns
    02:18
  • 18
    Types Of Data
    01:52
  • 19
    Align And Indent
    01:44
  • 20
    Font Options
    01:24
  • 21
    Font Options
    01:24
  • 22
    Hyperlinks
    01:47
  • 23
    Context Menu
    01:17
  • 24
    Insert , Delete And Move Columns, Rows & Cells
    03:52
  • 25
    Cut , Copy And Paste
    04:34
  • 26
    Paste Special
    04:04
  • 27
    Clipboard
    01:51
  • 28
    Cell Borders
    03:14
  • 29
    Merge Cells
    02:31
  • 30
    Wrap Text
    01:53
  • SECTION 5:
    More on formatting
  • 31
    Conditional Formatting
    06:33
  • 32
    Data Validation
    08:24
  • 33
    Naming Ranges
    07:31
  • 34
    Special Characters
    01:21
  • 35
    Format Painter
    01:47
  • SECTION 6:
    Formulas and Functions
  • 36
    Relative and Absolute Cell references
    08:08
  • 37
    Other sheet references
    03:13
  • 38
    Excel functions
    05:00
  • 39
    Excel functions example
    11:40
  • SECTION 7:
    Dealing with data
  • 40
    Importing Data in Excel
    04:13
  • 41
    Text to Columns
    01:44
  • 42
    Handling duplicate data
    01:35
  • 43
    Sort and Filter Data
    07:13
  • SECTION 8:
    Finalizing the Workbook
  • 44
    Check spellings
    01:31
  • 45
    Cell comments
    02:02
  • 46
    Hide Worksheets
    01:23
  • 47
    Excel find and replace
    02:52
  • 48
    Excel lock and unlock cells
    02:44
  • SECTION 9:
    Printing Your Workbook
  • 49
    Print Ranges
    01:52
  • 50
    Print Margins in Excel
    03:01
  • 51
    Excel Shrink to fit
    02:39
  • 52
    Headers and Footers
    01:55
  • 53
    Page Breaks
    01:27
  • SECTION 10:
    Charts and Labels
  • 54
    Excel Charts
    07:12
  • SECTION 11:
    Pivot Tables
  • 55
    Build
    07:13
  • 56
    Excel Pivot Options
    02:44
  • 57
    Pivot Charts
    01:58

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,700,000
Students

RATING

  • 2
  • 0
  • 2
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
4

REVIEWS

  • 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

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: