BEGINNER
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 Contents | Exam# | Exam |
Course 55130A | Introduction to Microsoft Excel 2013 | 420 | Introduction to Microsoft Excel 2013 |
2 Hours Daily 3 Times a Week
Total Duration 3 Months
Our Services
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 Contents | Exam# | Exam |
Course 10967A | Fundamentals of a Windows Server® Infrastructure | Fundamentals of a Windows Server® Infrastructure | |
2 Hours Daily 3 Times a Week
Total Duration 3 Months
Our Services
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 PlatformIn this lab you will explore the various Windows 8 features and see how to work with them.
Lab : Introduction to Windows 8 PlatformAfter 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 AppsIn this lab you will explore the Windows Store app guidelines and learn to apply them to apps.
Lab : Exploring Windows Store AppsAfter 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 experiencesIn this lab you will explore how the built-in contracts such as Search, Share, Settings are integrated.
Lab : Integrating with Windows 8 experiencesAfter 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 NotificationsIn this lab you explore how Tiles and Notifications that let users personalize their Start screen are implemented
Lab : Implementing Tiles and NotificationsAfter 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 StoreAfter completing this lab, students will be able to:
- Explore the Window Store and its categories
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
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 Contents | Exam# | Exam |
Course 55165A | Introduction to Microsoft Excel 2016 | Introduction to Microsoft Excel 2016 | |
2 Hours Daily 3 Times a Week
Total Duration 3 Months
Our Services
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
Comptia IT Fundmantals Course Content / Exam(s)
Schedule for Comptia IT Fundmantals | ||
Course# | Course Contents | Exam# |
CompTIA IT Fundamentals | FC0-U51 |
2 Hours Daily 3 Times a Week
Total Duration 3 Months
- 1