excel tutorial

Excel provides a Consolidate feature that allows you to combine data from several worksheets or workbooks into a single summary worksheet. This is very useful when the worksheets are not identical, because Excel can match the data using row and column labels. In this example, you have three workbooks: Each workbook contains similar data, but

Grouping worksheets lets you edit many sheets at the same time.This is very useful when your sheets have the same layout, such as sales data for different regions. Group Selected Worksheets Use this when you only want to edit some sheets. Step 1: Select the Sheets You Want to Group Step 2: Edit the Grouped

When you work with a large table, it’s easy to lose headings when you scroll.Freeze Panes lets you keep important rows or columns always visible while scrolling. Freeze the Top Row (Most Common) Use this when your column titles are in Row 1. Unfreeze Rows or Columns Use this to remove all freezes. Freeze the

Splitting a worksheet lets you view different parts of the same sheet at the same time.This is very useful when working with large tables or many rows and columns. 👉 You can split the screen: Split the Worksheet Horizontally (Top and Bottom) This keeps the top rows visible while you scroll down. How to use

Zooming in Excel helps you see your worksheet better.You can make the screen bigger or smaller without changing the actual data. Method 1: Quickly Zoom Using the Status Bar This is the fastest way to zoom. Method 2: Zoom to an Exact Percentage Use this when you want a specific zoom level, like 100% or

Sometimes you need to share an Excel file with people who use older versions of Excel (before Excel 2007).In this case, you should save your file as Excel 97–2003 (.xls) instead of .xlsx. Method 1: Save One File as Excel 97–2003 Step-by-step: ✅ Your file is now saved in the older format and can be

There are two simple ways to merge Excel files: Method 1: Merge a Few Excel Files (2–10 Files) This method uses Excel’s built-in Move or Copy feature.No coding required 👍 Step 1: Open All Excel Files 👉 Keep all files open at the same time. Step 2: Select Sheets to Move ✔ To select many

Excel automatically saves temporary copies of your work in the background.This means you can often recover your file even if: Let’s go step by step. Case 1: Excel Crashed and Reopens What happens? When Excel crashes, the next time you open Excel, you will see the Document Recovery Pane. What to do: Case 2: Recover

Excel allows you to open and view two or more workbooks at once.This is very useful when you want to compare data, copy information, or check differences between files. Step 1: Open More Than One Workbook 👉 Make sure both files are open at the same time before continuing. Step 2: Arrange All Open Workbooks

Excel allows you to change the overall look of your workbook with just one click.This is called a Theme. A theme includes: When you change a theme, your entire workbook updates automatically. Step 1: Check the Current Theme Step 2: See the Theme Colors and Fonts 👉 In the Office theme, the fonts are: Step