What is covered:

• Create a workbook

• Save your workbook to OneDrive

• Analyze and format your workbook

• Collaborate across the group

What is covered:

• Create a new workbook

• Insert of delete a worksheet

• Move or copy worksheets or worksheet data

• Print a worksheet or workbook

• Use Excel as your calculator

What is covered:

• Insert/delete rows or columns

• Select cell contents

• Freeze panes to lock rows and columns

• Hide/show rows or columns

• Filter for unique value or remove duplicate value

What is covered:

• Move/copy cells and cell content

• Change column width or row height

• Find/replace text and numbers on a worksheet

• Merge and unmerge cells

• Import and export text (.txt or .csv) files

What is covered:

• Available number formats in Excel

• Conditional formatting

• Align or rotate text in a cell

• Change the format of a cell

• Copy cell formatting

What is covered:

• Overview of formulas in Excel

• XLOOKUP, VLOOKUP, SUM function, COUNTIF function, IF function, IFS, SUMIF, SUMIFS, MATCH