Intermediate Excel Course In Mumbai
Duration: 2 Days
Microsoft Excel, Level 2 (Office 356, Office 2016, Office 2013, Office 2010)
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.
Audience
This program is directed for New user’s, who have hardly used Excel Previously.
We start right from the basics, and gradually introduce them to VLOOKUP & Pivot Tables
Prerequisites
Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.
This Advanced Excel Course will empower the participants to be able to do the following:
- Performing complex calculations more efficiently, using various Excel functions.
- Organizing and analyzing large volumes of data.
- Creating MIS reports.
- Designing and using templates.
- Consolidating and managing data from multiple workbooks.
Intermediate Excel Course Module 1: Introduction to Excel
- Understanding the Excel
- Screen Navigating in a spreadsheet
- Understanding worksheets, columns, rows and cells Saving, opening, and closing workbooks
Intermediate Excel Course Module 2: Creating Tables
- Creating and Using of Tables Functions
- Conversion of Table – Range – Table
- Advantages of Using Tables Vs Ranges
- Defining Name
- Functions and usage of Name Manager
Intermediate Excel Course Module 3: Date & Time Functions
- Formulas for calculating Date and time
- Conversion of non-date format to proper date format
Description:
- Suppose your Excel format is dd/mm/yy and you receive a date in the order of mm/dd/yy .
- Your system will interpret the dates incorrectly
Intermediate Excel Course Module 4: Pivot Tables & Slicers
Intermediate Excel Course Module 5: Working with Excel Inbuilt Features
- Creating Hyperlink
- Functionality of Edit Links
- Text To Columns
- Outline Function & Grouping columns
- Functions of Data Analysis tools
- Copy / Paste Values