Microsoft Excel is the most widely used business software in the world. Whether you are tracking expenses, building a budget, analyzing data, or managing a project, Excel is probably the tool you will use. This guide takes you from absolute zero to confidently building useful spreadsheets.
What is Excel?
Excel is a spreadsheet application made by Microsoft. A spreadsheet is a grid of cells organized in rows (numbered 1, 2, 3...) and columns (lettered A, B, C...). Each cell can hold a number, text, or a formula. The power of Excel is in the formulas: they let one cell calculate its value based on other cells, creating dynamic, interconnected data.
Navigating the Excel interface
When you open Excel, you see the Ribbon at the top (tabs like Home, Insert, Data), the formula bar below it, and the grid of cells. The active cell has a blue border. You can click any cell to select it, or use the arrow keys to move around. The Name Box on the left of the formula bar shows the current cell address (like A1 or B5). The sheet tabs at the bottom let you switch between sheets in the same workbook.
Entering data and basic formatting
Click a cell and start typing to enter data. Press Enter to move down, Tab to move right. To format cells, select them, then use the Home tab: Bold, Italic, font size, cell color, and number formatting (currency, percentage, date). The most important formatting skill is number formatting: make sure your numbers look like numbers, your dates look like dates, and your currency shows dollar signs.
Your first formulas
Type =2+3 in a cell and press Enter. Excel shows 5. That is a formula. Now the useful version: if cell A1 has 100 and A2 has 50, type =A1+A2 in A3. It shows 150. Change A1 to 200 and A3 automatically updates to 250. This is the fundamental concept of spreadsheets: cells reference other cells, and everything updates when the source data changes.
Five essential functions
SUM adds a range: =SUM(A1:A10). AVERAGE calculates the mean: =AVERAGE(B1:B20). COUNT counts cells with numbers: =COUNT(C1:C50). MAX and MIN find the highest and lowest values. These five functions cover most beginner needs. Type them into a cell starting with = and Excel will help you with autocomplete.
Working with tables
Select your data and press Ctrl+T to convert it into an Excel table. Tables automatically format your data with alternating row colors, add filter dropdowns to every column header, and make formulas easier to write. Always use tables for structured data. They are one of Excel's most underused features.
Sorting and filtering
Click a filter dropdown on any column header and uncheck the values you do not want to see. Or click Sort A to Z / Sort Z to A to reorder. For numbers, you can filter by conditions like Greater Than, Less Than, or Between. Filtering does not delete data; it just hides rows temporarily. Click Clear Filter to show everything again.
Creating your first chart
Select your data (including headers), go to Insert, and pick a chart type. For most data, a bar chart or line chart is the right choice. Bar charts compare categories. Line charts show trends over time. Pie charts are only for showing parts of a whole (and even then, bar charts are usually clearer). Resize the chart, add a title, and you have a visual that communicates your data.
Saving and sharing
Save your workbook with Ctrl+S. The default format (.xlsx) works for most purposes. If you need to share with someone who does not have Excel, save as PDF (File, Export, Create PDF). For collaboration, save to OneDrive or SharePoint and share a link instead of emailing the file. This avoids version conflicts.
Next steps
You now understand the essentials. The next skills to learn are PivotTables (for summarizing large datasets), VLOOKUP or XLOOKUP (for looking up data across tables), and conditional formatting (for highlighting important values). Our [Excel training](/courses/microsoft-excel/) course covers all of these in a structured, hands-on format.