Excel For Beginners & Refresher For All

Open Excel and land on the start screen showing recent files and templates; select a blank workbook or preview calendars, budgets, invoices, balance sheets, and other templates.

Learn to navigate Excel by clicking cells and using the name box to jump to any cell, such as C6 or F8, with each cell having a unique name.

Explore how an Excel file acts like a notebook with multiple sheets, add and rename sheets, and see how cells such as C3 differ across sales and expenses sheets.

Navigate a large worksheet using arrow keys for one-cell moves, zoom with the plus icon, and jump to the top, bottom, or first/last column with control plus arrows.

Navigate instantly through your spreadsheet with control home to reach A1 and control end to the last data cell, then format dates and auto-fit columns.

Enter quarterly sales data for products and adjust column width by dragging borders or double-clicking between columns to auto fit, ensuring full names and no wasted space.

Learn how Excel distinguishes text from numbers by left and right alignment, adjust alignment and indentation, and convert numbers stored as text back to numeric values.

Explore right-click menus in Excel to insert a column, select entire column, and create a serial number, then fill 1, 2, 3 with down arrows.

Master flash fill to quickly populate months, years, and serial numbers by entering two examples and dragging, usable in both vertical and horizontal directions.

Learn to adjust row height and column width in Excel for clearer data visibility. Use auto fit and manual resizing to keep key labels such as profit forecast readable.

Learn to insert a date and time stamp in Excel using keyboard shortcuts: ctrl semicolon for today's date, and ctrl shift semicolon for the current date and time.

Master cut, copy, and paste within a cell in Excel using control X and control V, then expand the value by double-clicking to fit visibility.

Select the area you want to center, click merge and center button on the home tab, and the cells become a single centered cell; click again to restore separate cells.

Discover the benefits of saving files in the cloud, including easy cross-device access and shareable access for colleagues. Cloud backups protect your work even if your computer crashes.

Learn to change worksheet tab colors in Excel to organize sheets; right-click the tab, choose tab color, and pick dark or light colors that adjust font visibility for easy navigation.

Rearrange, move, and copy worksheets in Excel by dragging with the black pointer or using the right-click Move or Copy option. Create duplicates before changes and delete sheets when needed.

Use Excel as a calculator in each cell to perform addition, subtraction, multiplication, and division (including complex calculations) with equal signs, and view formulas in the formula bar.

Learn how to use built-in Excel functions for quick calculations like total, grand total, average, min, and max without writing long formulas, including how to drag and apply across cells.

Discover how to use inbuilt Excel functions, like sum, to compute totals, averages, and extremes without long formulas. Use autosum to quickly sum ranges for accurate results.

Learn to count salespersons with built-in Excel functions, including the sum, average, maximum, minimum, and count functions, and use the show formula toggle to view or hide formulas.

Learn how relative referencing changes when copying formulas and how absolute referencing with dollar signs keeps cells like C4 fixed, preventing errors when the bonus rate updates to 15%.

Master vlookup in Excel by using exact match, absolute references, and selecting the correct column to retrieve item names and prices from a pricing table.