Microsoft Excel is a spreadsheet application that is commonly used for a variety of uses. At its core, Excel is a table consisting of rows and columns. Excel is composed of rows and columns and uses a spreadsheet to display data. Features include: calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
OBJECTIVE
The purpose of this course is to provide advance Microsoft Excel tools and functions which are most useful to improve daily operational efficiency. This course will give you enough understanding on MS Excel from where you can take yourself to higher levels of expertise.
COURSE OUTLINE
MS EXCEL
Overview of Excel
Cells, Rows & Columns
Navigation & Formatting
Advance Conditional Formatting
Sorting & Filters
Advance Functions and Formula
PivotTable
Goal Seek
charts & Graph
Collaborating
Project
COURSE OUTCOME
Be able to create business documents, reports having various graphics including pictures, charts, and diagrams.
Be able to design different documents such as Letterheads, Resumes or Invitation Cards etc.
Able to Work with Spreadsheet and data.
Be able to Create a presentation and a poster.
WHO CAN JOIN
Every Student, Teacher, Professor, Employee, as Microsoft Office is the most important and basic computer skills.
PREREQUISITES
Before you begin with this course, we assume you have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen, etc. and their basic operations.