Learn Microsoft Excel for Beginners

Learn how Excel uses XLSX as the modern file format, view file extensions, and navigate the home, new, and open tabs, plus access files via file explorer and OneDrive.

Navigate the Excel interface, mastering the quick access toolbar, ribbon, and backstage file view. Identify key elements like the name box, insert function, formula bar, worksheets, and the status bar.

Discover advanced excel ui topics, including contextual menus, the mini toolbar, and right-click behaviors. Learn to customize the ribbon with new tabs, groups, and commands, and set themes and backgrounds.

Learn the basics of data input in Excel, from opening a blank workbook to entering values in cells, and navigating with enter, tab, shift+enter, and arrow keys.

Explore the four data types in Excel—number, text, logic, and error—and how formatting transforms numeric and text data, including fractions and division handling.

Explore the data structure of Excel, detailing workbooks, worksheets, columns, rows, and cells; learn to rename, organize, and navigate sheets while understanding limits on cells, columns, and rows.

Master Excel navigation using keyboard, mouse, and UI methods to scroll and zoom; jump with Ctrl+arrow to data, use page up/down, and zoom via Ctrl+scroll or the zoom slider.

Learn how to edit data in Excel using the formula bar or direct cell editing, and master AutoFill to quickly populate months, numbers, and sequences.

Learn to create custom AutoFill lists in Excel by building or importing Indonesian day and month names, social media terms, and seasons, using the options and import features.

Master Excel undo and redo with Ctrl+Z and Ctrl+Y, note undo does not cover all actions like worksheet creation or deletion, and save with save as and save.

Master Excel formulas. Use cell references like B2 and B3 to compute profits (incomes minus costs) and extend formulas to months with copy-paste or auto-fill.

Master the basics of Excel functions, focusing on the sum and average functions. Explore manual formulas, AutoSum, and keyboard shortcuts like Alt+= to compute totals and averages efficiently.

Learn how XLOOKUP replaces VLOOKUP and HLOOKUP, using a lookup value, lookup array, and return array to find product names by ID.

Master moving and duplicating data in Excel using cut, copy, and paste with four methods: ribbon menu, contextual menu, keyboard shortcuts, and cell selection, covering single and multiple cells.

Master six cell reference types—single-cell, range, column, column-range, row, and row-range—through practical examples like D10 and C2:E10, and learn using formulas and keyboard shortcuts for selection.

Explore relative and absolute cell references in Excel, learn to convert references with dollar signs and F4, and use show formulas and AutoFill to verify results.

Master mixed cell references in Excel by balancing absolute rows with relative columns using F4 and Ctrl+Enter, then apply the ROUND function with SUM to compute weighted final grades.

Learn to create external worksheet references within the same workbook using sheet names and cell addresses, use sum and average across worksheets, quote spaced names, and apply quick auto-fill.

Learn to reference data in another workbook using external workbook references, switching between year 2021 and year 2020, and adjusting cell references from absolute to relative for correct autofill.

Learn to create named references in Excel, assign workbook or worksheet scope, follow naming rules, and manage names with name manager, using shortcuts such as F3 and Alt+=.

Learn to apply cell formatting in Excel, including number, date, text, and border formats, and understand general formatting, automatic number formatting, and that formatting changes appearance without altering the data.

Learn how to apply and customize Excel number formats, including number, accounting, currency, and percentage, and master the Format Painter to copy formatting across cells.

Learn how to create custom formatting for numeric data in Excel, apply accounting style, define conditional text like up, down, same, and add colors using named colors or color codes.

Explore how Excel stores date data as serial numbers since 1900 and formats them. Note that pre-1900 or post-9999 dates become text, and Windows region settings affect input and display.

Learn advanced date formatting in excel using the format cells window, apply date presets, or build custom formats with codes like YYYY, MMMM, and D, plus locale options.

Format text in Excel using the Home menu, mini toolbar, or the format cells window. Apply font choices, size, bold, italic, underline, and partial formatting like superscript or subscript.

Learn to change text color in Excel using the mini toolbar, ribbon, or format cells, and explore color categories—automatic, theme, standard, and custom RGB/HSL.

Master filling colors in Excel: set background colors, apply gradients or patterns, and remove fills. Use hexadecimal color codes to transfer colors from other software via the format cells window.

Learn to set borders in Excel using the borders drop-down, draw border and draw border grid modes, and the format cells border tab, while understanding gridlines and printing.

Master advanced border formatting in Excel by using borders, draw border, and format cells to apply line styles and colors to selections.

Learn to resize columns and rows in Excel using drag on the lines, the pop-up menu, or the Home format options, and apply AutoFit to fit contents.

Master text position and orientation in Excel by adjusting horizontal and vertical alignment, using wrap text, and applying rotation options from the Home ribbon and Format Cells window.

Learn how to use and manage cell styles in Excel, including presets for fill color, borders, text and number formatting, and how to create, modify, delete, and merge styles.

Learn to organize Excel table structures by inserting and deleting rows, columns, and cells, using shift options and drag-and-shift techniques to preserve adjacent data.

Learn how to hide and unhide columns and rows in Excel, using right-click commands, selection methods, and click-drag width adjustments to manage large tables.

Master merging and splitting cells in Excel, manage text overflow, and use merge and center, merge across, and unmerge commands while understanding how data survives in the top-left cell.

Learn to insert images in an Excel worksheet using insert picture, stock images, and online pictures, plus copy and paste and drag and drop, with initial cell reference.

Compare insert, link to file, and insert and link methods for importing images in Excel, showing when data is embedded or linked and risks of broken links or outdated images.

Learn to transform pictures in Excel by moving, rotating, and scaling with precision using control points, the picture format pane, and snapping with Alt and Shift.

Learn to manage objects in Excel by locking pictures to cells, choosing move and size with cells or not, and applying depth sorting with bring forward and send to back.

Learn to adjust overall and selective image transparency, remove backgrounds, and crop using shapes and aspect ratio with fill or fit options in Excel.

Learn to create shape objects in Excel, adjust fill and outline colors and weights, and explore primitive versus editable shapes with edit points and dynamic snapping for diagrams.

Learn to create and position shapes in Excel using lock drawing mode, modifier keys (Shift, Alt, Ctrl), and alignment and distribution tools for precise, efficient diagram layouts.

Learn Microsoft Excel for beginners demonstrates editing shapes with edit points, adding and deleting points, adjusting handles and segments, and switching between smooth, straight, and corner modes.

Create and format text boxes attached to shapes in Excel for visuals, using insert shapes or word art, and control text flow, alignment, margins, and shape formatting.

Learn to apply and customize effects and styles for shapes and images in Excel, including shadows, reflections, and glows, using the format shape and format picture panels.

Learn how to group, ungroup, and regroup objects in Excel, including shapes, text boxes, and images, and manage nested groups using the selection pane and hierarchy.

Explore how to create, edit, and customize SmartArt diagrams in Excel, including using the text pane, managing data hierarchy, and transforming or resetting graphics for clear, dynamic visuals.

Create charts in Excel by selecting data with headers, then use insert, the pop-up button, or Alt+F1 and F11 to generate chart types, switch row/column, and keep charts updated automatically.

Learn to transform and manage chart objects in Excel, adjust depth sorting and visibility, group charts, and edit data ranges with data selection, filters, and the select data source window.

Learn to customize chart appearance in Excel using color and style presets, adjust chart elements, and use format options to tailor bars, titles, axes, and legends.

Learn how sparklines in Excel bind to cells to visualize trends, create line, column, or win loss sparklines from data, duplicate and group them, customize appearance, and control axis clipping.

Explore the 7 paste types in Excel, from standard paste to values, formatting, and link options, and learn how each preserves or excludes formatting, borders, and formulas.

Explore notes and comments in Excel, including creating and editing notes via the review menu or shortcuts, formatting note colors, and managing threaded comments when files are saved on OneDrive.

Explore the find and replace tools in Excel, using find, find next, and find all, while restricting results to a selected range and matching entire cell contents or case.

Explore how to use Excel's find and replace to search and swap data and formatting, including replace all, match case, and formatting changes (for example replacing LLC with PT).

Sort a data table by selecting the reference column and choosing smallest to largest or largest to smallest, with custom lists and multi level sorting for data integrity.

Learn how to use Excel filters to hide or display data by criteria, with toggle filters, text and date filtering, multi-level filtering, and copying only visible results.

Discover how to access the freeze panes feature from the view menu to keep the top row, first column, or both static, and how to unfreeze when scrolling.

Convert a regular cell range into an Excel table, use format as table or Ctrl+T, and apply headers, sorting, filtering, and easy resizing.

Explore advanced Excel table features, including header and total row options, banded rows, and naming tables, plus how to select, style, and manage tables for PivotTables.

Learn the basics of pivot tables in Excel by creating a pivot table, organizing fields into rows, columns, and values, and managing the pivot table on a dedicated worksheet.

Create pivot tables from a data table using the recommended models, set rows and columns, switch GPA to average, and apply filters or slicers to view country and gender insights.

Explore PivotTable design in Excel by adjusting the fields layout, sorting, subtotals and grand totals, and selecting report layouts, styles, field headers, and plus-minus options.

Discover how to connect an Excel table to a PivotTable, update and refresh data efficiently, and use named tables to automatically reflect changes in the PivotTable.

Master conditional formatting basics in Excel by creating, editing, and deleting rules, exploring style stacking, and managing thresholds to highlight values like prices over 200.

Learn to create custom conditional formatting in Excel, using the equal to rule to flag zero stock, and apply a custom format with fill color and borders.

Explore advanced conditional formatting in Excel, using 3-color gradients, data bars, and icon sets across cell ranges; manage rules, apply top-bottom, average, and unique and duplicate formats.

Learn how to manage overlapping conditional formatting rules in Excel by stacking rules, adjusting their order, and using stop if true to control which formats apply.

Learn to apply conditional formatting with graphics in Excel, using data bars and icon sets to visualize values, apply thresholds, and control display of bars and icons.

Learn how the active cell in Excel differs from selected cells, how to move it with Enter, Tab, Shift, and Ctrl+click, and why top-left positioning matters for conditional formatting formulas.

Learn to apply conditional formatting with formulas in Excel, using two rules to highlight totals above 2000 and color rows when stock is 5 or below (AND).