Tutoriels Excel
Des guides pas à pas sur les tableaux croisés dynamiques, les graphiques, la mise en forme conditionnelle, et plus encore.
How to Create a Pivot Table in Excel
How to create a pivot table in Excel: insert one from a table, add rows, columns and values, then group and refresh. Includes a free interactive practice lesson.
Data Validation in Excel: Rules, Dropdowns & Custom Formulas
Master Excel data validation: create dropdown lists, number rules, date constraints, error alerts, and dependent dropdowns to keep your data clean.
Conditional Formatting in Excel: Rules, Formulas & Color Scales
Learn Excel conditional formatting from basics to custom formula rules. Highlight cells, add data bars, color scales, and manage rules across your workbook.
Excel Charts: How to Create, Format, and Choose the Right Chart Type
Learn how to create Excel charts from scratch. Compare column, bar, line, pie, and scatter charts, then customize titles, axes, labels, and chart styles.
How to Freeze Panes in Excel: Rows, Columns and the Shortcut
Freeze the top row, the first column, or both in Excel so headers stay put while you scroll. Includes the Alt W F F shortcut, the Mac steps, Excel for the web, and why it sometimes freezes the wrong rows.
Power Query in Excel: Import, Transform, and Refresh Data Automatically
Get started with Excel Power Query: import CSV and Excel files, filter and reshape data, load results to a sheet, and refresh with one click when data changes.
How to Remove Duplicates in Excel (4 Methods)
How to remove duplicates in Excel: the Data tab tool, COUNTIF to find them first, UNIQUE for a clean list, and highlight-only. Practice the COUNTIF method live.
Array Formulas in Excel: From CSE Arrays to Dynamic Arrays
Master Excel array formulas: understand legacy CSE arrays and the modern dynamic array functions FILTER, SORT, UNIQUE, SEQUENCE, and XLOOKUP with arrays.
Excel Tables: Why You Should Use Ctrl+T on Every Dataset
Learn how Excel Tables (Ctrl+T) work: structured references, auto-expand, slicers, sorting, filtering, and when to convert back to a regular range.
How to Sort Columns in Excel
How to sort columns in Excel: A–Z from the Data tab, sort by two columns, and the SORT function that spills a live sorted list. Includes a free practice lesson.
Excel VBA Macros: Record, Write, and Run Your First Macro
Learn Excel VBA macros from scratch: show the Developer tab, record a macro with no code, run it, read the generated VBA, write a simple Sub yourself, and save a macro-enabled workbook safely.
Refresh Data in Excel: Shortcuts, Pivot Tables, and Power Query
How to refresh data in Excel: the Ctrl+Alt+F5 Refresh All shortcut, refreshing pivot tables and Power Query, the Mac ribbon method, automatic refresh on open, and fixing refresh errors.