Tutorialspoint

This Black Friday, Get lowest Price Ever! Use: BFS8

Microsoft Excel - Beginners to Advanced Level

person icon Namita Devi

4.4

Microsoft Excel - Beginners to Advanced Level

Learn MS Excel from Beginners, Intermediates to Advanced Level

updated on icon Updated on Sep, 2024

language icon Language - English

person icon Namita Devi

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -22

Resources -3

Duration -3.5 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Excel is in high demand in most of the organizations. This is a robust tool for your Data Analysis and for carrying out day-to-day business. 

So, Let's Learn Excel with Fun!

You will find this course engaging and interesting. This course covers all the features of Excel that you need to know as a Beginner to Advanced level. I have also covered Important Formulas and Functions of the Excel category and you will also have challenging practice files with each chapter.

While covering the topic of each chapter, I have also shared tips and shortcuts to improve your productivity and efficiency in MS Excel.

I will also share with you PDF files of the "Top 10 Excel Tips and Tricks", "Top 45 Excel Functions" and "Excel Shortcut Keys" printable versions.

At the end of this course, you will be able to:

  • Input data and navigate through large spreadsheets

  • Excel Tips to get your work done faster

  • Able to choose the right Excel formula for data analysis

  • Use Excel features to transform your raw data into meaningful reports

  • Organize and manage data

  • Create interesting reports and impress everyone working with you

  • Excel Tables, Sorting, Filtering, Conditional Formatting, Pivot Tables, Data Validation, Excel protection and many more...

Enroll in this course now and let's learn Excel together. See you inside. :-)

Happy Learning!

Goals

  • Microsoft Excel Introduction, Complete Layout, Terminologies and Data Input.

  • Data Entry (Editing and Formatting).

  • Excel Cells, Ranges and Managing Worksheets.

  • Excel Tables with all its features

  • Excel Formula / Functions Basics.

  • Date and Time, Math, Logical, Lookup and Reference, Statistics and Text Formulas.

  • Data Sorting and Filtering.

  • Conditional Formatting (With very interesting features).

  • Pivot Tables (I call it Excel Superhero).

  • Excel Charts Basics (Data Visualization).

  • Data Validation Techniques.

  • Protect Your Excel (Workbook, worksheet, cells and Ranges).

  • Additional Content: Excel Shortcut Keys (To Improve Your Productivity).

  • FREE (PDF files): Excel Tips & Tricks, Top 45 Excel Functions, Top 50 Excel Shortcut Keys.

  • ALL the Chapters have MS Excel Practice Files.

Prerequisites

  • This course is demonstrated in Excel 2013, Students can use other versions also like 2010, 2016 and 2019.

Microsoft Excel - Beginners to Advanced Level

Curriculum

Check out the detailed breakdown of what’s inside the course

Microsoft Excel Basics
6 Lectures
  • play icon Welcome to the Course 01:17 01:17
  • play icon Introduction to Excel 12:49 12:49
  • play icon Data Entry (Editing and Formatting) 07:37 07:37
  • play icon Working with Excel Cells and Ranges 14:28 14:28
  • play icon Managing Worksheets 12:19 12:19
  • play icon Excel Tables 08:55 08:55
Excel Formulas and Functions
8 Lectures
Tutorialspoint
Excel Advanced Features
6 Lectures
Tutorialspoint
Additional Content - Just for You
2 Lectures
Tutorialspoint

Instructor Details

Namita Devi

Namita Devi

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515