ADVANCE EXCEL

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications

What is Excel?

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.

By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns. Data is placed in these cells.

Excel is a part of the Microsoft Office and Office 365 suites and is compatible with other applications in the Office suite. The spreadsheet software is available for Windows, macOS, Android and iOS platforms.

Microsoft Excel Syllabus :-

Learning Outcomes

  • Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
  • Create, open and view a workbook.
  • Save and print workbooks.
  • Enter and edit data.
  • Modify a worksheet and workbook.
  • Work with cell references.
  • Learn to use functions and formulas.
  • Create and edit charts and graphics.
  • Filter and sort table data.
  • Work with pivot tables and charts.
  • Import and export data.

Outline

  • Excel Basics
  • Work with Cells and Worksheets
  • Calculate Your Data
  • Format your Workbook
  • Add Charts and Graphics
  • Collaborate with Others
  • Analyze your Data
  • Work with Macros and the Web