Advanced Excel Training

Learn how to use Microsoft Excel from scratch

Advanced Excel Training

Course Description

The Advanced Excel Training by Internshala is a 4-week online training program covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel. At the end of this training, students will make a sales plan for an insurance company 'ABC Pvt. Ltd.' using various input metrics and assumptions (rules). Input metrics will be in raw data form. Students will be required to group and link information available on the table, generate inferences, making it more meaningful, and adding visual elements with the help of pivot, formulas, and data visualization techniques. You will be also required to automate this tool i.e. addition and deletion of raw data or assumptions, which should have a direct impact on output, transforming it into a dynamic sy... Read More »

The Advanced Excel Training by Internshala is a 4-week online training program covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel. At the end of this training, students will make a sales plan for an insurance company ‘ABC Pvt. Ltd.’ using various input metrics and assumptions (rules). Input metrics will be in raw data form. Students will be required to group and link information available on the table, generate inferences, making it more meaningful, and adding visual elements with the help of pivot, formulas, and data visualization techniques. You will be also required to automate this tool i.e. addition and deletion of raw data or assumptions, which should have a direct impact on output, transforming it into a dynamic system. Students will be provided with data sets and assumptions to generate a sales plan.

For doubt clearing, you would get 1-hour live chat support with the trainer every day. You can also use the Q&A forum provided.

Read Less
Course Outcomes:
  • Upon successful completion of this course, you will have hands-on experience of Microsoft Excel.
Course Details:

Target Audience

This course is for college students, recent graduates and anyone who has interest in this skill.

Access Timeframe

4 Weeks

Prerequisites

There are no prerequisites for this course.
Certificate Info:

Type of Certification

Certificate of Completion

Format of Certification

Digital

Method of Obtaining Certification

Upon successful completion of a course, the learner will be able to download their certificate.

Course Outline

  • Introduction
  • Getting Started
  • Excel Formatting
  • Excel Operations
  • Sheet Operations
  • Formulas
  • Paste Special and Format
  • Challenge
  • Text Functions
  • Mathematical Functions
  • Error Handling and Logical
  • Statistical Functions
  • Date and Time Functions
  • Financial Functions
  • Look-Up Operations
  • Assignment 1
  • Assignment 2
  • Importance of Charts
  • Components
  • Types of Charts
  • Selection and Formatting
  • Sparkline
  • Advanced Charts
  • Project
  • Sorting and Filtering
  • Advanced Filter
  • Conditional Formatting
  • Pivot Table I
  • Pivot Table II
  • Pivot Table III
  • Hyperlinks
  • Tables
  • Validation
  • Protection and Print
  • Analysis Tools

DON'T HAVE TIME?

We can send you everything you need to know about this course through email.
We respect your privacy. Your information is safe and will never be shared.