Excel-lence

(+216) 71603370
Centre El Khalil , Bureau 141, 2010 Manouba
b.belloumi@excel-lence.com
Acquire an in-depth mastery of Excel to propel your professional career!

Mastery of advanced Excel opens the door to a wide range of professional opportunities, allowing you to manipulate complex data with ease and precision. With strong Excel skills, you will be able to enhance operational efficiency, make informed decisions based on reliable data, and achieve remarkable results in any field of business. Join our advanced Excel training program and give your career a decisive boost today!

Formation Microsoft Access
About the Advanced Excel Program
Explore the Depths of Data Management and Analysis
Mastery of Data Management and Optimization of Operations
Advanced Text and Date Manipulation and Analysis
Implementation of Pivot Tables and Intuitive Controls
The details of the Advanced Excel training
    • Workbook Links Management:
    In this section, learners will learn how to create, modify, and break links between different Excel workbooks, enabling them to more effectively manage data from multiple sources.
    • Creation of Sheet and Workbook Templates:
    Learners will discover how to create reusable templates to expedite the process of creating new workbooks and sheets. This can be useful for repetitive or standardized tasks.
    • Utilizing Microsoft Excel Templates:
    This part will cover the use of predefined templates in Excel provided by Microsoft, allowing learners to leverage pre-designed layouts and features to expedite their work.
          • Advanced Filters:
        Learners will learn to apply complex filters to sort, filter, and analyze large datasets, focusing on multiple criteria and advanced operations.
          • Data Conversion:
        This part will cover data conversion between different formats, enabling learners to integrate information from various external sources.
          • Importing External Data:
        Learners will discover how to import data from various external sources, including text files (TXT), CSV files, Access databases, websites, etc.
      • Introduction to Power Query Editor:
      Learners will learn to use the Power Query editor to transform, clean, and combine data from different sources, making them ready for analysis in Excel.
            • Using Named Ranges and Data Validation:
          This section will explain how to assign meaningful names to specific cell ranges, making data management and use easier. Additionally, learners will learn to validate data to ensure accuracy and consistency.
                • Conditional Formatting:
              Learners will learn to apply advanced conditional formatting rules to highlight trends, patterns, or specific values in their datasets.
                    • Using Sparkline Charts:
              This part will focus on using Sparkline charts to visualize trends and patterns within the data, providing a compact and concise visual representation of information.
      • Reminder on Absolute, Relative, and Mixed References:
      Learners will revisit the different types of cell references in Excel (absolute, relative, and mixed) to understand their use in complex formulas.
            • SUMIF Function:
          Learners will learn to use the SUMIF function to sum values based on specific criteria, enabling precise calculations on complex datasets.
                • SUMIFS Function:
          This part will cover the use of the SUMIFS function to sum values based on multiple criteria, offering increased flexibility in data analysis.
                • VLOOKUP Function:
              Learners will learn to use the VLOOKUP function to search for values in a table and return corresponding values from a specified column.
          • CONCATENATE:
        Learners will learn to use the CONCATENATE function to combine the content of multiple cells into a single cell, making it easier to manipulate and analyze textual data.
          • RIGHT and LEFT:
        This section will cover the use of the RIGHT and LEFT functions to extract specific parts of textual data from cells, enabling learners to work with textual data in a more targeted manner.
          • MID:
        Learners will learn to use the MID function to extract a specific part of a text string, specifying the starting position and length of the substring.
      • FIND:
    This section will explain the use of the FIND function to search for a specific substring within a text string, which can be useful for finding patterns or models in textual data.
          • PROPER:
        Learners will learn to use the PROPER function to convert the first character of each word to uppercase, ensuring consistent formatting of textual data.
              • Combination of Multiple Functions:
            In this part, learners will explore examples of combining multiple text functions to accomplish advanced and complex text manipulation tasks.
      • TODAY / YEAR / MONTH / DAY :
    Learners will learn to use these functions to extract specific information such as the current date, year, month, and day from dates.
          • DATEDIFF :
    This section will cover the use of the DATEDIFF function to calculate the difference between two specific dates, providing an accurate measure of time gaps.
          • MONTH.SHIFT :
    Learners will learn to use the MONTH.SHIFT function to obtain a date by adding or subtracting a specified number of months from a reference date.
          • END.MONTH :
    This section will explain the use of the END.MONTH function to obtain the last date of the month for a specific date, which can be useful in data analyses based on periods.
          • WORKDAYS :
    Learners will discover how to use the WORKDAYS function to calculate the number of working days between two dates, excluding weekends and holidays.
          • Pivot Table Exploration:
        Learners will learn how to create and manipulate pivot tables to analyze and summarize large datasets, providing easier visualization and understanding of information.
          • Using Slicers:
        This section will cover the use of slicers to filter and analyze specific data in a pivot table, allowing learners to customize their analysis based on specific criteria.
          • Inserting Pivot Charts:
        Learners will discover how to insert pivot charts to visualize the results of data analyses in the form of charts, facilitating the communication of key information to a broader audience.
      • Different Form Controls:
    Learners will explore different types of form controls available in Excel, such as drop-down lists, checkboxes, option buttons, etc., to facilitate data input and manipulation.
          • Drop-down Lists:
    This part will explain how to create and manage drop-down lists to allow users to select predefined options, ensuring consistent and accurate data entry.
          • Checkboxes:
    Learners will learn to create checkboxes for multiple selections or to enable/disable specific options in an Excel worksheet.
          • Option Buttons:
    This section will cover the use of option buttons to allow users to select an option from a predefined set of alternatives, providing a user-friendly interface for data manipulation.
          • Buttons:
    Learners will learn to create buttons to execute specific actions, which can be useful for automating frequently used tasks or custom macros.
  • Application for a Dashboard:
  • This part will demonstrate how to use the acquired skills to design and implement an interactive dashboard in Excel, enabling effective real-time data monitoring and management.