IT manager

Training Course: Microsoft Excel - Basic Level


Register Now
Quick Inquiry
Discount Group Download Brochure (40)

IT235600

25 - 29 Aug 2025

Madrid (Spain)

Hotel : Pestana CR7 Gran Vía

Cost : 6000 € Euro

Introduction

This training program, designed by Global Horizon Training Center, is tailored for individuals and professionals who are new to Microsoft Excel or have limited experience with the software. The course provides a solid foundation for using Excel as an essential tool for organizing, analyzing, and presenting data. By the end of this course, participants will be able to confidently navigate Excel, perform basic functions, and use various tools to streamline their workflow.

Objectives

By the end of this program, participants will:

  • Understand the Excel interface and basic functionalities.

  • Be able to create and format worksheets and workbooks.

  • Learn to use essential formulas and functions.

  • Manage and organize data using sorting and filtering.

  • Perform basic data analysis with charts and graphs.

  • Apply formatting techniques to enhance presentation.

Course Methodology

The course will use a hands-on approach, with practical exercises and real-world examples. Participants will:

  • Engage in instructor-led demonstrations.

  • Practice individually using a provided dataset.

  • Participate in group activities to reinforce concepts.

  • Receive regular feedback from the trainer.

Organizational Impact

  • Enhanced productivity and efficiency in handling data-related tasks.

  • Improved accuracy and professionalism in creating reports and presentations.

  • Reduction of errors through better understanding of basic Excel functions.

  • Employees equipped to handle day-to-day tasks more independently.

Target Audience

This course is ideal for:

  • Administrative assistants, coordinators, and entry-level professionals.

  • Employees who work with data but lack formal Excel training.

  • Individuals looking to improve their productivity and analytical skills.

  • Those who want to build a foundation in Excel for future advanced learning.

Outlines

Day 1: Introduction to Excel and Basic Navigation

  • Overview of the Excel interface: Ribbon, toolbar, and worksheet

  • Creating, saving, and opening workbooks

  • Understanding cells, rows, columns, and ranges

  • Entering and editing data (text, numbers, dates)

  • Basic file management and navigation techniques

  • Hands-on exercise: Creating a simple worksheet

Day 2: Formatting Worksheets and Data

  • Formatting cells: Text, numbers, dates, and currency

  • Adjusting row height, column width, and cell alignment

  • Applying cell borders and shading for readability

  • Using conditional formatting for automatic visual highlights

  • Formatting worksheets for printing: Page layout, headers/footers

  • Hands-on exercise: Enhancing a worksheet's appearance

Day 3: Basic Formulas and Functions

  • Introduction to formulas: Basic arithmetic operations (+, -, *, /)

  • Understanding cell references: Relative, absolute, and mixed references

  • Using basic Excel functions: SUM, AVERAGE, MIN, MAX, COUNT

  • Introduction to AutoSum and AutoFill features

  • Hands-on exercise: Building simple calculations and functions

Day 4: Data Management Tools

  • Sorting data in ascending/descending order

  • Filtering data to view specific information

  • Introduction to Excel tables for better data management

  • Copying, moving, and deleting data in Excel

  • Hands-on exercise: Managing and organizing data in a worksheet

Day 5: Basic Data Analysis and Presentation

  • Creating simple charts and graphs (bar, line, pie charts)

  • Modifying and formatting charts for better presentation

  • Using basic data validation techniques

  • Protecting worksheets and workbooks

  • Hands-on exercise: Creating a simple report with charts and graphs

IT manager

Training Course: Microsoft Excel - Basic Level


Register Now
Quick Inquiry
Discount Group Download Brochure (40)

IT235600

25 - 29 Aug 2025

Madrid (Spain) - Pestana CR7 Gran Vía

Hotel : Pestana CR7 Gran Vía

Cost: 6000 € Euro


  About Madrid

Madrid is a city that combines its enduring history with its cosmopolitan atmosphere to create a destination that favored amongst tourists from around the world. This is a city that is very much bursting at the seams with life and its vibrant atmosphere, cultural attractions and connection with history ensure travelers have everything they could possibly want from a European city break. At the end of a flight to Madrid, there are sites to see, picturesque streets to roam and, of course, excellent shopping opportunities to explore. Visitors can immerse themselves in Madrid's fantastic local culture, its peerless art scene and world acclaimed fine dining. In fact, there is very little that Madrid doesn't have to offer.


  Things to do and places to visit in Madrid

The only problem travelers will encounter during their visit to Madrid is knowing what to do first. Sampling the mouth-watering tapas, strolling through one of the many excellent museums or even simply soaking up the atmosphere are all excellent options. Spend a sunny day wandering through the splendid squares or marvel at the intricate architecture of the churches.With so many options, flights to Madrid are great for people of any age or inclination.

When visiting Madrid, be sure to:

  • See the superb collection of art is the Museo del Prado.
  • Stroll down the Gran Via.
  • Enjoy the atmosphere of the Plaza Mayor.
  • Wander through the stunning gardens of the Parque del Buen Retiro.
  • See the beautiful mansion of the Museo Lazaro Galdiano.
  • Find quirky fashions in the Fuencarral market.
  • Try some of the many different tapas dishes.
  • Visit the statues of Don Quixote and Sancho Panza in the Plaza de Espana.
  • See the breathtaking Basilica de San Francisco El Grande.
  • Wander the Casa de Campo park, which is five times the size of Central Park.
  • Shop in the luxury boutiques of the Golden Mile.
  • Look for bargains at the El Rasto flea market.
  • See Picasso's Guernica in the Reina Sofia museum.
  • Snack on churros with chocolate.
 22 Portman Square, Marylebone, London W1H 7BG, UK
 3 Oudai street, Aldouki, Giza, Giza Governorate, Egypt
 0020233379764
 00201095004484
 00201102960555
 00201102960666
 19 Mayıs Mahallesi, 19 Mayis Street No 2 Sisli, 34360 Istanbul/Turkey
 00905357839460
 Australia Street, Raouche Beirut, Lebanon .، Beirut, Lebanon
 0096181746278
 811 Massachusetts Avenue, Boston, Massachusetts, 02118, USA
 6 Beirut Street - Fifth Circle Abdoun, P.O. Box 831370, 11183 Amman, Jordan
Copyright Global Horizon Training Center © 2019