corporates.training@gmail.com
Follow us on

Excel Training in Mumbai Level – I

Basic Excel Course In Mumbai

Duration: 1 Day

Excel Course, Level 1 (Office 356, Office 2016, Office 2013, Office 2010)

The Excel Course Level 1 program 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
Executives and managers from various functions (such as Finance, Sales, HR, etc.) who need to work with lots of calculations and analyze data for their day-to-day operations.

This introductory Excel training course will provide you with a working understanding of the basic features of MS Excel as follows:

  1. Creating and editing worksheets.
  2. Formatting and printing of worksheets.
  3. Commands for managing data such as sorting, filters, subtotals, pivot tables.
  4. Working with charts.
  5. Working with in-built functions of Excel.
Basic Excel Training Module 1: Getting Started
  • Understanding the Excel 
  • Screen Navigating in a spread sheet
  • Understanding worksheets, columns, rows and cells Saving, opening, and closing workbooks 
Basic Excel Training Module 2: Creating Tables
  • Creating and Using of Tables Functions 
  • Conversion of Table – Range – Table 
  • Advantages of Using Tables Vs Range’s 
  • Defining Name 
  • Functions and usage of Name Manager
Basic Excel Training 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
Basic Excel Training Module 4:  Pivot Tables & Slicers
Basic Excel Training 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


    More Review
    Open chat