Microsoft excel from beginner to expert

Explore how Microsoft Excel empowers data visualization and analysis with charts, pivot tables, forecasts, and a wide range of formulas, functions, and tips for practical data management.

Open Microsoft Excel online by signing in for free, or install the desktop version via Get Office; start from a blank workbook or templates, with cloud save and collaboration.

Master the Excel platform with a practical overview of sheets and cells, navigation via the ribbon, formatting, formulas, charts, data management, and ways to save, print, and share workbooks.

Learn to create your own Excel templates to streamline recurring data tasks, save them as templates, and reuse them via the personal templates gallery for monthly expenses.

Learn to customize the ribbons in Excel by enabling, adding and removing commands, creating and renaming groups with icons, and organizing tabs like home and developer for quick access.

Master the customizable status bar in Excel, which shows average, count, min, max, and sum for selected data. Explore zoom, view modes, and macro indicators to boost efficiency.

Learn to format cell size in Microsoft Excel, adjust row and column dimensions, auto-fit content, and insert or hide rows as needed.

Learn how to sort data in Excel, including sorting by product name or price, using A–Z or Z–A orders, color and custom sorts, and top or bottom filters.

Use the transpose function in Microsoft Excel to switch data from horizontal to vertical (or vice versa) on the same or another sheet, with sample names and amounts.

Learn how to adjust and auto-fit Excel cell sizes for clean, professional spreadsheets, including row and column sizing, inserting and hiding rows or columns, and handling data formatting.

Learn to use the format painter in Excel to copy a cell's formatting to other cells. Apply it across rows or sheets to normalize font, size, bold, underline, and color.

Learn to use freeze panes in Excel to keep the top row visible while scrolling, so you always know what each column represents.

Clean messy data in Excel by trimming extra spaces with the trim function, using a helper column, autofill, and paste special values to finalize corrections.

Learn to build Excel formulas using the equal sign, perform sums with manual entry or the sum function, and compute average, max, min, subtraction, division, multiplication, and density.

Master mean, median, mode, and standard deviation calculations in Excel from a data range, using the average, median, mode, and standard deviation functions and autofill to apply them across columns.

Explore 3D formulas in Excel to sum data across multiple sheets, using three methods to total year data from 2018 to 2021.

Learn to reveal all formulas in a workbook, inspect cell-specific formulas, and trace dependencies using keyboard shortcuts like Ctrl + ` and Ctrl + [ for Excel analysis.

Master cell fill series in Excel to automatically populate formulas and data, using relative and absolute references, drag fill, and auto-increment patterns to compute density from mass and volume.

Create and manage tables in Excel to organize data, apply table designs, add totals, and use filters, slicers, and auto-filled formulas across columns.

Explore quick analysis to quickly grasp data behavior and relationships in Excel, using charts, tables, pivot tables, and sparklines to preview and customize insights.

Learn to plot a simple Excel chart from a sales table. Select data excluding totals, insert a 2D column chart, and customize design, axis titles, and move to another sheet.

Add a second y-axis to an Excel chart by selecting data, inserting a line chart, and assigning one series to the secondary axis for clear months, losses, and profits.

Learn how to use excel's forecast function to predict future values based on historical data, choosing linear or exponential models and selecting x and y ranges for the forecast.

Format chart axes in Excel using the format axis toolbar, adjusting vertical and horizontal axis intervals, start and maximum values, and number formats for clear, professional visuals.

Master sparkline charts in Excel, including line, column, and win/loss types, to visualize data with a single axis. Learn to insert, customize colors and markers, and replicate charts for insight.

Hide and unhide rows, columns, cells, and tabs in Excel to control data. Password-protect workbooks and share only with contractors, or export as PDF to prevent access to hidden content.

Master pivot tables in Excel to dynamically summarize and analyze data, revealing patterns with fields like model, color, mileage, and price. Learn creation, placement, value settings, and slicer filtering.

Explore pivot charts and their dynamic, time-varying analysis of data, plotting product quantity and sales while manipulating fields, filters, and design options.

learn to use Excel's find and replace to locate and replace text or data, replace all occurrences, and apply formatting changes through format options and color substitution.

Master inserting hyperlinks in Excel to link documents, websites, and workbook locations—from PDFs and images to videos—while keeping files in the same folder and editing or removing links.

Learn to insert data validations in Excel, define criteria like whole numbers, ranges, dates, or text length, and customize input messages and error alerts to prevent invalid data.

Plot state populations on a map in Excel using dynamic maps, then customize colors, borders, projections, and orientation to compare 2010 and 2020 data.

Convert a pdf to an excel sheet by importing from pdf, selecting tables, and loading or transforming data with Power Query to create editable spreadsheets that refresh with the source.

Learn how to insert and customize headers and footers in Microsoft Excel, using page layout and page break preview, with templates, page numbers, date, time, and sheet details.

Master how to split full names into first and last names in Excel using Text to Columns with comma or space delimiters, via the Data tab.

Master 20 essential Excel shortcuts to speed up work, including save, print, convert data to tables with Ctrl+T, navigate with arrow keys, duplicate with Ctrl+D, and export with Ctrl+Shift+F+E.

Learn how to use the camera tool in Excel to pull data from one sheet to another, create live, linked captures, and print results from the quick access toolbar.

Learn to add background images in Excel using page layout or insert pictures from device, stock, or Bing search, and adjust visibility with transparency and print preview.

Convert an Excel spreadsheet to PDF using two or three methods: export to PDF, save as PDF, or print to PDF. Share the resulting file with friends, students, or others.

Learn to copy Excel data into Word with paste special, embedding an Excel worksheet object or a linked chart. Explore pasting as a picture for a fixed, non-editable view.

Learn to apply borders in Excel, including all borders and thick outside borders, and use draw border, border grid, erase border, and line color and style options to enhance clarity.

Learn how to password protect and unprotect Excel sheets and workbooks, including practical steps to edit and recover access to protected documents.

Create a drop down list in Microsoft Excel using data validation, define a source range, and enable in-cell dropdown with input messages and error alerts for consistent options.

Learn the art of printing in Microsoft Excel as a stepwise process, mastering print preview, page layout, orientation, print area, page breaks, gridlines, and margins for a professional printout.

Protect an Excel sheet and selectively unlock cells, enabling coworkers to edit only the unit price while keeping inventory IDs and descriptions locked.

Insert screenshots into Word, Excel, and PowerPoint using the built-in screen capture and screen clipping features. Learn to crop and place captured images directly in your documents.

Learn to create organizational charts in Microsoft Excel with SmartArt hierarchy, add officers and assistants, adjust styles and colors, and save the chart as PNG or JPEG.

Learn how to access Microsoft Excel online for free through Office 365 with a Microsoft account, start a blank page or templates, and collaborate, save, or download your work.

Master data movement in Excel with drag and drop across cells and columns, analyze data with quick analysis and charts, and use paste special to paste values instead of formulas.

Remove duplicates from selected data, learn flash fill, autofill, transpose data, and freeze panes to manage large spreadsheets in Excel.

Learn practical excel tips, including converting text to columns, applying conditional formatting, building if statements, using 3D referencing, and creating forecasts to predict future data.

Master advanced Excel tips, including viewing formulas, showing formulas instead of results, error handling, navigating with ctrl+arrow, and using maps and the PMT function for loan payments.

Master drag-and-drop data, analyze data with built-in tools, and use paste special to paste values without formulas. Auto fit columns and explore charts with the quick analysis tool.

Learn to insert screenshots in Excel, use isblank with if for missing data, convert data types, fetch live data from the web, and use the status bar for insights.

Explore essential Excel tips and tricks, including creating distribution charts, sorting data, using the choose and unique functions, and saving or editing graphical insights for analysis.

Explore Excel tips and tricks like using add-ins and the get ideas function to analyze data. Apply subtotals, max and second largest, sparklines, and slicers to filter by country.

Learn to connect Excel tables to Word with dynamic updates via embedded links, preview and adjust printing, create smart chart titles linked to cells, add subtitles, and hide charts.