Description

This Excel Level 2 simulation training replicates the software you are learning providing a realistic learning experience. Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions. Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.

What topics are covered in this Office 365 Excel Level 2 online course?

There are 6 modules in this course;

Cell Selection Techniques

• Select a Cell;
• Select Ranges of Cells;
• Select Columns;
• Select Rows;
• De-select Cells;
• Select Data Ranges;
• Select the Entire Worksheet.

Moving and Copying Data

• Understand Cut and Copy;
• Move Data in Worksheets;
• Move Data Between Worksheets;
• Move Data Between Workbooks;
• Use the Paste Options Smart Tag;
• Copy Data in Worksheets;
• Copy Data Between Worksheets;
• Copy Data Between Workbooks;
• Use the Office Clipboard.

Adding and Removing Cells

• Insert Columns and Rows;
• Delete Columns and Rows;
• Insert Cells;
• Delete Cells;
• Adjust Column Widths;
• Change Row Heights;
• Use Undo;
• Use Redo;
• Delete Cell Content.

Searching and Sorting Data

• Use Find and Replace;
• Search for Words;
• Identify Search Options;
• Use Find Next;
• Replace Single Occurrences;
• Use Replace All;
• Sort Data in Columns.

Cell Formatting

• Change Numeric Formatting;
• Modify Fonts and Sizes;
• Centre Text Across Columns;
• Align Data in Cells;
• Wrap Cell Text;
• Add Borders;
• Apply Text Attributes;
• Change Background Colours;
• Use Format Painter;
• Change Date Formatting;
• Clear Data and Formatting.

Using Multiple Worksheets

• Use Multiple Worksheets:
• Delete Worksheets;
• Insert Worksheets;
• Move Worksheets;
• Copy Worksheets;
• Rename Worksheet Tabs;
• Apply Colours to Tabs.