Microsoft Introductory Certificate
The recipient has earned an introductory certificate for Microsoft PowerPoint 365/2021, Excel 365/2021, Word 365/2021, and Access 365/2021.
Skills / Knowledge
- Configure form controls
- Configure report controls
- Create and modify table fields
- Create and run macros
- Create and run queries
- Create modules
- Create tables
- Format forms
- Format reports
- Manage macros
- Manage modules
- Manage table records
- Manage table relationships and keys
- Manage tables
- Modify database structure
- Modify macros
- Modify queries
- Print and export data
- Use SQL and VBA
- Apply advanced conditional formatting and filtering
- Calculate and transform data with formulas and functions
- Configure content for collaboration
- Create and format tables
- Create and modify charts
- Create and modify PivotCharts
- Create and modify PivotTables
- Customize options and views
- Define and reference named ranges
- Fill cells based on existing data
- Filter and sort table data
- Format and modify text using formulas and functions
- Format and validate data
- Format cells and ranges
- Format charts
- Format worksheets and workbooks
- Import data into workbooks
- Insert and format graphic elements
- Insert and modify form controls
- Insert references using formulas and functions
- Install and manage add-ins
- Look up data by using functions
- Manage worksheets and workbooks
- Manipulate data in worksheets
- Modify tables
- Navigate within workbooks
- Perform data analysis
- Perform logical operations in formulas
- Prepare workbooks for collaboration
- Summarize data visually
- Troubleshoot formulas
- Use advanced date and time functions
- Use and configure language options
- Animate slide content
- Apply and configure slide transitions
- Change presentation options and views
- Configure and present slide shows
- Configure print settings for presentations
- Create and modify macros
- Format text
- Insert and format images
- Insert and format SmartArt graphics
- Insert and format tables
- Insert and manage media
- Insert and modify 3D models
- Insert and modify charts
- Insert links
- Insert slides
- Modify slide masters, handout masters, and note masters
- Modify slides
- Order, align, and group slide content
- Prepare presentations for collaboration and distribution
- Add and manage comments
- Add text to graphic elements
- Create and configure document sections
- Create and manage bibliographies
- Create and manage footnotes and endnotes
- Create and manage indexes
- Create and manage paragraph, character, and table styles
- Create and manage tables of contents
- Create and manage tables of figures
- Create and modify building blocks
- Create and modify lists
- Create custom design elements\
- Delete illustrations and text boxes
- Find, replace, and paste document content
- Format documents
- Format illustrations and text boxes
- Format text and paragraphs
- Insert and delete text
- Insert illustrations and text boxes
- Inspect document for issues
- Manage change tracking
- Manage documents and templates
- Manage forms, fields, and controls
- Modify graphic elements
- Navigate within documents
- Perform mail merges
- Prepare documents for collaboration
- Save and share documents