Main MenuMain Menu
Course Code: IT 159
398 Course Visits
MS (Powerpoint + Excel)
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
01
5 Days
Madrid, Spain $4,950
02
5 Days
Online, Virtual $2,150
Introduction
Training course introducion / brief
Without any doubts, all companies and ministries in our current era are
totally dependent on computers and systems to finish all their daily
tasks which used to take hundreds of hours to be done manually. More
specifically, when we talk about data management and presentation. This
training course is designed to provide participants with the techniques
needed to create and modify presentations using Microsoft PowerPoint and
automating tasks, generating data report using Microsoft Excel. This
course will allow participants to explore the Excel and PowerPoint
environment and be more familiar with all the tools and techniques to
navigate it effectively.
Course Objectives
At the end of the training course, participants will be able to
- Gain necessary data management skills using Excel
- Easily automate daily and weekly reporting
- Replicate data with other departments at work
- Quickly backup and restore data and reports in case of data loss
- Start and end a PowerPoint session
- Run a slide show and create custom shows.
- Create different types of slides.
- Edit, format slides and use templates.
- Use the Slide Sorter to reorganize a presentation.
- Create, edit, and import charts, and tables for use in a presentation.
- Add special effects to presentation.
- Use the slide, notes, and handout masters.
- Manage hyperlinks in presentations.
- Secure and share presentations.
Course Audience
Who is this course for, and can benefit the most
- Cloud Computing Engineer
- Computer Network Specialist
- Computer Support Specialist
- Database Administrator
- Information Technology Analyst
- Information Technology Leadership
- Information Security Specialist
- Software/Application Developer
- Web Developer
- Technology sales consultant
Course Outline
The course aims and learning outcomes
Introduction to MS Office PowerPoint 2016 (Basic)
- Creating a PowerPoint Presentation
- The Ribbon
- The Quick Access Toolbar
- The Backstage View (The File Menu)
Introduction to MS Office PowerPoint 2016 (Basic) - continuation
- Formatting Microsoft PowerPoint Presentations
- Working with Images
- Working with Tables and Charts
Introduction to MS Office Excel
- Understanding the various spreadsheet terminology
- What are the various components of the excel window interface?
- How to create our own template and use it efficiently everytime we need to do the calculations and generate reports
- How to enter and edit data in Microsoft excel?
- What is the advantage of the autofill feature and how to use it?
- How to enter and edit functions in excel, and how to work with the order of operationsWhat are the various ways to save and update workbooks, and how to save it as pdf?
- How to move and copy data in excel?
- What are the various methods to move data and
- ensure that the formulas are automatically updated?
- What are the various ways of pasting data?
- What’s the difference between paste values, paste formulas, transpose?
- What’s the difference between cut paste and drag drop? Which one is more efficient?
- When to use one over the other?
- How to use the autofill to copy formulas and allow the computer to automatically write the days, months and quarters
- Understanding absolute references: how and when to use them? What happens if we don’t use them?
- How to properly insert and delete ranges, rows and columns
- How to insert simple functions in excel (average, min, max)
- How to use the autosum shortcut?
- What is the difference between count and counta? Which one shall we use?
How to apply various text formatting?
- How to format non-contiguous ranges?
- How to use the format cells dialog box?
- How to format the column width and height, and how to apply the autofit?
- How to apply professional formatting to the top rows and apply colors?
- What are the various alignment options (vertical and horizontal)?
- How to use the cell borders options to better display our data?
- How to use the paste special functionality to copy and paste formatting?
- How to format numbers (percentages, and how to format date and time values?
- How to use the conditional formatting to change the format of the cells only where a condition is applicable?
- How to draw simple charts and how to move them from one sheet to another in a condition to keep them linked and updated and synchronized?
- How to add various chart elements (chart title, chart table, chart labels, axes labels)?
- How to add images to our worksheet?
- How to apply conditional formatting with graphics?
How to print reports in a professional way?
- How to change the page orientation and scaling?
- How to modify the margins for easier printing?
- How to add headers and footers, and print different headers and footers?
- What are the various sheet options and how to benefit from the printing gridlines and headings?
- How to set the print area or print a selected range?
- How to view all the data in a large worksheet in a professional and easy way?
- How to split a worksheet into several panes and work on each one separately?
- How to hide and unhide columns and worksheets?
- How to collapse the ribbon to see more of the worksheet?
- How to print large worksheets and reports?
- How to set the print titles and the page breaks to customize the way we need to print the data?
- How to print multiple worksheets at once, and how to easily rename and navigate through worksheets?
How to link worksheets using 3d formulas?
- How to create a 3d reference and how to add the watch window dialog box?
- How to work on multiple workbo oks at the same time and how to easily switch between them?
- How to copy and move worksheets between workbooks?
- How to calculate our data using the outlining and consolidating data?
- How to create a c ustom view to properly see the outlines created?
- How to create subtotals in a professional way?
- How to apply multiple subtotal functions?
- How to create named ranges to easily calculate formulas?
- How to use the create from selection command?
- How to use the apply name s command to easily substitute old cell ranges by new named ranges?
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY
Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).
At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.
Since 2001, we have been pioneering the training field in the middle east, we managed to unlock potential and help individuals, teams and organisations to be the best that they can be with our full and integrated solutions.
Quick Links
Our sister companies in Egypt and United Arab Emirates
MOST TRENDING
And Recommended Training Courses
trending
Happiness To Have and Hold
Date: Nov 24, 2025
Location:Dubai, UAE
trending
Professional in Business Analysis (PMI-PBA Exam Preparation)
Date: May 18, 2025
Location:Jeddah, KSA
trending
OSHA: Occupational Safety and Health Administration Standards
Date: Apr 13, 2025
Location:Riyadh, KSA
We believe in progress for everyone.
We helped more than 10.000 clients over 20 countries on 4 continents in boosting their knowledge, skills and careers.
Boost Training And Consulting © All Copyrights Reserved 2025