MCRO 854V - Office 365 Excel Bootcamp 2: Microsoft Office Career Accelerator
Course Description
Strengthen your excel skills by discovering the ‘magic’ of excel.. Reduce and ensure integrity of data by linking contents between worksheets and workbooks. Prevent workbook input errors by implementing protection. Control your data outputs using Power Query and analyze via Pivot tables and visualizations.
Learner Outcomes
- Use logical functions including the IF, COUNTIF, SUMIF, functions, and conditional formatting
- Create text- and graphic-based hyperlinks to other files and web sites
- Link and group worksheets and workbooks
- Employ date and time functions
- Design operational databases
- Create and maintain a table/database
- Find and sort data in a table/database
- Filter a table/database
- Validate data entry – control data integrity
- Produce Pivot tables and visualizations using Charts and slicers
- Customize printing options
- Decrease workload - build templates
- Add security
- Use the VLOOKUP function or equivalent (Xlookup)
Prerequisites
MCRO 852V Office 365 Excel Bootcamp 1: Microsoft Office Career Accelerator or equivalent skills plus strong file management skills. Word Level 1 or equivalent skills recommended.
Applies Towards the Following Certificates
- Office 365 Career Accelerator Micro-Credential : Office 365 Career Accelerator Micro-Credential
We are especially grateful to live, work, and play on the traditional territories of the Lekwungen (Songhees, Esquimalt), Malahat, Pacheedaht, Scia'new, T'Sou-ke, and WSÁNEĆ (Pauquachin, Tsartlip, Tsawout, Tseycum) peoples. We acknowledge their welcome and graciousness to the students who seek knowledge here.
