Nous utilisons des cookies pour faire fonctionner notre site, assurer votre sécurité, améliorer votre expérience, effectuer des analyses et diffuser des publicités pertinentes. Cliquez sur 'J'accepte' pour accepter tous les cookies.

Microsoft Excel (Beginner to Intermediate Level)

Course Description

Microsoft Excel is a powerful software application that serves as an efficient tool for storing, organizing, and analyzing large data sets. It provides a diverse array of features and formulas that can be leveraged to decipher patterns, draw conclusions, and make data-driven decisions.

Developed by Microsoft, Excel is a versatile spreadsheet program available on multiple platforms, including Windows, macOS, Android, and iOS. This widespread availability means that regardless of the device you're using, Excel's powerful tools are within reach. Excel is used across a multitude of industries and professions for tasks ranging from simple data entry and calculation to complex problem-solving and analysis.

One of Excel's fundamental strengths lies in its calculation capabilities. It boasts a vast library of mathematical functions, allowing users to carry out anything from basic arithmetic operations to advanced statistical analyses.

Excel also provides a suite of graphing tools, enabling users to visualize data in an easily digestible format. Whether you're crafting a simple line chart or building a multi-faceted pivot chart, Excel's graphing features can help bring your data to life.

Moreover, Excel comes equipped with pivot tables, a feature that permits the user to summarize, analyze, explore, and present data in a structured format, making it easier to detect trends, patterns, and insights.

Beyond these features, Excel supports a macro programming language known as Visual Basic for Applications (VBA). VBA enables users to automate tasks within Excel, and to develop complex applications, thereby extending the functionality of Excel far beyond its native capabilities.

All these attributes coalesce to make Microsoft Excel a pivotal tool in today's data-driven world. Whether you're a student, a professional, or someone simply looking to manage personal finances or data, understanding and effectively using Excel can significantly enhance your efficiency and productivity.

 

WORKSHOP OBJECTIVES

 

In this Microsoft Excel course, we have carefully curated a curriculum to ensure participants grasp the fundamental concepts and skills necessary for success.

 

TARGET AUDIENCE

 

This course is tailored for anyone who wants to build a solid foundation in Microsoft Excel. Whether you're new to Excel or looking to refresh your skills, our course is designed to meet your needs.

Programme

February 2025: 10, 13, 17, 20, 24, 27
Time: 1:00 - 3:00 PM (GMT+2)
 
 
 

Topics

Formula Writing: Sum, Subtract, Divide, and Multiply cells

Filtering & Sorting: Know how to use the filter and sort buttons, and how to customize your search

Inserting Tables: Learn the proper way of defining the data by using excel tables

Fill & Flash Fill: Use the built-in trend recognition system in excel to skip repetitive tasks

Paste Special: Learn how you can paste your data in multiple ways

Find & Select: Apply enhanced technics to audit your data

Conditional Formatting: Format Cells dynamically based on its value or another’s

Functions: Use predefined excel formulas to upgrade your data manipulation skills (SUM, IF, VLOOKUP, etc.)

Pivot Tables: Create multiple reports from the same dataset

Data Tools: Learn various ways to control your data (Text transformation, remove duplicates, allow specific data type to be entered in a cell, etc.)

Charting & Quick Analysis: Visualize your data using charts

Document Security: Learn how to protect your data and secure your files

Macros in Excel (A brief look at the coding language of Excel)

Contact us
at DGJ Academy

For more information about the courses, fee structures and dates, or to discuss tailored training programmes, call us on: