Learning MS Excel Formula, Functions and Charts

Learning MS Excel Formula, Functions and Charts

MS Excel is an application software that helps us to store and analyze data. It organizes data in the form or rows and columns. You can create and graphs from the data and convey more meaningful information through them. MS Excel is of great importance to those who maintain accounts for sales, bills or do mathematical calculations. MS Excel has features and applications for calculation, and graphics tools and tables for presenting text and numeric data.

Basic MS Excel Formula and Functions Video
Students will learn basic excel function and formulas after watching this video.
Introduction to MS Excel
View all
Quiz on Basic MS Excel
MS Excel Formula Bar
• Formula bar : Excel Formula bar is located at the top of the Excel Worksheet window. Excel Formula bar has three parts. The left most is the "Cell Name Box", middle one "Formula Bar Buttons" and right one is the contents of the currently selected cell. The data or formula entered in the Active cell will appear in right-most section.
Quick Access Toolbar
• Quick Access Tool Bar : Quick Access Tool Bar (QAT) is located above Excel Ribbon. It is used to hold commonly used commands. Quick Access Tool Bar (QAT) is always visible, regardless of which tab is selected. By default, the Quick Access Tool Bar (QAT) contains the Save, Undo and Redo button. The Quick Access Tool Bar (QAT) is customizable so that we can add commonly used commands there.
MS Excel Ribbon
• Ribbon : Excel Ribbon is the technical term for the row of Tabs above Formula bar. Excel Ribbon is a strip of buttons and icons (refer below image) in Excel Workbook window where Excel commands are located. The buttons and icons of Excel Ribbon are grouped in to different tabs based on the category of their functionalities. Clicking a tab in the tab list changes the Tab of Excel Ribbon.
• Ribbon Options : When you click Ribbon Options button, three different options related with the display of Ribbon is shown. Available options in Excel 2019 are "Auto-hide Ribbon", "Show Tabs", "Show Tabs and Commands".
MS Excel Formula and Functions
View all
Basic MS Excel Formula and Functions Video
Free preview
Students will learn basic excel function and formulas after watching this video.
MS Excel Formula & Function Quiz
IF conditional statement MS Excel Exercise Video
Free preview
MS Exercises for students about IF conditional statement.
Top 10 MS Excel Functions
A function is a built-in formula in MS Excel that is used to carry out common mathematical calculations. Functions save us from writing lengthy formulae. Excel can be used to perform tasks as finding the average or sum for a range of numbers. In Excel, we should write each function in a specific order called syntax.
Function should begin with the (=) or @ sign followed by the function name, SUM or AVG is a function name. The third part is arguments. It can be numbers, text or cell reference. Arguments are enclosed within parentheses (). When there is more than one argument, each is separated by a comma.
Creating Charts in MS Excel
View all
Components of a Chart
Free preview
Charts help us to quickly understanding the data by plotting the data in graphs. We can present the data to visually represent with charts in Excel. Here is an example chart for customer ratings for an item. We can see the chart and quickly understand how the customers are liking a product.
Types of Chart
Free preview
A chart is a pictorial representation of data in a workbook, which helps us to compare and analyze data. It also helps us to see the relationship between different parts of data.
A two-dimensional chart has two axes-X-axis and Y-axis representing two different variables. Data are plotted on (X,Y) co-ordinates. A chart can also be three-dimensional, in which case data are plotted on three different variables, represented by X,Y and Z axes.