Catalog
details
Ajoutez votre titre ici
Ajoutez votre titre ici
Master the Fundamentals of Excel
Category
Efficacité opérationnelle
Subcategory
Bureautique
Code
DL-BUR003
Training Objectives
Use basic Excel functionalities. Set up a page layout in Excel. Manipulate your data in an Excel workbook.
Descriptions
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.
Formation Program
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
