Link
Search
Menu
Expand
Document
1 Introduction
2 Getting started with Excel
2.1 Discovering Excel features
2.2 Creating your spreadsheet
2.3 Saving your work
2.4 Working with several people at the same time
2.5 Protecting your data
2.6 Sharing files
2.7 Managing file metadata
2.8 The Excel Table
3 Data cleaning
3.1 Formatting a database
3.2 Conditional formatting
3.3 The most common formulas for data cleaning
3.4 Identifying duplicates
3.5 Identifying extreme values
3.6 Identifying missing values
3.7 Summary of Data Quality Control
4 Data Analysis
4.1 Conducting analyses with the data analysis tool pack
4.2 Calculating the frequency of a statistical series
4.3 Descriptives statistics
4.4 PivotTable
4.5 Correlation analysis
5 Visualization
5.1 A few basic essentials, graphic semiology
5.2 Creating a chart
5.3 Creating a dashboard
5.4 Tips and tricks
6 Going further
6.1 Several advanced formulas
6.2 Time-saving shortcuts
6.3 A few useful tips
6.4 Related PivotTables
7 Going (even!) further
7.1 Arrays formulas
7.2 Solver
7.3 PowerPivot
7.4 PowerQuery
7.5 Geeks' Corner
Excel toolbox
fr
7 Going (even!) further
7.4 PowerQuery
7.4 PowerQuery
04-Oct-2022
1 min
Share this page
04-Oct-2022
1 min
04-Oct-2022
1 min