MCRO 852V - Office 365 Excel Bootcamp 1: Microsoft Office Career Accelerator

Course Description

Boost your Excel skills by building timesaving, functional and effective workbooks for real life situations. These include Invoices, lists, budgets, payroll, cashflow, projections of expenses and revenue. Share workbooks in the cloud and discover basic AI functionality, generating charting and extract or join data using Flashfill.

Learner Outcomes

•  Understand the Excel interface (terminology)

  •     Create mathematical Formulas

  •     Utilize the Functions SUM, MIN, MAX, AVERAGE, COUNT, TRIM, UPPER, LOWER

  •     Use Auto fill and Flashfill which uses machine-learning techniques to automatically reformat data based on an examples

  •     Modify layouts for columns and rows

  •     Construct worksheets that effectively, manage formulas and functions, using autofill with absolute/relative referencing.

  •     Move, copy and paste content using special paste functionality

  •     Design effective Databases using Tables

  •     Understand the order of mathematical operations - BEDMAS

  •     Format and control layout for readability for print or PDFs.

  •     Generate charts

Applies Towards the Following Certificates

• Office 365 Career Accelerator Micro-Credential : Office 365 Career Accelerator Micro-Credential