Microsoft Excel is one of the greatest, most powerful, most important software applications of all time. It provides enormous capacity to do quantitative analysis, letting you do anything from statistical analysis of databases with hundreds of thousands of records to complex estimation tools with user-friendly front ends.

MS Excel is everywhere you look in the business world especially in areas where people are adding up numbers a lot, like marketing, business development, sales, and, of course finance. Weather it is about extracting data from back-end systems and shoving it around in Excel spreadsheets, r compiling data from the field, it is there everywhere.

Ask any working professionals, person unaware of excel is just treated as Second Grade Citizen, In-spite of having all the experience you have gathered in the decades or the degrees you have earned over the years or of the matter of the fact all the awards lying in your showcase, all are worth less if you do not know speedy work on your workstation.

Reporting is the new dragon of the corporate world, no matter in which position you work, you have to report, may be to your boss, or to your stake holders, or to your clients, but have to report. No one allows you to sleep without reporting.

  • Speedy data analysis
  • Better Understanding of MIS
  • Time Saving in Office Work
  • Reaching deep into data and seeing the unseen truth of your business.
  • Learn to Create Smart Solution for your daily office work

MS Excel Training Program: MOD I – The Excel Beginner

  • MS Excel Training Course - Lesson 1: The Basics
    • Navigating in Excel, Moving the Cell Pointer
    • Using Excel Menus
    • Previewing and Printing a Worksheet
    • Getting Help from the Office Assistant
  • MS Excel Training Course - Lesson 2: Formatting a Worksheet
    • Creating Headers, Footers, and Page Numbers, Adjusting Page Margins and Orientation
    • Adding Print Titles and Gridlines, rows to repeat at top of each page
    • Formatting Fonts & Values, Adjusting Row Height and Column Width
    • Cell formatting: Applying Colours and Patterns, Using Format Painter, Using AutoFormat,
    • Merging Cells, Rotating Text, and using AutoFit
  • MS Excel Training Course - Lesson 3: Managing your workbooks
    • Switching Between Sheets in a Workbook
    • Inserting, Deleting, Renaming and Moving Worksheets
    • Protecting a Workbook, Hiding Columns, Rows and Sheets
    • Splitting and Freezing a Window, Inserting Page Breaks
  • MS Excel Training Course - Lesson 4: Formulas
    • Creating a basic Formula
    • Calculating Value Totals with AutoSum
    • Editing & Copying Formulas
    • Fixing Errors in Your Formulas
    • Formulas with Several Operators and Cell Ranges
  • MS Excel Training Course - Lesson 5: Working with the Forms Menu
    • Sorting, Subtotalling & Filtering Data
    • Copy & Paste Filtered Records
    • Using Data Validation
  • MS Excel Training Course - Lesson 6: Creating & Working with Charts
    • Creating, Moving and Resizing a Chart
    • Changing a Chart's Source Data, Type, Adding Titles, Gridlines, and a Data Table
    • Formatting a Data Series and Chart Axis
    • Annotating a Chart, Working with 3-D Charts
    • Selecting and Saving a Custom Chart
    • Using Fill Effects, Mapping Data

Other Related Excel Training Programs 

Advanced MS Excel Training MS Excel VBA Macro Training

 

2 Days of Training
6 Hours of Training Daily
English


Warning
The download files does not exist


Name (required)

Email (required)

Contact (required)

Subject

Your Message

Insert Code
captcha


Online Registration

Log In

The program was really very interactive

Vikas Narian
Bhavani NIketan Engineering College Jaipur

Categories