-
₹5000
-
Duration: 16 Hours
-
Delivery mode: Online
-
Group size: Individual
-
Instruction language:
English,
Hindi
-
Certificate provided:
No
Basic Concepts of MS Excel
Here is a detailed look at the fundamental concepts of MS Excel:
1.Workbooks and Worksheets
Workbook: An Excel file containing one or more worksheets.
Worksheet: A single spreadsheet within a workbook consisting of cells arranged in rows and columns.
2.Cells, Rows, and Columns
Cell: The basic unit for storing data, identified by a column letter and a row number (e.g., A1).
Row: A horizontal group of cells identified by a number.
Column: A vertical group of cells identified by a letter.
3.Formulas and Functions
Formulas: Expressions used to perform calculations on data in cells, starting with an equals sign (e.g., =A1+B1).
Functions: Predefined formulas that simplify complex calculations (e.g., SUM, AVERAGE).
4.Conditional Formatting
Allows users to change the appearance of data in cells, including font size, colour, cell borders, and background colour, to improve readability and presentation.
Automatically format cells based on your specified criteria, such as highlighting cells with values above a certain threshold.
5.Charts and Graphs
Visual tools that represent data graphically, such as bar charts, line graphs, and pie charts, help to illustrate trends and patterns.
6.PivotTables
PivotTable is a powerful feature for summarising, analysing, exploring, and presenting large amounts of data.
PivotTables can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarised data.
7.Data Validation
Ensures the integrity of your data by setting rules that dictate what data can be entered into a cell.
Sorting and Filtering
Sorting: Rearranges data in a specific order, either ascending or descending.
Filtering: Allows the display of only the rows that meet specific criteria, hiding the rest.