Excel training - Introduction - Acquiring the basics

Description

Whether you are a beginner or looking to strengthen your skills in Excel, this 2-day training offers a comprehensive hands-on experience with the essential software for data management and advanced calculations. Excel is a powerful tool to enhance your productivity, automate repetitive tasks, and analyze information efficiently. This training is designed to provide you with all the foundational and advanced techniques necessary to use Excel in a professional and optimized manner.

Why Choose This Training?

Personalized Guidance:

Our certified instructors will guide you throughout the program. You will benefit from personalized support and practical workshops to directly apply the knowledge gained.

Accelerated and Structured Learning:

In just 2 days, you will progress from a beginner level to mastering key Excel features, including creating tables, managing formulas, presenting data, and visualizing it through charts. You will learn to work quickly and efficiently.

Hands-on Workshops Based on Real-World Scenarios:

Each half-day session includes practical workshops where you will work with existing tables, apply formulas, and create charts tailored to real-life professional situations.

Boost Your Productivity:

The training covers essential tips to save time in your daily work. You will learn how to automate certain tasks, customize your spreadsheets, and make your data more readable through impactful formatting and charts.

Comprehensive and Evolving Content:

In addition to covering the basics (workbook management, data entry, formulas), the training also addresses more advanced aspects such as working with data tables, dynamic filters, conditional formatting, and graphic tools.

Optional Certification:

The optional Excel certification allows you to officially validate your skills, a major asset for boosting your employability and demonstrating your expertise to employers or clients.

By the End of This Training, You Will Be Able To:

  • Efficiently manage your spreadsheets, whether for large databases or simple reports.
  • Create clear and impactful charts to better visualize your data.
  • Apply advanced Excel functions to automate tasks and increase productivity.
  • Configure your tables for optimal printing, even for large documents.

Don’t miss this opportunity! Sign up today to master Excel in just 2 days. Whether you want to enhance your skills or obtain a recognized certification, this training will help you fully exploit Excel's potential in your professional environment.

Day 1: Getting Started with Excel and Basic Calculations

Morning: Introduction to Excel

  • Exploring Excel’s Environment
    Understand the basics of spreadsheets and explore the Excel interface.
    Learn to navigate the File tab to open, create, and manage workbooks.
  • Managing Windows and Workbooks
    Techniques for moving between different sheets and windows.
    Entering and modifying data in a cell, undoing and redoing actions.
  • Customizing Sheets
    Rename a sheet, change tab colors, insert, delete, and hide sheets.
    Use the group feature to manage multiple sheets at once.
  • Using Help Tools
    Discover the search function to quickly find features or get help.
  • Practical Workshop:
    Open an existing spreadsheet, navigate between sheets, and apply initial customizations.

Afternoon: Performing Basic Calculations

  • Creating and Using Formulas
    Learn how to enter simple formulas, calculate sums, percentages, and other statistics.
    Use absolute and relative references in formulas to make copying calculations easier.
  • Presenting Data
    Format data using numeric styles and custom fonts.
    Apply themes and styles to standardize presentation.
  • Practical Workshop:
    Use basic functions (SUM, AVERAGE) in a table, then format the data to improve readability.

Day 2: Advanced Sheet Management and Data Visualization

Morning: Cell Management and Printing

  • Manipulating and Organizing Cells
    Adjust column widths, row heights, and insert or delete rows and columns.
    Use advanced features like merging cells and managing text orientation.
  • Quick Formatting
    Quickly apply a cell’s formatting to others using the format painter.
    Manage cells to display multiple lines of text or copy calculation results.
  • Preparing for Printing
    Learn to set up the layout, define print areas, and insert headers and footers.
    Know how to hide unnecessary elements for optimal printing of a table.
  • Practical Workshop:
    Fit a table onto one printed page and add a company logo to the header.

Afternoon: Data Visualization and Using Tables

  • Creating Simple Charts
    Use tooltips to choose the right type of chart.
    Create, move, and customize a chart (titles, colors, etc.).
  • Managing Data Lists (Tables)
    Create data tables and use features like automatic sorting and filtering.
    Use Flash Fill and automatic calculations within a table.
  • Applying Dynamic Filters
    Use slicers for dynamic filtering and apply conditional formatting.
  • Practical Workshop:
    Create charts from an existing table and convert a list into a table with sorting and filtering capabilities.
  • Beginners: If you have never used Excel or have only limited experience, this training will provide you with all the necessary basics.
  • Intermediate Users: You already have a grasp of some Excel functions but want to deepen your skills, especially in data management and chart creation.
  • Professionals: If you work in finance, project management, marketing, or any other field that requires data analysis, this training will equip you with essential tools to optimize your daily tasks.

This training has been designed to be accessible to a wide audience, including beginners. However, it is recommended to meet the following prerequisites to get the most out of this session:

Basic Computer Knowledge:

You should be comfortable using a computer, including handling a mouse, keyboard, and navigating an operating system (Windows or Mac). These skills will allow you to focus on learning Excel without being hindered by basic computer operations.

Access to a Computer with Excel:

It is essential that you have a recent version of Microsoft Excel (2016, 2019, or Office 365) installed on your computer to follow the practical exercises and directly apply the skills learned during the training.

Basic Math Knowledge:

A basic understanding of mathematical concepts such as addition, subtraction, percentages, and simple statistics is recommended. This will help you more easily grasp formulas and calculations in Excel.

Ability to Follow Online Training (if applicable):

If you are taking the training online, it is important to have a stable internet connection and a quiet, conducive learning environment. A headset and microphone may also be useful for interacting with the trainer and asking questions.

  • Understand the interface and main features of Excel.
  • Perform simple and advanced calculations.
  • Customize sheets and workbooks for optimal use.
  • Automate tasks with formulas, macros, and pivot tables.
  • Visualize data using charts and conditional formatting.

Training Details

  • Reference : COT-FEIA02
    Training location : Cotonou
    Date :
    Duration : 2 Days (14 Hrs)
    Price : FCFA250,000

Currency

Training location

We design, build and support digital products for clients who want to make a positive impact in their industry. Creative with technology, we develop great solutions to help our clients grow and especially by strengthening our relationships based on continuous improvement, maintenance, support and hosting services.

Follow us