Microsoft Excel Intermediate Badge
The recipient has earned an intermediate badge in Microsoft Excel 365/2021.
Skills / Knowledge
- Microsoft Excel
- Configure content for collaboration
- Prepare workbooks for collaboration
- Insert and format graphic elements
- Create and modify charts
- Create and modify PivotTables
- Use and configure language options
- Navigate within workbooks
- Modify tables
- Perform data analysis
- Perform logical operations in formulas
- Format charts
- Create and modify PivotCharts
- Define and reference named ranges
- Format worksheets and workbooks
- Manipulate data in worksheets
- Format cells and ranges
- Filter and sort table data
- Format and validate data
- Apply advanced conditional formatting and filtering
- Customize options and views
- Insert references using formulas and functions
- Format and modify text using formulas and functions
- Look up data by using functions
- Calculate and transform data with formulas and functions
- Manage worksheets and workbooks
- Create and format tables
- Import data into workbooks
- Insert and modify form controls
- Install and manage add-ins
- Create and run macros