Module 1: Getting Started

~ Understanding the Excel screen
~ Navigating in a spreadsheet
~ Understanding worksheets, columns, rows and cells
~ Saving, opening, and closing workbooks

Module 2: Formatting a Spreadsheet

~ Changing column widths and row heights
~ Changing alignment of cells
~ Undoing and redoing actions
~ Formatting numbers
~ Clearing formats
~ Applying borders to cells
~ Merging cells

Module 3: Formulas and Functions

~ Entering formulas
~ Copying data and formulas
~ Using AutoSum
~ Understanding functions
~ Using simple aggregate functions (Sum, Count, Average, Min, Max)
~ Copying formulas
~ Applying conditions in a formula (The IF function)
~ Working with ranges

Module 4: Editing Features

~ Using cut , copy, and paste operations
~ Using paste special with values
~ Selection techniques
~ Navigation techniques

Module 5: Working with Large Worksheets

~ Freezing and unfreezing panes
~ Splitting windows
~ Inserting page breaks for printing

Module 6: Working with Charts

~ Creating charts using Chart Wizard
~ Creating different types of charts
~ Including titles and values in charts
~ Formatting of charts

Module 7: Previewing and Printing

~ Previewing worksheets
~ Page setup
~ Printing of worksheets in multiple pages
~ Repeating rows and columns for multiple pages
~ Printing multiple worksheets

Module 8: Simple Database Operations

~ Sorting tables
~ Filtering data with auto filter
~ Referring data from other worksheets

This Course Include:

Call Now To Schedule an Enquiry / To Know the Fees

Basic Microsoft Excel Course

Ms Excel Course in Mumbai

Microsoft Excel Course introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.

Start mastering Excel, the world-renowned powerful spreadsheet program. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more.

Call Now

A Brief on Ms Excel Course Details

Excel courses offer skills that are available at a high level of proficiency with the software program- the Microsoft Excel spreadsheet. Advanced Excel course offers users and experts the lesser-known capabilities like pivot tables, lookup tables, pivot charts, and data validation and debugging features to ensure accuracy.

Advanced Excel Course educates students on the functions, types of financial analysis, and the advanced formulas required to function as an Excel power user. This course program builds skill enhancement, specifically for spreadsheet users, to strengthen their fundamentals in Excel to an advanced level.

Advanced Excel courses are available as certification and Face-to-face practical courses with the flexibility of time to attend the sessions.

MS Excel Course Details Overview

Advanced Excel course allows the students to access face-to-ace practical classes. Each class is of 1-2 hours and is spread over 2 months.

The course offers weekly assignments, and study material in PDF format for students to refer to and study.

The course program holds module-wise case studies or projects for interested students.

After completing the course, students will be given a certificate of completion of advanced excel course which will help them in their future.