MS Excel Tutorial
MS Excel is a spreadsheet program that is created by Microsoft, for platforms like Windows, macOS, Android, iOS, and iPadOS. It is used for Data Organization, Formatting, Calculation, Data Analysis, and other tasks. If you are seeking a full guide to MS Excel and its formulas, then this MS Excel tutorial is designed for beginners and experienced Excel professionals.
Here in this Excel tutorial, we cover all the basic and advanced-level topics to get from zero to mastery of the MS Excel program.
The tutorial is divided into three sections: Beginner, Intermediate, and Advanced. In each segment, you will explore various subjects that will enhance your Excel skills. You will learn about functions, working with data, sorting, data analysis, advanced charts and graphs, and many other advantages of using Excel spreadsheets.
Table of Content
- What is Microsoft Excel?
- Why to Learn Excel
- Advantages of Microsoft Excel
- Microsoft Excel Features
- Excel can be used for:
- Getting started with MS Excel Tutorial
- What are Workbooks?
- What are Worksheets in Excel?
- What is Data Formatting?
- MS Excel Formulas
- What are Functions?
- Basic Tips For Working with Data
- Tables
- What are Charts?
- Understanding Conditional Formatting
- What are Pivot Tables?
- What are Macros?
- What is VBA?
- Some Extra Features of Excel
- What are Reference Styles?
- Power View
- Power Pivot
- Advanced Excel
- Power Query
- Microsoft Excel Keyboard Shortcuts
What is Microsoft Excel?
As we know, MS Excel is a powerful spreadsheet program that is part of the Microsoft Office product group for business applications. This Microsoft Office program allows users to store, organize, analyze, and visualize data in a tabular format.
Its reflexive interface, extensive functionality, and, several formulas make MS Excel simple for users to handle a huge amount of data. Hence, MS Excel is widely used in various industries, including finance, marketing, education, and more.
Looking for an online converter to convert your Excel file to PDF? Here we have the perfect tool for you!
Excel to PDF Converter
Why to Learn Excel
Here in this section, you will get to know why this MS Excel tutorial is needed and what are the benefits.
- Enhanced Data Analysis: Excel empowers users to analyze large datasets, identify trends, and draw meaningful insights with its powerful functions and tools.
- Increased Efficiency: Excel’s automation features streamline repetitive tasks, saving time and reducing errors.
- Improved Decision Making: Excel’s clear and visually appealing data organization enables users to make informed decisions in various contexts.
- Advanced Financial Analysis: Excel’s financial functions and modelling capabilities are essential for complex calculations and evaluating investment opportunities.
- Versatility and Integration: Excel seamlessly integrates with other Microsoft Office applications and external data sources, facilitating data sharing and analysis.
- Career Advancement: Proficiency in Excel opens doors to job opportunities requiring data analysis, reporting, and financial management skills, enhancing professional value.
Advantages of Microsoft Excel
MS Excel is widely used for various purposes because the data is easy to save, and information can be added and removed without any discomfort or hard work.
- Easy To Store or Organize Data: Using Microsoft Excel one can easily store or organize large amounts of data.
- Easy To Recover Data: Because Excel is Microsoft product, hence the recovery of data is very easy.
- Easy to Manipulate or Visualization: Excel allows users to easily create data visualizations with charts.
- Direct Application of Mathematical Formulas: Using Excel one can perform mathematical calculations on data sets, such as finding averages, standard deviations, and correlations.
- Free Template: Excel has many free templates to use.
- More Secure: Rather than other Spreadsheet programs Excel is more secure and less venerable.
- Clearer Visibility of Complex Information: Excel store all its data in tabuler for hence, handling of complex data is easy.
Microsoft Excel Features
Anyone can learn how to use and take advantage of the program’s powerful features.
- Excel users can utilize AutoFormat to use predefined table formatting settings.
- AutoSum: The AutoSum function allows us to automatically calculate the sum of a row or column by inputting an addition formula for a range of cells.
- List AutoFill: It creates cell formatting automatically when a new component is added to the end of a list.
- AutoFill: This function allows us to swiftly fill cells with a repetitive or sequential record, such as chronological dates or numbers, or documents that are repeated. Functions can also be copied using AutoFill. This function also allows us to change text and numbers.
- AutoShapes: The AutoShapes toolbar allows us to design geometrical shapes, arrows, flowchart items, stars, and other objects. We can create graphs using these forms.
- Wizard: It assists us in working more effectively by showing many useful recommendations and approaches based on what we are doing. The drag-and-drop capability allows us to reposition the record and text by dragging the data with the mouse.
- Charts: This tool allows you to exhibit data in graphical form by utilizing Pie, Bar, Line, and other charts.
- PivotTable: It flips and sums data in seconds, allowing us to perform data analysis and generate documents such as periodic financial statements, statistical reports, and so on. We can also visualize complex data linkages.
- Shortcut Menus: The shortcut menu assists users in completing tasks by using shortcut commands that need a lengthy process.
Excel Can Be Used For
- Analysis
- Data Entry
- Data Validation
- Accounting
- Budgeting
- Data analysis
- Visuals and Graphs
- Programming
- Financial Modeling
Getting started with MS Excel Tutorial
The easiest way to get started with Excel is to use Microsoft 365, previously known as Office 365. It does not require downloading or installation of the program.
Parts of the Excel Window
Before you start using it, it’s really important to understand what is where in the window. Some parts of the Excel window (like the Ribbon and Scroll bars) are standard in most Microsoft programs. However, there are other features that are more specific to spreadsheets, such as the formula bar, name box, and worksheet tabs.
What are Workbooks?
A collection of worksheets is referred to as a workbook (spreadsheet). Workbooks are your Excel files. There are various ways to begin working with an Excel workbook. Excel files are called workbooks. There are various ways to begin working with an Excel workbook. You can either start from scratch or use a pre-designed template to create a new workbook.
Creating and Opening Workbooks
Steps to Create a new blank workbook:
Step 1: Select the File tab
Step 2: Click New
Step 3: Click Blank Workbook
Step 4: A new blank workbook will appear.
You can also use Templates. A template is a predesigned spreadsheet you can use to create a new workbook quickly. Templates often include custom formatting and predefined formulas.
Saving Workbook
Whenever we create a new workbook in Excel and insert the data into it, then we must save our workbook so that our data is not lost. As in previous versions of Excel, you can save files locally to your computer You can also save your workbook to the cloud and also export your workbook with others.
Save: When you save a file, you’ll only need to choose a file name and location the first time. Then you can just use the save command to save it with the same name and location.
Save As: When you use Save As, you’ll need to choose a different name and /or location for the copied version.
Excel automatically saves your workbooks to a temporary folder while you are working on them. If you forget to save your changes or if Excel crashes, you can restore the file using AutoRecover.
What are Worksheets in Excel?
A Worksheet is a collection of cells(basic data unit in the worksheet). Where you can store and manipulate data. Adding information to multiple worksheets simultaneously is also easily accomplished by grouping worksheets. In Excel, Worksheets can be easily added, renamed, and deleted.
Working with Worksheets
When you open an Excel Workbook, there are three sheets by default and the name on them is sheet1, sheet2, and sheet3 you can change the name. You can perform multiple functions in Worksheets such as View a Worksheet, Select a Worksheet, Insert a Worksheet, Rename a Worksheet, and Delete a Worksheet.
Modifying Columns, Rows, and Cells
Every row and column of a new workbook is set with the same height and width. Excel allows you to modify column width and row height in different ways including wrapping text and merging cells.
Inserting, Deleting, Moving, and Hiding
After working with a workbook for a while, you may want to Insert new columns or rows, Delete certain rows and columns, Move them to a different location in the worksheet, or even Hide them.
- How to Delete Blank Columns in Excel?
- Import Export of Data in Excel
- How to Delete All Rows Below Certain Row or Active Cell in Excel?
- How to Hide and Unhide Columns in Excel?
- How to Compare Two Columns and Delete Duplicates in Excel?
- How to Copy Cells on a Diagonal?
- Hide Error Values and Indicators in Cells in Excel
You can easily search your workbook using the Find feature, which also allows you to modify using the Replace feature.
Excel includes a Spell-check tool that ensures everything is spelled correctly in your workbook.
What is Data Formatting?
All cell content uses the same Formatting by default, which can make it difficult to read a workbook with a lot of information. Data Formatting can be used to Change the font size, To change the font, To change the font color, and many more.
MS Excel Formulas
The most important and useful feature of Microsoft Excel is to Calculate numerical information using formulas. Excel can perform different calculations using mathematical operators (Addition, Subtraction, Multiplication, Division) We can Insert a formula, Create a Formula, and Edit a Formula. Also, values can be modified on the basis of Cell References.
- Excel Formulas
- Excel Formulas and Functions
- How to calculate the Sum and Average of numbers using formulas in MS Excel?
- How to Generate All Prime Numbers Between Two Given Numbers in Excel?
- How to Calculate Running Total in Excel?
- How to Correctly Sum Numbers With Units in a Range in Excel?
- Array Formulas in Excel
- How to Create an Array Formula in Excel?
- Organization Chart in Excel
- Dynamic Array Formulas in Excel
- Difference Between Array Formula and Regular Excel Formula
- Cell References in Excel – Relative, Absolute, Mixed
- How to Format Time in Excel?
- Excel Formula to Get Next Day of Week
- How to Use Correlation in Excel?
- Sample Size Calculator With Excel
- How to Count the Number of Words in a Cell or a Range Cells in Excel?
- How to Calculate Conditional Probability in Excel?
- How to Calculate Partial Correlation in Excel?
- How to Calculate a Percentage of a Number in Excel?
- How to Calculate the Sum of Digits in a Number Using Non-Array Formulas in Excel?
- How to Apply a Percent Increase or Decrease to Values in Excel?
- How to Calculate Point-Biserial Correlation in Excel?
- How to Fix Excel Formulas that are Not Working properly?
- How to Use ChatGPT to Write Excel Formulas?
- How to Create Automatic Rolling Months in Excel?
- How to Create a Formula in Excel using Java?
- How to Calculate Fleiss’ Kappa in Excel?
What are Functions?
A function is a predefined formula that is used to perform calculations using specific values in a sequence. Excel has many common functions that can be used to quickly find the Sum, Average, Count, Maximum Value, and Minimum Value of a range of cells.
- How to Insert a Function in Excel?
- New Functions in Excel 2019
- IF Function in Excel With Examples
- MID Function in Excel
- How to Apply a Percent Increase or Decrease to Values in Excel?
- Excel String Functions – LEFT, RIGHT, MID, LEN, and FIND
- Statistical Functions in Excel With Examples
- Excel Date Functions – with Formula Examples
- INDEX and MATCH With Multiple Criteria In Excel
- How to Create a Custom Date Format in Excel?
- INDEX and MATCH Function in Excel
- CHOOSE Function in Excel
- How to VLOOKUP to Return Multiple Values in One Cell in Excel?
- Excel VLOOKUP with Dynamic Column Reference
- Why INDEX MATCH is Better Than VLOOKUP in Excel?
- XLOOKUP Function in Excel With Examples
- XLOOKUP vs INDEX-MATCH in Excel
- How to Use the Excel STDEV.P Function?
Basic Tips For Working with Data
Excel Workbooks are designed to store a lot of information no matter you are working with 10 cells or 10,000 cells. Excel has many features to help you Organize your data and Find what you need.
Sometimes you may want to see certain rows and columns all the time in your worksheet, mainly Header cells. By freezing rows and Columns in place, you’ll able to scroll through your content.
- Excel Shortcuts
- Top 20 Excel Shortcuts That You Need To Know
- 6 Tips for Creating Effective Data Visualizations
- How to Compare Two Columns in Excel?
- How to Create a Dependent Drop Down List in Excel?
- How to Count Duplicate Values in a Column in Excel?
- How to Compare Two Lists or Datasets in Excel?
- How to Automate Data Entry In Excel?
- How to average a range of data ignoring zero in Excel?
- How to Separate Text and Numbers from One Cell Into Two Columns?
- How to Remove Text Before or After a Specific Character in Excel?
- How to Add or Subtract Dates in Excel?
- How to Convert Weekday Name to Number in Excel?
- How to Hide the Zero Values in Excel?
- How to average a range of data ignoring zero in Excel?
- How to Normalize Data in Excel?
- How to Extract the last N words in Excel?
- How to Apply the Empirical Rule in Excel?
- How to Create a Custom Date Format in Excel?
- How to Use SQL Statements in MS Excel?
1. Sorting Data
You can quickly reorganize your data in a sequence you want in your worksheet by sorting your data. You can sort your data alphabetically, numerically, and in many other ways.
2. Filtering Data
Filters can be applied to data in your worksheet allowing you to view only the information you need. Formatting Data as a Table can improve the overall look of your workbook and help you to organize your content and make your data easier to use.
3. Groups and Subtotals
Worksheets with a lot of content can sometimes feel overwhelming. Excel provides you with the feature of organizing data into Groups, allowing you to easily show and hide different sections of your worksheet. The Subtotal command allows you to quickly summarize data. Below are some functions that you can learn in Groups and subtotal.
- To group rows or columns
- To hide and show groups
Tables
After entering your data in the worksheet, you may want to format your data as a table. They will help to organize your data content and make your data easier to use and understand. Excel has many predefined table styles, allowing you to create tables quickly and easily.
Formatting Data as a Table
Step 1: Select the Cells you want to format as a table
Step 2: Click the Format as Table in the styles group from the Home tab
Step 3: Now select Table Style from the drop-down menu
Step 4: Confirm the cell range for the table
Step 5: Click OK if your table has headers
Step 6: The cell range will be formatted in the selected table style.
Modifying Tables
It is easy to modify the look of the table after adding it to a worksheet. Excel includes several options for customizing a table, including adding rows or columns, changing the table style, Modifying the table style options, and removing a table.
What are Charts?
It is difficult to examine Excel workbooks that contain a lot of data. Charts help you to illustrate your workbook data graphically, which makes it easy to examine and compare the Excel workbook and make better decisions.
You can learn how to insert and modify Excel Charts to visualize comparisons in your data. There are many options to change the chart and layout style.
- How to Create Charts in Excel?
- How to Move and Resize a Chart in Excel?
- Types of Charts in Excel
- How to Change Chart Style in Excel?
- Formatting Charts in Excel
- How to Add a Horizontal Line in a Chart in Excel?
- How to Add Lines In An Excel Clustered Stacked Column Chart?
- How to Create an X-Y Scatter Plot in Excel?
- How to Make a Bar Graph in Excel?
- How to Create a Column Chart in Excel?
- How to Create Line Charts in Excel?
- How to Create a Waterfall Chart in Excel?
- How to Make a Comparison Chart in Excel?
- How to Create an Excel Step Chart Formula Using the Small Function?
- How to Create a Chart from Multiple Sheets in Excel?
- How To Create A Pictograph In Excel?
- Using Columns and Bars to Compare Items in Excel Chart
- Organization Chart in Excel
- How to Calculate Cumulative Frequency table in Excel?
- How to Graph three variables in Excel?
- How to Update, Change and Manage the Data in a Chart in Excel?
- How to Auto Update a Chart After Entering New Data in Excel?
- Actual Vs Target Chart In Excel With Floating Markers
- Dynamic Organizational Chart in Excel
- How to Create Dynamic Chart Titles In Excel?
- How to Create a Goal Line on a Chart in Excel?
- How to Create Advanced Charts and Graphs in Excel?
- How to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart?
- How to Make a Frequency Polygon in Excel?
- How to Find the Intersection of Two Curves in Excel?
- How to Create a Sales Funnel Chart In Excel?
- How to make Overlapping Bar Chart in Excel?
- How to Make a Dynamic Gantt Chart in Excel?
- How to Create a Rolling Chart in Excel?
- Scatter and Bubble Chart Visualization in Excel
- Modifying Data Range in Excel Charts
- How to Plot Bivariate Data in Excel?
- Compare Data in an Excel Chart using Drop Down Lists
- How to Create a Survival Curve in Excel?
- Multiple Series in One Excel Chart
- How To Make A Graph With Multiple Axes With Excel?
Understanding Conditional Formatting
Similar to charts Conditional formatting provides a way to visualize data and make worksheets easier to understand. It allows you to automatically apply formattings- such as formattings, and data bars to one or more cells. You can use Conditional formatting by using the below steps.
How to use Conditional Formatting in Excel
Step 1: Select desired cells
Step 2: Click on the Conditional formatting command from the Home Tab
Step 3: Select the desired rule from the menu that appears
Step 4: Enter the desired values in the dialog box
Step 5: Select Formatting styles.
You can also use Conditional Formatting presets and Remove the Conditional Formatting.
What are Pivot Tables?
If your workbook contains lots of data, it can sometimes be difficult to analyze all the information in your worksheet. PivotTables can help to make worksheets more manageable by summarizing data and allowing you to manipulate it in different ways.
How to Create Pivot Tables
Step1: Select the Create or cells
Step 2: From the Insert tab click on the PivotTable
Step 3: Choose your settings in the Create PivotTable Dialog box and click ok
Step 4: A blank PivotTable and Field List will appear in a new worksheet.
- Prepare Source Data for Pivot Tables In MS Excel
- How to Create a Power PivotTable in Excel?
- How to Prevent Grouped Dates In Excel Pivot Table?
- How to Hide Zero Values in Pivot Table in Excel?
- How to Remove Old Row and Column Items from the Pivot Table in Excel?
- Exploring Data with PivotTables in Excel
- Sorting Pivot Table in Excel
- How to Flatten Data in Excel Pivot Table?
- How to Remove Pivot Table But Keep Data in Excel?
- How to Add and Use an Excel Pivot Table Calculated Field?
What are Macros?
Macro allows automating repetitive tasks in Microsoft Excel. Some tasks need to be performed multiple times and repetition of all actions would consume time. In these scenarios, Macros help in automating these tasks. A Macro is the set of actions that we run as many times as required to perform a particular task. When the macro is Created, the whole mouse clicks, and the keystrokes get recorded.
You can learn how to Enable a Macro, How to Record a Macro, and How to Run a Macro in different ways.
- How to Configure Macros in Excel?
- Relative References in Excel Macros
- Absolute References in Excel Macros
- How to Password Protect Your Excel Macro?
- Assigning Excel Macro to Objects
- Editing Excel Macros in Excel
- How to Run a Macro Automatically When Workbook Opens in Excel?
- UserForms in Excel Macros
- Excel Personal Macro Workbook
What is VBA?
VBA stands for Visual Basic application is a readable and editable programming code that gets generated when the macro is recorded. It is now used with Microsoft Office applications such as MS Excel, MS Word, and MS- Access. With VBA, you can refer to the Excel Objects and use the properties, methods, and events associated with them.
- How to Insert and Run VBA Code in Excel?
- Get, Set, or Change Cell value in Excel VBA
- How to Run Code from a Module in Excel VBA?
- How to Delete a Module in Excel VBA?
- Workbook and Worksheet Object in Excel VBA
- Excel VBA Events
- Basic Object Model in Excel VBA
- Variables and Data Types in VBA Excel
- Application Objects in Excel VBA
- VBA Objects in Excel
- VBA Strings in Excel
- VBA Constants in Excel
- VBA Arithmetic Operators in Excel
- VBA Arrays in Excel
- VBA Print Statement in Excel
- VBA Find Function in Excel
- VBA Date and Time Functions in Excel
- VBA Collections in Excel
- How to Set Variable to Cell Value in Excel VBA?
- VBA Subroutine in Excel – How to Call Sub in VBA?
- Sub Procedure in Excel VBA
- Excel VBA Error Handling
- Generating Dynamic Charts With VBA in Excel
- Debugging VBA Code in Excel
- How to Declare and Initialize String Array in Excel VBA?
- How to Add a Comment in a VBA in Excel?
- Multidimensional Arrays in Excel VBA
- How to Convert VBA Collections to Array in Excel?
- How to Round With Doubles in Excel VBA?
- Trapping Dynamic Ranges in Excel VBA
- InputBox Function in Excel VBA
- MessageBox in Excel VBA
- How to Get a List of User Defined Functions in Excel VBA?
- ActiveX Control in Excel VBA
- How to Create an Input Box With Multiple Inputs in Excel Using VBA?
- How to Create Charts in Excel Using Worksheet Data and VBA?
- Programming Charts in Excel VBA
Some Extra Features of Excel
Comments and Co-authoring
These are the two most powerful features that allow you to work with others on the same spreadsheet: Comments and Co-authoring these features come in the role when you’re working on a workbook and find that you need the help of others.
The Track Changes feature can also be helpful to review changes before making them permanent. It’s still available in Office 365, but it’s now Hidden by default.
Inspecting and Protecting Workbooks
While sharing a workbook in Excel, everyone wants to make sure it doesn’t include any spelling errors or information you want to keep private. Excel includes several tools to help finalize and protect your workbook, including Document Inspector and Protect Workbook Feature.
What-if Analysis
This feature can help you experiment and answer questions with your data, even when the data is incomplete. To learn how to use the What -if- analysis, use a tool called Goal Seek.
New Features in Office 2019
Office 2019 was released in September 2018, If you have used 2016 or earlier versions, you will probably find Office 2019 familiar. The interface is similar and most of the features still work the same. There are a couple of new chart types in Excel: Map charts and Funnel charts.
What are Reference Styles?
Every Excel spreadsheet contains rows and columns. Most of the time columns are denoted by letters (A, B, C) and rows are denoted by numbers(1, 2, 3). This is known as the A1 reference style.
Whether you use a digital pen, touchscreen, or mouse, the drawing feature in the office can help you to add notes, create shapes, edit text, and more.
If you need graphics for the project, there is a feature you can use called icons. Icons are a library of modern, professional graphics included with Office 365 and 2019, and they can be customized to fit your needs.
Power View
Power View is the data visualization technology that lets you create interactive charts, graphs, maps, and other various visuals. Power View enables interactive data exploration that encourages intuitive ad-hoc reporting. Power view is completely based on the Data model in your workbook. There are various functions and operations to be performed on Power View listed below.
- How to Enable and Use Power View in Excel?
- How to Insert or Show Power View in Excel?
- Data Visualizations in Power View
- Chart Visualizations in Excel Power View
- Table Visualization in Excel Power View
- Card Visualization in Excel Power View
- Bar Chart Visualization with Excel Power View
- Matrix Visualization in Excel Power View
- Multiple Visualizations in Excel Power View
- Line Chart Visualization in Excel Power View
- Tiles Visualization with Excel Power View
- Exploring Data with Power View Maps in Excel
- Exploring Data with Power View in Excel
Power Pivot
It is an Excel add-in that can be used to perform better data analysis and create sophisticated data models. With Power Pivot, you can work on large volumes of data from different sources, and perform information analysis effectively. When you have multiple tables, Power Pivot can help you to link them together. After linking them together you can create a Pivot table that will help you to view the data in a single table.
- Power Pivot for Excel Tutorial
- Excel Power Pivot – Managing Data Model
- Creating a Data Model in Excel
- How to Flatten Data in Excel Pivot Table?
- Features of Excel Power Pivot
- Hierarchies in Excel Power Pivot
- Exploring Data with Excel Power Pivot
- Table and Chart Combinations in Excel Power Pivot
- Creating a Power Pivot Chart in Excel
- Loading Data with Power Pivot in Excel
Advanced Excel
Advanced Excel provides a good insight into the latest and advanced features available in Microsoft Excel.
Power Query
It is a tool available in Excel that helps you to import data from many different sources and then clean, transform and reshape the data as required. You need to set up a query once and then reuse it with a simple refresh. The query can import millions of rows into the data model for analysis.
- Power Query – Source Reference as File Path in Cell
- Connecting Excel to SQLite
- How to Copy Power Query Queries in Excel?
- How to Import, Edit, Load and Consolidate Data in Excel Power Query?
- How to Create a Relative File Path with Power Query in Excel?
- Text Modifications with Power Query in Excel
- Date Modifications with Power Query in Excel
- How To Get Current Date in Power Query?
- Excel – Types of Merging of Queries in Power Query
- Power BI – Tools and Functionalities
- Power BI – Data Sources and its type
Microsoft Excel Keyboard Shortcuts
Knowing keyboard shortcuts can significantly speed up your Excel workflow. Here are a few commonly used shortcuts:
- Ctrl + C: Copy selected cells
- Ctrl + V: Paste copied cells
- Ctrl + Z: Undo the last action
- Ctrl + S: Save the workbook
- Ctrl + F: Open the Find dialog box
- Ctrl + B: Apply bold formatting
- Ctrl + Shift + L: Apply filters to a table
More MS Excel Keybord Shortcuts – Excel Keybord Shortcuts
FAQs on MS-Excel
Q1: What are the benefits of using MS Excel?
The main benefit of using MS-Excel are:
- The MS-Excel is best way to store a huge amount of data.
- You can perform different Calculations.
- There are several tools that are available for Data analysis
- You can print reports easily.
- You can automate your code easily .
- You can Transform your data.
- It’s easy to reformat and rearrange your data.
- Process data and analysed with graphs and charts
Q2: What are the shortcut keys of MS Excel?
Shortcut Keys are used for navigating and working with Excel spreadsheets with speed. The main shortcut keys of MS-Excel are:-
- Key to open a workbook (Ctrl+N)
- Key to open a saved workbook(Ctrl+O)
- Key to save a workbook(Ctrl+S)
- Key to copy the selected cells(Ctrl+C)
- Key taste the copied cells(Ctrl+V)
- Key to cut the selected cells(Ctrl+X)
- Key to close the workbook(Ctrl+W)
- Key to remove all the contents from the cell(Delete)
- Key to print the workbook(Ctrl+P)
- Key to undo(Ctrl+Z)
Q3: Is MS Excel an Operating system?
MS-Excel is not an operating system. It is a spreadsheet program included in the Microsoft Office suite of several applications. It is introduced by Microsoft and it is developed for Windows, Android, macOS, and iOS users.
Q4: What do you mean by Cell address?
Cell address refers to the address that is obtained by the combination of the row number and column alphabet. Every celll has a distinct cell address.
Q5: How can you protect your workbooks in Excel?
To protect your workbook below are three ways:
- Set a password to open the workbook.
- Protect the sheet from being added, deleted, hidden, or unhidden.
- Protecting window sizes or positions from being changed.