At the end of the training, participants would be able to:Get started with Microsoft Excel. Perform calculations. Modify a worksheet. Format a worksheet.Print workbooks. Manage workbooks.

Beginners and Novices Office Workers Administrative Staff Students and Educators Small Business Owners

MIM1004 Microsoft Excel 365 - Beginner Level (1 Day)

Description

MIM1004 Microsoft Excel 365 – Beginner Level (1 Day)

Overview

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This program can be tailored to your specific business needs.

A little bit of personalization goes a long way. Ask us for a no-obligation Training Needs Analysis (TNA) so we can tailor this, or any other CSG program to meet your learning outcomes.

Objectives

At the end of the training, participants would be able to:

Get started with Microsoft Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.

Duration

1 Day

Target Audience

Beginners and Novices
Office Workers
Administrative Staff
Students and Educators
Small Business Owners

Modules:

Module 1: GETTING STARTED WITH EXCEL

Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Excel Online
Topic E: Enter Cell Data
Topic F: Use Excel Help

Module 2: PERFORMING CALCULATIONS

Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

Module 3: MODIFYING A WORKSHEET

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

Module 4: FORMATTING A WORKSHEET

Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Colors, Borders, and Styles
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates

Module 5: PRINTING WORKBOOKS

Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers

Module 6: MANAGING WORKBOOKS

Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties

MIM1004 Microsoft Excel 365 – Beginner Level (1 Day)

Description

MIM1004 Microsoft Excel 365 – Beginner Level (1 Day)

Modules:

Program Methodology

Choose a Training Partner that Stays Invested.

Tell Us What You Need, We’ll Make it Happen

MIM1004 Microsoft Excel 365 – Beginner Level (1 Day)

Description

MIM1004 Microsoft Excel 365 – Beginner Level (1 Day)

Modules:

Program Methodology

Choose a Training Partner that Stays Invested.

Tell Us What You Need, We’ll Make it Happen

Welcome Back

Sign In