Master the Fundamentals of Excel-EN
Catégorie
Efficacité opérationnelle
Sous-catégorie
Bureautique
Code
DL-BUR003
Objectifs de formation
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.
Plan de formation
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
Langues
Anglais
Durée (Jours)
6
Sources
OpenClassrooms
