23 - 27 Jun 2025
Kuala Lumpur (Malaysia)
Hotel : Royale Chulan Kuala Lumpur
Cost : 5775 € Euro
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.
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.
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.
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