Module 1 – Introduction to Python

• Overview of Python and its key applications in analytics and scientific computing
• Installing Python and choosing a development environment (IDLE, VS Code, or Jupyter)
• Getting started with the Python console and running your first scripts

Module 2 – Core Programming Concepts

• Understanding variables, data types, and type conversion
• Working with strings, numbers, and booleans
• Essential arithmetic and logical operations

Module 3 – Control Flow Essentials

• Writing conditional statements (if, elif, else)
• Using loops effectively (for, while)
• Mastering indentation and clean coding practices

Module 4 – Functions and Script Structure

• Defining and calling functions
• Passing arguments and returning values
• Organizing your code into clear, reusable blocks

Module 5 – Introduction to Object-Oriented Programming (Optional)

• Understanding objects and their role in Python
• Creating simple classes and instances

Module 6 – Working with Files

• Reading and writing text files
• Processing data line by line for real-world tasks

Module 7 – Practical Workshop

• Building a small end-to-end program combining variables, loops, and functions
• Personalized feedback and improvement tips

Introduction to the Excel Essentials Training

Module 1 – Get Started with Excel: Interface and Core Features

• Familiarize yourself with the Excel interface: Ribbon, Quick Access Toolbar, and menus
• Understand the structure of an Excel file: workbooks, sheets, and cells
• Manage data efficiently: auto-fill, freeze panes, and smooth navigation
• Boost your productivity with essential keyboard shortcuts and time-saving tricks
• Customize your workspace for a streamlined experience
• Create, name, and organize tabs to structure your work effectively

Module 2 – Simplify Calculations with Named Ranges

• Create custom names for cells or data ranges
• Navigate large spreadsheets easily using named references
• Manage and edit names using Excel’s Name Manager
• Insert named ranges into formulas for greater clarity and control

Module 3 – Build Professional Tables and Set Up for Printing

• Apply automatic formatting to improve table readability
• Create and reuse custom styles for a consistent design
• Use conditional formatting to highlight key data points
• Master sorting and filtering tools for data analysis
• Adjust cell formats for numbers, dates, currency, and text
• Set up your tables for clean, print-ready output (margins, orientation, headers)

Module 4 – Master Essential Excel Formulas

• Understand the difference between relative and absolute references
• Search, insert, and combine functions to automate calculations
• Work with foundational formulas: SUM, AVERAGE, MAX, TODAY
• Implement logical formulas (IF), text functions, and date calculations

That’s it, you’ve received your new promotion. Congratulations! Only one downside. With your new appointment, you have also taken on new administrative responsibilities. Thus, you now have to manipulate spreadsheets. Before, you could afford to do everything by hand, but now the amount of documents to process is far too great for that. Microsoft thought of people like you when bringing Excel to market.

Excel: What is it?

So what is Excel? It is a professional spreadsheet software. In other words, you can manage simple and complex calculations there, display a multitude of data and inventory them in pivot tables. You can do a lot more, but we’ll get to that. Microsoft, father of Windows, created Excel. This software is part of the Office suite, which also includes the well-known Word.

On the other hand, while PowerPoint specializes in presentations and slides or Word specializes in writing, Excel has been the authority on the market when it comes to numbers for almost 35 years.

Thus, once you have mastered this software, you can use Excel to classify your tables and perform your calculations quickly, efficiently and without mistakes. Of course, we are well aware that accessing Excel can be daunting. But at Doussou Formation, our trainers are there to teach you how to use this software. From basics to more complex macros.

Excel: What are the benefits?

To start, let’s talk about those famous macros we talked about a line ago. This is one of the most interesting functions of the Office suite. To define them, macros are programmed commands to automate repetitive tasks. Simply put, macros are shortcuts that make your life easier. It goes without saying that you will be happy to save time with these tools at your disposal.

Another definite advantage of Excel is its performance. Other spreadsheet software exists on the market. There are even free options. But in terms of computing power and tools available to you, Excel wins hands down. If you only have to ride 1 km to get to work, a bicycle will do. But if you have to pull a ton load, you’ll need a nice big truck with flames. Excel is that truck with the flames. And see Doussou as your friend who teaches you to drive.

Average, rounding, sum, and/or. These are all formulas that can be used with Excel. This is the basis. But Excel can also help you with linear calculus, algebra, or graphs. And when Excel is not embellished with a function, there is probably a macro to do it.

Excel: The course formula at Doussou Formation

As mentioned above, we will accompany you from the start to the finish line. More specifically, we adopt a way of teaching specific to your needs and desires. At the base of the training, we will see the fundamentals. Then we will study the reference names, the layout, the available formulas, the graphic representations and then the pivot tables. Finally, you will be ready to learn your first macros.

Do not hesitate to register or ask us for more information if you are a person who wishes to ensure that you have a solid foundation in the concepts of Excel spreadsheet software. Finally, practical exercises will allow you to consolidate your new knowledge.