This course is suitable for absolute beginners who aren't familiar with Excel. However, this course will also allow you to develop your skills even further if you already have a good understanding of Excel’s basic features. If this applies to you, you can go directly to part three.

Required tools: Excel 2019

By the end of this course, you’ll be able to:

Use basic Excel functionalities.
Set up a page layout in Excel.
Manipulate your data in an Excel workbook.

Description

Excel is one of the most widely used applications globally. Those of us who use it every day understand why! Excel enables you to handle and format large amounts of data with ease.

This course will help you get used to using the software if you're a beginner, formatting your data so that it can be easily read, and manipulating the data using formulas, sort functions, pivot tables, etc. The course will also prepare you for the TOSA Excel basic level certification.

You’ll see that using Excel isn't very complicated and, soon, you won’t know how you managed without it!

Why not create an Excel file and process the data along with me during the course? I’ll support you at every stage and you’ll be able to practice as you learn.

PART #1 - USE BASIC EXCEL FUNCTIONALITIES

1. Get the Most out of This Course

2. Take Your First Steps in Excel

3. Create Your First File

4. Enter and Modify Data

5. Copy Data

6. Create and Copy Formulas

7. Practice Entering Data in Excel

Quiz: Use Basic Excel Functionalities

PART #2 - WORK WITH YOUR EXCEL FILE

1. Manipulate Rows and Columns

2. Work With Tabs

3. Set up the Page layout

4. Use Conditional Formatting

5. Use Filtering and Sorting Features

6. Practice Setting up Your Page Layout in Excel

Quiz: Set up a Page Layout in Excel

PART #3 - MANIPULATE DATA IN EXCEL

1. Perform Calculations Using Functions

2. Allow or Restrict Types of Data

3. Create Pivot Tables

4. Create Charts

5. Practice Processing Data in Excel

Quiz: Manipulate Data in Excel

Microdoing & Survey

Besoin d'aide ou de conseils personnalisés?

Explorez un monde de connaissances variées grâce à notre catalogue de cours. Notre équipe est là pour vous accompagner à chaque étape. Contactez-nous dès aujourd'hui et concrétisez vos ambitions éducatives !

Building Titan VI Zone Galaxy Andraharo 101 Antananarivo Madagascar

digital.learning.axian@axian-group.com