Advanced Excel Training Course Online Course

Advanced Excel Training Course

All levels
English

Course Description

Microsoft Excel Training at BIT aims to impart basic skills in using Excel to its best. Participants will learn to use statistical, math, and logical functions, organize data using filter and sort and effectively present data for quick decision-making using charts and graphs. Participants will also gain some advanced skills in Excel, such as using VLOOKUP, PivotTables, and Macros among others.Microsoft Excel is a very popular software program included in the Microsoft Office suite and used to create spreadsheets documents which is laid out in rows and columns as a big table. Excel has become one of the most used software programs in the business world due to its supreme versatility and power. Excel is an extraordinarily powerful tool used frequently in the business world to store, manipulate, and measure complex sets of data.

See more less

What you’ll learn

Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
Build a solid understanding on the basics of Microsoft Excel. Writing formulas and performing calculations
SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functions. Inserting headers and footers, and adjusting margins
Color code data that meet certain criteria with Conditional Formatting. Save time applying formatting to other cells wit...
Create different variations of charts and graphs that can be used to represent real life scenarios. Manipulate data to g...
Analyze & sort/filter data to create powerful & captivating pivot tables. Implement formulas, functions & calculations t...

Covering Topics

Lecture 1: Introduction to Spreadsheets

Lecture 2: Formulas & Functions

Lecture 3: Charts

Lecture 4: Formatting

Lecture 5: Pivot Tables

Lecture 6: Data Tables

Lecture 7: Excel Functions

Lecture 8: Statistical Functions

Lecture 9: Managing Multiple Worksheets

Lecture 10: Importing Data From External Sources

Lecture 11: Templates, Themes, And Styles

Curriculum

  Lecture 1: Introduction to Spreadsheets

·      Introduction To Spreadsheets

·      Creating Formulas, Auto Fill

·      Formatting

·    Practical Exercise

  Lecture 2: Formulas & Functions

·      Basic Formulas

·      Inserting Basic Math & Statistics Functions

·      Using Date Functions

·      Logical Functions - IF Function

·      Lookup Function-Vlookup() & Hlookup()

·      Financial Functions

·      Range Names

·      Practical Exercise

  Lecture 3: Charts

·      Chart Creation Basics

·      Chart Elements

·      Chart Design And Sparklines

·      Practical Exercise

  Lecture 4: Formatting

·      Large Datasets- Freezing & Printing

·      Excel Table With Manipulation And Aggregation

·      Conditional Formatting

·      Practical Exercise

  Lecture 5: Pivot Tables
 
·      Subtotals And Outlines

·      Pivot table With Options

·      Pivot table Design And Pivot charts

·      Practical Exercise

  Lecture 6: Data Tables

·      One- And Two-Variable Data Tables

·      Goal Seek And Scenario Manager

·      Solver

·      Practical Exercise

  Lecture 7: Excel Functions

·      Nested Logical Function

·      Match And Index Lookup Functions

·      Advance Filtering

·      Database Functions

·      Financial Functions

·      Practical Exercise

  Lecture 8: Statistical Functions

·      Using Conditional Math & Statistical Functions

·      Calculating Relative Standing With Statistical Functions

·      Descriptive Statistical Functions

·      Practical Exercise

  Lecture 9: Managing Multiple Worksheets
 
·      Multiple Worksheets

·      Inserting A 3-D Formula

·      Linking Workbooks

·      Formula Auditing

·      Data Validation

·      Practical Exercise

  Lecture 10: Importing Data From External Sources

·      Text Manipulation Functions

·      Flash Fill

·      Customizing Excel & Changing Properties

·      Sharing And Merging Workbooks

·      Inserting Comments & Tracking Changes

·      Practical Exercise

  Lecture 11: Templates, Themes, And Styles
 
·      Templates, Themes, And Styles

·      Creating And Using A Template

·      Protection-Protecting A Cell, Worksheet,& Workbook

·      Macro In Excel

·      Creating A Sub Procedure & Custom Function

·      Practical Exercise

Frequently Asked Questions

Basic Computer Knowledge.

The course offers a variety of online training options, including: Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.

Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.

If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.

The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.