Excel

What is Excel?

Microsoft Excel is a spreadsheet developed by Microsoft. Microsoft Excel has the basic features of all spreadsheets, It features calculation and graphing tools using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.

We will provide the training on following topics,

Getting start with excel

  1. 1. Tour of excel
  2. 2. Saving files in excel and in different formats
  3. 3. Opening files
  4. 4. Managing worksheet, moving data, Adding information to worksheet
  5. 5. Formatting cells
  6. 6. Viewing and printing worksheet

Building basic formulas & functions

  1. 1. Inserting a simple formula
  2. 2. Math and statistical functions
  3. 3. Inserting an excel function
  4. 4. Cell references, range names, sorting data, querying data
  5. 5. Using the auto filter
  6. 6. Importing data from text files

Tables for organizing worksheet

  1. 1. The basic of tables
  2. 2. Sorting and filtering a table
  3. 3. Dealing with duplicate rows
  4. 4. Performing table calculations

Charts and graphics

  1. 1. Basic tasks with charts [moving, creating, editing, changing]
  2. 2. Practical charting
  3. 3. Chart types [column,Bar,Line,Pie,Area,Stock,xy scatter]
  4. 4. Identifying data points [Selecting data row, Labeling, Data points, Formatting labels]
Reserve Seat for Upcoming Batches or Demo Classes.