Tutorialspoint

Learn Microsoft Excel: Beginner to Advanced

person icon Digital Niks

Learn Microsoft Excel: Beginner to Advanced

Complete Excel Course for the beginners

updated on icon Updated on Oct, 2023

language icon Language - English

person icon Digital Niks

architecture icon Office Productivity,Microsoft

Lectures -10

Duration -4 hours

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Whether you’re a student, a job-hunter, or a newly joined corporate employee, this course will be wide open and useful for everyone. Keeping in mind to encourage simplicity, we’ve followed a chronology of the chapters. We'll cover all the important tools and features of Excel that you'll need in your institution.  Every session will be supported by the same demonstrated excel sheet for your practice. I'm fairly sure if you keep up with the recommendations, you’ll have all the required methods at your disposal by the end of the course.

As this course is designed for beginners, we’ll start from scratch. This will include basic commands, arithmetic and functions, arrangements & syncs, and many more. By the end of 3 sessions, you’ll surely be able to navigate and work with the data. Of course! not without the required practice from your side.

As we pass the basics, We’ll play with live data, calculations, impressive dashboards, and presentations, that you never knew is possible with Excel. Excel hosts a wide range of applications, so we may not touch base upon everything but the most used functions for the standard use.

After you learn, how to set and use the worksheet, we’ll summarize with a huge data set, followed by the live tasks. As you’ll receive the editable worksheets for each session, you’ll need to step up and make sure assignments are completed on time.

Excel is a primary requirement in any organization at any level. Understanding its build and features saves a billion years of time. Okay! jokes apart, this course will help you in understanding the most used features like VLOOKUP's, pivot, and conditional formatting without breaking a sweat. You'll also learn a few tricks that I've gained over an experience of 8 years of using Excel. Cutting the long story short, it has everything you need to know before you join your first organization or for your business.

All the videos are supported by their corresponding spreadsheets and they'll be provided to you for your practice. All the best!!

Who this course is for:

  • The course is for beginners who want to learn MS Excel from the scratch. The course is put together in a very simple and slow-paced technique so that it can be learned the best way possible.

Goals

What will you learn in this course:

  • Create and manage data in a spreadsheet
  • Work with important functions like pivot, VLOOKUP & conditional formatting
  • Create insights and presentations with the use of data
  • Integrate MS-Excel features with other office apps

Prerequisites

What are the prerequisites for this course?

  • No prior experience is needed. The course is for absolute beginners
  • Internet and an audio/visual device are more than enough. (preferably Laptop)
Learn Microsoft Excel: Beginner to Advanced

Curriculum

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

Introduction
3 Lectures
  • play icon Introduction 22:51 22:51
  • play icon Understanding Data 30:33 30:33
  • play icon Grouping 30:45 30:45
Let's Dig a lil' deeper
7 Lectures
Tutorialspoint

Instructor Details

Digital Niks

Digital Niks

Hi, this is Nikhil!


I'm a marketing professional who has graduated from IMI. I work for CR Asset Management and has experience with HDFC and UTI in the past. I've extensive practice in MS Excel, content design, SEO, website designing and social media marketing.

My aim in life is simple. I believe in sharing and growing. Thanks for spending your precious time reading my bio. Hope it meets the expectations..

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

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
People having fun around a laptop

Online Certifications

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

Explore Now
People having fun around a laptop

Talk to us

1800-202-0515