Advance 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,

Topics Covered

  1. Tour of excel
  2. Saving files in excel and in different formats
  3. Opening files
  4. Managing worksheet, moving data, Adding information to worksheet
  5. Formatting cells
  6. Viewing and printing worksheet
  7. Inserting a simple formula
  8. Math and statistical functions
  9. Inserting an excel function
  10. Cell references, range names, sorting data, querying data
  11. Using the auto filter
  12. Importing data from text files
  13. The basic of tables
  14. Sorting and filtering a table
  15. Dealing with duplicate rows
  16. Performing table calculations
  17. Basic tasks with charts [moving, creating, editing, changing]
  18. Practical charting
  19. Chart types [column,Bar,Line,Pie,Area,Stock,xy scatter]
  20. Identifying data points [Selecting data row, Labeling, Data points, Formatting labels]
Reserve Seat for Upcoming Batches or Demo Classes.