BEGINNER

Sort By:  
Introduction to Microsoft Excel 2013 (Microsoft Excel 2013)
Overview

About this course

In this Introduction to Microsoft Excel 2013 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2013 worksheets. This course helps prepare students to take the MOS: Microsoft Office Excel 2013 certification exam 420.

Audience profile

Students who have little or no familiarity with Microsoft Excel 2013 or more experienced Excel users who want to learn the topics covered in this course in the 2013 interface.

At course completion

  • Create basic worksheets using Microsoft Excel 2013.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.

Course Outline

Module 1: Creating a Microsoft Excel Workbook
This module explains how to get started creating Microsoft Excel workbooks.

Lessons

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook


Lab : Creating a Microsoft Excel Workbook

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Work with the Status Bar.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.


Module 2: The Ribbon
The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups and Commands. In this lesson, you will learn about all three.

Lessons

  • Tabs
  • Groups
  • Commands


Lab : Exploring the Ribbon

  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.


Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View (The File Menu).

Lessons

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions


Lab : Exercises in This Lesson

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.


Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.

Lessons

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement


Lab : Customize the Quick Access Toolbar

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.


Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to enter data.

Lessons

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle


Lab : Exercises in This Lesson

  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.


Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Microsoft Excel Worksheets.

Lessons

  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group


Lab : Exercises in This Lesson

  • Understand the various ways you can format Microsoft Excel worksheets.
  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Add bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.
  • Show decimals.


Module 7: Using Formulas in Microsoft Excel
This is the math lesson, and whether you love or hate math, by the end of this lesson you will agree that Excel makes math easy. We will start by explaining some of the basic concepts you need to understand regarding how Excel does math and then will get into entering formulas.

Lessons

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References


Lab : Working with Formulas

  • Use math operators and the order of operations.
  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Use absolute, relative, and mixed cell references.
  • Copy formulas and functions.


Module 8: Working with Rows and Columns
This module explains how to work with rows and columns.

Lessons

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes


Lab : Working with Rows and Columns

  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes.


Module 9: Editing Worksheets
This module explains how to edit worksheets.

Lessons

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments


Lab : Exercises in This Lesson

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste, and Format Painter commands to edit worksheets.


Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize Microsoft Excel Worksheets.

Lessons

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers


Lab : Preparing to Print

  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.


Module 11: Microsoft Excel 2013 New Features
Excel 2013 provides some new features to make working with spreadsheets easier and more efficient.

Lessons

  • One Workbook Per Window Feature
  • Using Flash Fill


Lab : Using Flash Fill

  • Learn about the one workbook per window feature.
  • Learn how to use Flash Fill.

Target Audience

 JHS And SHS or Above


Prerequisites

Before attending this course, students must have:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Microsoft Excel 2013: Course Content / Exam(s)

Schedule for Introduction to Microsoft Excel 2013
Course#Course ContentsExam#Exam
Course 55130AIntroduction to Microsoft Excel 2013420Introduction to Microsoft Excel 2013

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵1,200.00
Fundamentals of a Windows Server® Infrastructure (Windows Server® Infrastructure)
Overview

About this course

Learn the fundamental knowledge and skills that you need to build a Windows Server infrastructure with Windows Server 2012.

This five day course provides the networking, security, and system administration information that you need to implement a Windows Server infrastructure. It covers the basics of installation and configuration, storage, network infrastructure, network components, network protocols, server roles, Active Directory Domain Services (AD DS), Group Policy, IT security, server security, network security, security software, monitoring server performance, and maintaining a Windows Server.

 

This course includes the foundational level knowledge to prepare students to start a career or cross train in Microsoft Windows Server technologies.

 

Audience profile

Students for this course are just starting their Information Technology (IT) careers or want to change careers into Windows Server technologies. This fundamental knowledge and skills can be used by home computer users, small business owners, academic students, information workers, technical managers, help desk technicians, or students who want to cross train from another technology.

 

This course is a first step in preparing for a job in IT or as prerequisite training before you start the Microsoft Certified System Administrator (MCSA) training and certification path.

 

At course completion

After completing this course, students will be able to:

  • Perform a local media-based installation of Windows Server 2012.
  • Select appropriate storage technologies and configure storage on a Windows Server.
  • Describe fundamental network components and terminology so you can select an appropriate network component.
  • Implement a network by selecting network hardware components and technologies and determine the appropriate network hardware and wiring components for a given situation.
  • Describe the protocols and services within the Transmission Control Protocol/Internet Protocol (TCP/IP) suite of protocols and implement IPv4 within a Windows Server environment.
  • Describe and implement server roles.
  • Implement and configure an Active Directory Domain Service (AD DS) forest.
  • Describe the concept of defense-in-depth and determine how to implement this approach with Windows Server.
  • Identify the security features in Windows Server that help to provide defense-in-depth.
  • Identify the network-related security features in Windows Server to mitigate security threats to your network.
  • Identify and implement additional software components to enhance your organization’s security.
  • Monitor a server to determine the performance level.

Identify the Windows Server tools available to maintain and troubleshoot Windows Server.



Course Outline

Module 1: Installing and Configuring Windows Server 2012

This module explains how the Windows Server 2012 editions, installation options, optimal service and device configuration and general post-installation configuration all contribute to the functionality and effectiveness of your Windows Server implementation.

 

Lessons

  • Windows Server Architecture.
  • Installing Windows Server.
  • Configuring Services.
  • Configuring Devices and Device Drivers.

Lab : Installing and Configuring Windows Server 2012

After completing this module, student will be able to:

  • Describe Windows Server components and architecture.
  • Install Windows Server 2012.
  • Configure services.
  • Configure devices and device drivers.

Module 2: Implementing Storage in Windows Server

This module will introduce you to different storage technologies and discuss how to implement the storage solutions in Windows Server. There is also a discussion on how to create a resilient strategy for your storage, helping to avoid unplanned downtime and loss of data.

Lessons

  • Identifying Storage Technologies.
  • Managing Disks and Volumes.
  • Fault Tolerance.

Lab : Implementing Storage in Windows Server

After completing this module, students will be able to:

  • Identify a suitable storage technology.
  • Manage storage within Windows Server.
  • Implement disk fault tolerance.

Module 3: Understanding Network Infrastructure

In this module, students will learn how to describe fundamental network component and terminology thus enabling the student to select an appropriate network component in a particular scenario.

Lessons

  • Network Architecture Standards.
  • Local Area Networking.
  • Wide Area Networking.
  • Wireless Networking.
  • Connecting to the Internet.
  • Remote Access.

Lab : Selecting Network Infrastructure Components

After completing this module, students will be able to:

 

  • Describe physical network topologies and standards.
  • Define local area networks (LANs).
  • Define wide area networks (WANs).
  • Describe wireless networking technologies.
  • Explain how to connect a network to the Internet.
  • Describe how technologies are used for remote access.

Module 4: Connecting Network Components

This module explores the functionality of low-level networking components, including switches and routers. In addition, the module provides guidance on how best to connect these and other components together to provide additional network functionality.

Lessons

  • Understanding the OSI Model.
  • Understanding Media Types.
  • Understanding Adapters, Hubs, and Switches.
  • Understanding Routing.

Lab : Connecting Network Components

After completing this module, students will be able to:

 

  • Describe the industry standard protocol model.
  • Describe wiring methodologies and standards.
  • Describe adapters, hubs, and switches.
  • Describe routing technologies and protocols.

 

Module 5: Implementing TCP/IP

This module describes the requirements of a protocol stack and then focuses on the Transmission Control Protocol/Internet Protocol (TCP/IP) protocol stack.

Lessons

  • Overview of TCP/IP.
  • IPv4 Addressing.
  • IPv6 Addressing.
  • Name Resolution.

Lab : Implementing TCP/IP

After completing this module, students will be able to:

 

  • Describe the Functionality of the TCP/IP Suite.
  • Describe IPv4 Addressing.
  • Configure an IPv4 Network.
  • Describe IPv6 Addressing and Transition.
  • Describe the Various Name Resolution Methods Used by TCP/IP Hosts.

Module 6: Implementing Windows Server Roles

This module explains the functional requirements of a server computer and how to select and deploy appropriate server roles to support these functional requirements.

Lessons

  • Role-Based Deployment.
  • Deploying Role-Specific Services.
  • Considerations for Provisioning Roles.

Lab : Implementing Server Roles

Lab : Implementing Server Roles

After completing this module, students will be able to:

  • Describe role-based deployment.
  • Deploy role-specific servers.
  • Describe deployment options for server roles.

Module 7: Implementing Active Directory

This module explains that, as a directory service, how AD DS stores information about objects on a network and makes this information available to users and network administrators.

Lessons

  • Introducing Active Directory Domain Services (AD DS).
  • Implementing AD DS.
  • Managing Users, Groups, and Computers.
  • Implementing Group Policy

Lab : Implementing AD DS

After completing this module, students will be able to:

 

  • Describe the fundamental features of AD DS.
  • Implement AD DS.
  • Implement organizational units (OUs) for managing groups and objects.  
  • Configure client computers centrally with group policy objects (GPOs).

Module 8: Implementing IT Security Layers

This module explains how, in addition to file and share permissions, you can also use data encryption to restrict data access.

Lessons

  • Overview of Defense-in-Depth.
  • Physical Security.
  • Internet Security.

Lab : Implementing IT Security Layers

After completing this module, students will be able to:

  • Describe the risks posed by connecting to the Internet.
  • Describe possible mitigations to these risks.
  • Describe the Windows Server components and features that can help provide his Internet security.

Module 9: Implementing Security in Windows Server

This module reviews the tools and concepts available for implementing security within a Microsoft Windows infrastructure.

Lessons

  • Overview of Windows Security.
  • Securing Files and Folders.
  • Implementing Encryption.

Lab : Implementing Windows Security

After completing this module, students will be able to:

 

  • Describe the Windows Server features that help improve your network’s security.
  • Explain how to secure files and folders in the Windows Server environment.
  • Explain how to use the Windows Server encryption features to help secure access to resources.

Module 10: Implementing Network SecurityThis module explains possible threats when you connect your computers to a network, how to identify them, and how implement appropriate Windows network security features to help to eliminate them.Lessons

  • Overview of Network Security.
  • Implementing Firewalls.
  • Internet Protocol Security (IPsec)

Lab : Implementing Network Security

After completing this module, students will be able to:

 

  • Identify network-based security threats.
  • Implement Windows Firewall to secure Windows hosts.
  • Explain how to enforce corporate compliance.

Module 11: Implementing Security Software

This module explains how an information technology (IT) administrator can account for and mitigate the risks of malicious code, unauthorized use, and data theft.

Lessons

  • Client Software Protection Features.
  • E-Mail Protection.
  • Server Protection.

Lab : Implementing Security Software

After completing this module, students will be able to:

 

  • Implement Windows Server technologies and features to improve client security.
  • Describe security threats posed by e-mail and how to reduce these threats.
  • Explain how to improve server security using Windows Server security analysis and hardening tools.

Module 12: Monitoring Server Performance

This module discusses the importance of monitoring the performance of servers, and how you monitor servers to ensure that they run efficiently and use available server capacity. It also explains performance monitoring tools to identify components that require additional tuning and troubleshooting, so that you can improve the efficiency of your servers.

Lessons

  • Event Logging.
  • Performance Monitoring.

Lab : Monitoring Server Performance

After completing this module, students will be able to:

 

  • Use the Event Viewer to identify and interpret Windows Logs, and Application and Services Logs.
  • Measure system resource usage and identify component bottlenecks

Module 13: Maintaining Windows Server

This module explains the importance of system updates, how to troubleshoot the Windows Server boot process, and how to implement high availability and recovery technologies to improve system availability.

Lessons

  • Troubleshooting Windows Server Startup.
  • Server Availability and Data Recovery.
  • Applying Updates to Windows Server.
  • Troubleshooting Windows Server.

Lab : Maintaining Windows Server

After completing this module, students will be able to:

 

  • Troubleshoot the Windows Server boot process.
  • Implement high availability and recovery technologies to improve system availability.
  • Explain the importance of system updates.

Implement an appropriate troubleshooting methodology to resolve problems with Windows Server.


Target Audience
 JHS And SHS


Prerequisites

Before attending this course, students must have:

  • A basic knowledge of general computing concepts.
  • Some experience working with Windows Client operating systems such as Windows 7 or Windows 8



Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Fundamentals of a Windows Server® Infrastructure: Course Content / Exam(s)

Schedule for Fundamentals of a Windows Server® Infrastructure
Course#Course ContentsExam#Exam
Course 10967AFundamentals of a Windows Server® InfrastructureFundamentals of a Windows Server® Infrastructure

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵800.00
Hands On Lab: Introduction to Windows® 8 Development - C#

Overview

About this course

This Hands-On Lab (HOL) will introduce developers to the tools and techniques for creating Window Store apps using C# and XAML. It will outline the Windows 8 platform, Windows Store apps guidelines, Windows 8 contracts, tiles and notifications, and the Windows store.

Audience profile

This Hands-On Lab is intended for professional developers that come from the C# background. Developers should have 1-2 years of experience in their field.

At course completion

After completing this Hands-on Lab, students will be able to:

  • Use the Windows 8 Start screen
  • Run apps using tiles
  • Use the Charms bar
  • Examine Windows Store apps and their design
  • Create a Grid Application
  • Create a Split Application
  • Explore how the WinRT Library is used
  • Explore how Search Contract is integrated
  • Explore how Share Contract is integrated
  • Explore how Settings Contract is integrated
  • Explore how Live Tiles in a Windows Store app are used
  • Explore how Toast Notifications in a Windows Store app are used
  • Explore the Windows Store
  • Explore the trial version settings of a Windows Store app

 

Hands On Lab: Introduction to Windows® 8 Development - C# Course Objectives

  • Course Outline
    Module 1: Introduction to Windows 8 Platform

    In this lab you will explore the various Windows 8 features and see how to work with them.


    Lab : Introduction to Windows 8 Platform

    After completing this lab, students will be able to:

    • Use the Windows 8 Start screen.
    • Run Windows Store apps using tiles.
    • Use the Charms bar.


    Module 2: Exploring Windows Store Apps

    In this lab you will explore the Windows Store app guidelines and learn to apply them to apps.


    Lab : Exploring Windows Store Apps

    After completing this lab, students will be able to:

    • Examine Windows Store apps and their designs.


    Module 3: Implementing Windows Store Apps with XAML and C#

    In this lab you will explore how to create Windows Store app using XAML and C#. You will learn how to create a grid application and a split application.


    Lab : Implementing Windows Store Apps with XAML and C#

    After completing this lab, students will be able to:

    • Create a Grid App
    • Create a Split App
    • Use the WinRT Library


    Module 4: Integrating with Windows 8 experiences

    In this lab you will explore how the built-in contracts such as Search, Share, Settings are integrated.


    Lab : Integrating with Windows 8 experiences

    After completing this lab, students will be able to:

    • Examine how Search contract is implemented
    • Examine how Share contract is implemented
    • Examine how Settings contract is implemented


    Module 5: Implementing Tiles and Notifications
    In this lab you explore how Tiles and Notifications that let users personalize their Start screen are implemented

    Lab : Implementing Tiles and Notifications

    After completing this lab, students will be able to:

    • Integrate live tiles into a Windows Store app.
    • Integrate toast notifications into a Windows Store app.

    Module 6: Exploring the Windows Store
    In this lab you will explore the Windows Store, and work on creating a trial version of a Windows Store app

    Lab : Exploring the Windows Store

    After completing this lab, students will be able to:

    • Explore the Window Store and its categories
    Understand a Windows Store app’s license configuration

Prerequisites

Before attending this course, students must have:

  • Knowledge of graphical interface design
  • Knowledge of Object Oriented Programming design and development
  • Simple data access (CRUD) knowledge
  • General understanding of the Visual Studio IDE


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Hands On Lab: Introduction to Windows® 8 Development - C# Course 40026B Content / Exam(s)

2 Hours Daily 3 Times a Week

Total Duration 3 Months

₵800.00
Introduction to Microsoft Excel 2016 (Microsoft Excel 2016)
Overview

About this course

In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Audience profile

This course is intended for students who have little or no familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this course in the 2016 interface.

After course completion

After completing this course, students will be able to:

  • Create basic worksheets using Microsoft Excel 2016.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
  • Learn how to use handy features new in 2016.

Course Outline
Module 1: Creating a Microsoft Excel Workbook
This module explains how to create workbooks in Microsoft Excel.

Lessons

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook

Lab : Creating a Microsoft Excel Workbook

  • Creating a Microsoft Excel Workbook

After completing this module, students will be able to:

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.

Module 2: The Ribbon
This module explains how to work with the Ribbon.

Lessons

  • Tabs
  • Groups
  • Commands

Lab : Exploring the Ribbon

  • Exploring the Ribbon

After completing this module, students will be able to:

  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.

Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View aka the File menu.

Lessons

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions

Lab : The Backstage View (The File Menu)

  • Open a Workbook
  • Select, Open and Save a Template Agenda
  • Print a Worksheet

After completing this module, students will be able to:

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.

Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.

Lessons

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement

Lab : The Quick Access Toolbar

  • Customize the Quick Access Toolbar

After completing this module, students will be able to:

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.

Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to how to enter data in Excel worksheets.

Lessons

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Lab : Entering Data in Microsoft Excel Worksheets

  • Entering Text and Using AutoComplete
  • Entering Numbers and Dates

After completing this module, students will be able to:

  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.

Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Excel worksheets.

Lessons

  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Lab : Formatting Microsoft Excel Worksheets

  • Customize a Workbook Using Tab Colors and Themes
  • Working with Font Group Commands
  • Working with Alignment Group Commands
  • Working with Number Group Commands

After completing this module, students will be able to:

  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Apply bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.

Module 7: Using Formulas in Microsoft Excel
This module explains how to use formulas in Excel.

Lessons

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References

Lab : Using Formulas in Microsoft Excel

  • Working with Formulas

After completing this module, students will be able to:

  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Understand absolute, relative, and mixed cell references.
  • Copy formulas and functions.

Module 8: Working with Rows and Columns
This module explains how to work with rows and columns.

Lessons

  • Insert lesson titles in a bulleted list.
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Lab : Working with Rows and Columns

  • Working with Rows and Columns
  • After completing this module, students will be able to:
  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes

Module 9: Editing Worksheets
This module explains how to edit worksheets.

Lessons

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments

Lab : Editing Worksheets

  • Using Find and Replace
  • Using the Clipboard

After completing this module, students will be able to:

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste and Format Painter commands to edit worksheets.
  • Manage comments.

Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize worksheets.

Lessons

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Lab : Finalizing Microsoft Excel Worksheets

  • Preparing to Print

After completing this module, students will be able to:

  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.

Module 11: Microsoft Excel Features that Were New in 2013
This module explains how to use some of the features that were new in the 2013 version of Excel.

Lessons

  • One Workbook Per Window Feature
  • Using Flash Fill

Lab : Microsoft Excel Features that Were New in 2013

  • Using Flash Fill

After completing this module, students will be able to:

  • Use the one workbook per window feature.
  • Use Flash Fill.

Module 12: Features New in 2016
This module explains how to use two new features in 2016.

Lessons

  • Tell Me
  • Smart Lookup

Lab : None

  • None

After completing this module, students will be able to:

  • Use the Tell Me feature.

Use the Smart Lookup feature.


Target Audience

 JHS And SHS or Above


Prerequisites

Before attending this course, students must have:

  • Experience installing PC hardware and devices.
  • Basic understanding of TCP/IP and networking concepts.
  • Basic Windows and Active Directory knowledge.
  • The skills to map network file shares.
  • Experience working from a command prompt.
  • Basic knowledge of the fundamentals of applications. For example, how client computer applications communicate with the server.
  • Basic understanding of security concepts such as authentication and authorization.
  • An understanding of the fundamental principles of using printers.



Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Microsoft Excel 2016: Course Content / Exam(s)

Schedule for Introduction to Microsoft Excel 2016
Course#Course ContentsExam#Exam
Course 55165AIntroduction to Microsoft Excel 2016Introduction to Microsoft Excel 2016

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵1,200.00
CompTIA IT Fundamentals

This 3 Months course is intended for those wishing to qualify with CompTIA IT Fundamentals Certification. CompTIA Information Technology (IT) Fundamentals Certification is the essential qualification for beginning a career in PC support.

The CompTIA IT Fundamentals Certification exam is designed to show that the successful candidate has the knowledge to identify and explain basic computer components, set up a basic workstation, conduct basic software installation, establish basic network connectivity, identify compatibility issues, and identify/prevent basic security risks. Further this exam will assess the candidate’s knowledge in the areas of safety and preventative maintenance of computers. 


TARGET AUDIENCE

CompTIA IT Fundamentals is a starter qualification for students and career changes to help decide whether they can be successful in pursuing a career in IT. It is ideal for those with no previous computer experience considering a career as an IT technician or in IT customer support / helpdesk.

COURSE OBJECTIVES

After completing this course you should be able to:

  • Set up a computer workstation running Windows and use basic software applications.
  • Understand the functions and types of devices used within a computer system.
  • Apply basic computer maintenance and support principles.
  • Configure computers and mobile devices to connect to home networks and to the internet.
  • Identify security issues affecting the use of computers and networks.

COURSE CONTENT

The course consists of a study volume, containing indexed notes, labs, and review questions, plus exam objectives mapping, and exam information. The course also comes with an online practice exam.
Access to course resources (setup guide, PowerPoint slides, and timetable) on gtslearning's trainer portal is also available, subject to meeting minimum order requirements. A full set of classroom labs is provided to training companies and there are also options for self-paced labs to accompany the course.

Module 1 / Operating Systems and Software

Computers and Operating Systems

  • Information Technology
  • Personal Computers (PC)
  • Functions of an Operating System
  • Types of Operating System
  • Microsoft Windows
  • Apple Mac OS X and iOS and Blackberry
  • Linux, Chrome, and Android

Setting up a Workstation and Using Windows

  • Setting up a PC System
  • Ergonomic Concepts
  • Navigating an OS
  • Using Input Devices
  • Icons and Windows
  • File Explorer and Control Panel
  • Using a Web Browser
  • Exercises / Setting Up the Computer / Exploring the Start Screen / Exploring the Desktop and Taskbar

Installing and Configuring Windows

  • Installing Windows
  • Completing Setup
  • Managing User Accounts
  • Exercises / Managing User Accounts

Software Applications

  • Installing and Configuring Software
  • Managing Software
  • Productivity Software
  • Collaboration Software
  • Specialized Software
  • Utility Software
  • Virtualization
  • Exercises / Managing Software Applications

Troubleshooting and Support

  • Support and Troubleshooting 
  • Getting Support
  • Using a Search Engine
  • Exercises / Using a Search Engine

Module 2 / Computer Hardware

Input Devices

  • Computer Connector Types
  • Input Devices
  • Installing and Uninstalling Peripherals
  • Configuring Peripherals
  • Exercises / Configuring an Input Device

Output Devices

  • Video Cards
  • Display Devices
  • Display Connectors and Cable Types
  • Display Settings
  • Multimedia Ports and Devices
  • Exercises / Playing Audio

Storage Devices

  • Hard Disk Drives
  • Optical Discs and Drives
  • Flash Memory
  • Exercises / Adding a Removable Drive

File Management

  • Managing the File System
  • Folders
  • Files
  • Searching for Folders and Files
  • Exercises / File Explorer / Creating, Renaming, and Copying Folders and Files / View Options and Search / Compressing Files / Deleting and Recycling Files

Printers and Scanners

  • Printer Types
  • Laser Printers
  • Inkjet Printers
  • Thermal Transfer Printers
  • Printer Interfaces
  • Installing and Configuring a Printer
  • Scanners
  • Fax Modems
  • Exercises / Using a Printer

System Components

  • Selecting a Computer
  • Motherboard Components
  • Processors
  • System Memory
  • Expansion Bus
  • System Cooling
  • Exercises / Specifying PC Systems

Environment and Power

  • ESD Precautions
  • Device Placement
  • Power Supply Units
  • Energy Efficiency
  • Power Protection
  • Safe Disposal and Recycling 
  • Exercises / Adjusting Power Options

Module 3 / Networks and Security

Setting Up a Network

  • Network Components
  • TCP/IP
  • Setting up a Local Network
  • Setting Up a Wireless Network
  • Exercises / Network Settings

Sharing and Storage

  • Windows Client Software
  • Local Sharing and Storage
  • Hosted Sharing and Storage
  • Backups
  • Exercises / Homegroups and File Sharing

Mobile Devices

  • Using a Mobile Device
  • Mobile Applications and App Stores 
  • Network Connectivity
  • Email Configuration
  • Synchronization and Data Transfer 
  • Bluetooth and NFC

Basic Security Threats

  • Computer Security Basics
  • Malware 
  • Preventing Malware Infections
  • Patch Management
  • Exercises / Using Windows Defender and Windows Update

Security Best Practices

  • Spam
  • Social Engineering
  • Hardware Theft and Device Hardening
  • Managing User Authentication
  • User Education

Web Browsing Best Practices

  • Using Free / Open Networks
  • Configuring Web Browser Security
  • Managing Plug-ins
  • Digital Certificates and Anti-phishing
  • Managing Cookies and PII
  • Enabling a Firewall
  • Exercises / Web Security / Installing a Plug-in

Index, Exam Tips, Career Advice 

COURSE PREREQUISITES

  • Some experience with using a keyboard and mouse would be helpful but is not essential

TEST CERTIFICATION

Recommended as preparation for the following exams:

  • FC0-U51 - Comptia IT Fundmantals Exam

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Comptia IT Fundmantals Course Content / Exam(s)

Schedule for Comptia IT Fundmantals
Course#Course ContentsExam#
CompTIA IT FundamentalsFC0-U51

2 Hours Daily 3 Times a Week

Total Duration 3 Months

₵1,500.00
Per Page      1 - 5 of 5
  • 1