MS Excel Training
Microsoft Excel is a spreadsheet application developed by
Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing
tools, pivot tables, and a macro programming language. Excel forms a part of
Microsoft Office. Excel supports Charts,
Graphs, or Histograms generated from specified groups of cells. Excel is an
incredibly powerful tool for getting meaning out of vast amounts of data. But
it also works really well for simple calculations and tracking almost any kind
of information. Cells can contain numbers, text or formulas. Fill data in your
cells and group them in rows and columns. That allows you to add up your data,
sort and filter it, put it in tables, and build great-looking charts. Excel is a Microsoft office application.
Excel is mainly used for making calculations and mathematical works. Microsoft
excel is a spread sheet application in which no of sheets we can add as per our
requirements. In a single sheet, it consists of rows and columns and cells.
Below you may see
Very Features of Excel:-
- Hyperlink:-We can link one file to another file or page with the use of Excel.
- Clip Art: - In this we can add images and also audio, video clips can be added here.
- Charts: - With charts, we can clearly shown products evaluation to the clients. For example which product sale is more or less in this month.
- Tables:- Tables are created with different fields eg -name, age, address, roll no so we add a table to fill these values.
- Functions:- MATHEMATICAL: Add, subtract, div, multiply.
- LOGICAL:- Average, sum, mod, product
- Images & Backgrounds:- In this we add images and backgrounds in sheet.
- Macros:- Macros are used for recording events for further use.
- Database:- We can add database from other sources with data feature.
- Sorting and Filter:- In sorting we can sort our data and also filter our data so that repetitions will be removed.
- Data Validations:- In data tools there are data validations consolidate etc are used.
- Grouping:- In this we can use group, un-group subtotal etc.
- Page layout:- In this themes, Colors, Sheets, Margins, Size, Backgrounds, Breaks, Print, Titles, Sheets Height, Width, Scaling, Gridlines, Headings, Views, Alignment etc.. will be used.
The Imperus Institute of Global Certifications - IIGC
Website: IIGC Home Page
Email - tarunbansal@iigc.co.in
Contact- +91-8470056900
No comments:
Post a Comment