IT manager

Training Course: Microsoft Office Tools


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

IT234687

4 - 8 May 2025

Istanbul (Turkey)

Hotel : DoubleTree by Hilton Istanbul Esentepe

Cost : 5775 € 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

4 - 8 May 2025

Istanbul (Turkey) - DoubleTree by Hilton Istanbul Esentepe

Hotel : DoubleTree by Hilton Istanbul Esentepe

Cost: 5775 € Euro


  About Istanbul

Few places compare to the vibrant, cosmopolitan city of Istanbul, whose enormous size straddles both Europe and Asia, forming a bridge between western and eastern cultures. Resting upon the natural harbor of the Golden Horn, the skyline of the once-Constantinople is pierced with minarets and ancient monuments that embody centuries of history. While it is brimming with historical landmarks and colorful markets, modern Istanbul is also well represented through its contemporary art scene, European-style café culture, world-class dining venues.


  Things to do and places to visit in Istanbul

Istanbul is teeming with attractions and landmarks from historic sights and unique cuisine to lively markets and unmistakable culture. It is a thriving city, with a myriad of things to do that skillfully manage to blend every aspect of both the contemporary and the historical world.

On a city break in Istanbul be sure to:

  • Visit a hammam, a traditional Turkish bath, whose origins date back to Roman times.
  • Marvel at the Hagia Sophia, Süleymaniye Mosque and Blue Mosque, Istanbul's most spectacular monuments that dominate the skyline.
  • Explore the Topkapi Palace Museum, one of Istanbul's most visited museums, home to over 80,000 artifacts.
  • Walk through the Basilica Cistern, an underground marvel built in the 4th century.
  • Be dazzled by the Grand Bazaar, one of the world's oldest and largest covered markets.
  • Go shopping for exotic products and Turkish delights in the Spice Bazaar.
  • Cross the bridge connecting Europe and Asia against the backdrop of the Bosphorus, or take a Bosphorus cruise.
  • Taste the diversity and flavor of Turkish cuisine.
  • Admire panoramas of the city from the Galata Tower.
  • Walk through Taksim Square, the city's dynamic square that never sleeps.
 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