IT manager

Training Course: Microsoft Office Tools


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

IT234687

25 - 29 May 2025

Cairo (Egypt)

Hotel : Holiday Inn & Suites Cairo Maadi, an IHG Hotel

Cost : 3575 € Euro

Introduction

This course provides overall training for Microsoft Office. Upon completion of this course, the delegate will be able to create and use Outlook, Microsoft Word, PowerPoint, Excel, and Power BI. The material covered in this course provides a foundation for all levels of Microsoft Office.

Course Objectives of Microsoft Office

By the end of this program you will be able to:

  • How to set up and manage email, calendars, and contacts in the Microsoft 365 version of Outlook.
  • Create scientific and technical documents incorporating equations.
  • Create images, tables, and bibliographies.
  • Develop technical and scientific presentations
  • use charts and visual aids to share data.
  • Build spreadsheets to perform calculations, and display data.
  • conduct analysis, and explore what-if scenarios.
  • Design and construct databases to store, extract, and analyze scientific and real-world data.
  • Identify, access, and evaluate information to solve real-world problems.
  • Distinguish between different data types in Power BI.
  • Correlate the similarities between visualizations in Power BI.
  • Identify the outcomes when changes are made within Power BI and Power BI Desktop.
  • Differentiate between dashboards and reports within Power BI.
  • Determine user roles within a workspace in Power BI.

Training Methodology

Computer Science 101 is organized into three units: Excel & Data Analysis, Word & PowerPoint. Each unit focuses on one or two of the Microsoft Office applications taught in the course. Units are further broken down into chapters corresponding with those used in the textbook and Supplemental Content.

Course Outlines of Microsoft Office

Day 1

Outlook Essentials

  • Get Started and Connect Accounts
  •  Read Mail
  •  Organize Mail
  • Create and Send Mail
  • Create Contacts and Work with People
  • Use Outlook's Accessibility Features
  • Work with Delegates
  • Work with the Calendar
  • Work with Tasks and Settings

Day 2

Introduction to Microsoft Word

  • Document Views
  • Entering and Editing Text
  • Saving and Opening Documents
  • Navigating and Selecting Text
  • Editing, Copying, and Moving Text
  • Formatting Documents
  • Using Bulleted and Numbered Lists
  • Using Tabs
  • Introduction to Tables
  • Inserting Pictures
  • Page Layout and Printing
  • Introduction to Styles, Themes, and Templates
  • Managing Bulleted and Numbered Lists
  • Customizing Tables and using Formulas
  • Inserting Text Objects
  • Inserting Graphic Objects
  • Using Quick Parts
  • Multi-Section Documents
  • Headers and Footers in large documents
  • Proofing Tools

Day 3

Introduction to Microsoft PowerPoint

  • Creating a Presentation
  • Entering and Editing Text
  • Managing Text
  • Text Boxes and Tables
  • Pictures and Drawings
  • SmartArt and Charts
  • Presentation Designs and Formatting
  • Printing PowerPoint Presentations
  • Simple Animations
  • Running Slide Shows
  • Integrating with Word and Excel
  • Managing Slide Masters
  • Multimedia Objects
  • Custom Animations
  • Collaborating with Colleagues
  • Publishing a Presentation
  • Preparing and Presenting a Show

Day 4

Introduction to Microsoft Excel

  • Entering and Amending Data
  • Saving and Opening Workbooks
  • Navigating and Selecting Ranges
  • Entering Formulas
  • Inserting/Deleting Rows and Columns
  • Formatting Worksheets
  • Using Simple Functions
  • Copying, Moving and AutoFill
  • Relative vs. Absolute References
  • Previewing and Printing
  • Find and Replace
  • Introduction to Range Names
  • Using Multiple Worksheets
  • Cell Styles and Conditional Formatting
  • Paste Special
  • Text and Date Formulas
  • IF Function
  • Using Charts
  • Sorting and Filtering Lists
  • Using Tables
  • SmartArt and Drawings
  • Comments and Hyperlinks
  • Importing and Exporting Data
  • Managing Range Names
  • Date and Time Formulas
  • Custom Formats
  • IF and Related Functions
  • VLOOKUP and Related Functions
  • Advanced Filter / Subtotals
  • Database Functions
  • Multiple Workbooks / Consolidation
  • Data Validation
  • Auditing
  • Pivot Tables
  • Shared Workbooks / Tracking
  • Protecting Worksheets
  • Using Templates

Day 5

Power BI Essential

  • Get started with Power BI
  • Get Data
  • Create a report with Visualizations
  • Modify and print a report
  • Create a dashboard
  • Ask questions about your data
  • share data with colleagues and others
  • Using Power BI mobile apps
  • Using Power BI desktop

IT manager

Training Course: Microsoft Office Tools


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

IT234687

25 - 29 May 2025

Cairo (Egypt) - Holiday Inn & Suites Cairo Maadi, an IHG Hotel

Hotel : Holiday Inn & Suites Cairo Maadi, an IHG Hotel

Cost: 3575 € Euro


  About Cairo

Cairo is a mesmerizing assortment of iconic monuments, bustling markets, and ancient sites encircled by a vast and sprawling metropolis. At its core lies a maze-like medieval quarter. A world away from the modern side of the city, it boasts a seductive blend of intricate mosques, jostling crowds, madrasas, and traditional hammams. No visit could be complete without visiting the awe-inspiring Giza Pyramids that preside over the city's horizon. Whether you come to delve into the city's ancient past, dive into colorful souqs, sip mint tea and contemplate thousands of years of history or explore the city's cosmopolitan side, you'll be left with memories to last a lifetime.


  Things to do and places to visit in Cairo

The multi-layered capital of Egypt offers its visitors lively markets, authentic restaurants, and a multitude of ancient sights and archeological findings. Gaze in wonder at the Pyramids, take an awe-inspiring look at Tutankhamen's burial mask, shop for handmade souvenirs in the bazaars or hop on a sunset cruise down the Nile and embrace the sensory overload that is Cairo.

Take a vacation in Cairo and you can:

  • Visit the Great Sphinx of Giza, one of Ancient Egypt's great mysteries.
  • Explore the ramparts of the Salah El-Din Citadel.
  • Join locals drinking coffee at Fishawi Café, one of Cairo's first cafes and most important meeting spots.
  • Marvel at the seemingly endless historical artifacts on display at the Egyptian Museum.
  • Learn about the Ummayad, Ottoman, and Ayyubbid dynasties and more at the Museum of Islamic Art.
  • Haggle for souvenirs and gifts at the Khan el-Khalili souk.
  • See one of the world's oldest universities at the Al-Azhar Mosque, one of the city's original mosques.
  • Take a tour of the showstopping Giza pyramids.
  • Savor local cuisine such as mezze in the old city.
  • Wander through the labyrinth-like streets of Coptic Cairo, the city's ancient quarter, and spot Roman relics.
 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