Course in Microsoft EXCEL - Basic
Course
In Pune
Description
-
Type
Course
-
Location
Pune
-
Duration
1 Day
Facilities
Location
Start date
Start date
Reviews
Course programme
The Introductory course teaches professionals the fundamentals of using MS Excel to experts to allow them to use the precious skill to enhance output & effectiveness on their jobs. MS Excel is a spreadsheet programs that allow user to creates worksheet that store up information's in workbook file. The built in function allows user to creates & edits formula; copy, moves, sorts & filter data; formatting worksheet; and set-up worksheet for print.
Program content includes the various Subjects:
* Opening Excels
* Creating a new workbooks
* Saving a workbooks
* Opening an existing workbooks
* Understanding the dissimilarity between a workbooks and a worksheets
* Working with worksheet
* Using auto completed to creates commonly used list
* Working with data
o Inputting data into a cells
o Sortings
o Filtering a lists
o Inserting formula
* Working with cell, row, & column
o Formatting cells data & appearances
o Insert or delete cell, row, & column
o Formatting columns & rows property
* Working with chart
o Creates charts data
o Creates and format a charts
* Adding a Headers or Footers to a Worksheets or Charts
* Printing worksheet
o Formatting worksheets pages and printings property
* Workings with Multiples Worksheet
o Import Data
* View Data
o Sortings
o Filterings data
o Condition Format
o Paste Special
* Advanced Formula & Function
o Format Formula
o Using Function in Excel
o Showing Formula instead of Formula Value on a spreadsheets
* Splitting & Freezing Pane in a worksheets
* Working with charts
o Creating a Charts or Graph Sheets
o Formatting a Charts
o Modifying a Charts or Graphs
o Adding an items
o Removing an items
o Changing the graphs types
o Adding a trend lines
o Adding Header & Footer
* Workbooks Protections
Course in Microsoft EXCEL - Basic