Overview of A+ Exam

The A+ Essentials exam is the first of CompTIA’s two exams required for
completing the A+ certification. The A+ certification is an entry-level certification for those individuals who wish to pursue their careers in computer hardware and software support. The candidate must pass two exams in order to get his + certification.

You can choose one of the other three elective exams—IT Technician Exam 220-602, Remote Support Technician Exam 220-603 or Depot Technician Exam 220-604—to get an appropriate A+ certification. The second part of this book (Chapters 4, 5, and 6) covers the elective exams. The main focus of the A+ Essentials exam is to test your knowledge on the basics of computer hardware. The exam focuses on your skills to install, build, upgrade, repair, configure, troubleshoot, optimize, diagnose problems, and to perform preventive maintenance of personal computers and the installed operating systems.

Aside from testing your knowledge of computer components and operating systems, this exam also covers networking concepts and printing and scanning devices. It has recently been revised to include newer areas of study, such as computer security, safety and environmental issues, and communications and professionalism. Another new area is the knowledge of laptops and portable devices. In each of the study areas, you are expected to be skilled in identifying individual computer components as well as in installing, upgrading, and configuring them. You must also have hands-on experience in optimizing performance, using appropriate tools to diagnose problems, and performing preventive maintenance.

Microsoft Excel Training

Home
Objectives
Presentation
Quiz
Exercises
Demonstration

Required attachments will be given during the training


Welcome to Microsoft Excel

This site is set for Microsoft Excel users to get hands on in just few days.It consists of Lecture Notes, Quiz's, Exercise's and many other tools to aid to prepare you to work with Microsoft Excel.

Microsoft Excel (full name Microsoft Office Excel) is a proprietary spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and, except for Excel 2008 for Mac OS X, a macro programming language called VBA (Visual Basic for Applications). It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993, and is bundled as part of Microsoft Office. Excel is one of the most popular microcomputer applications to date.
-------------------------------------------------------------------------------------
Objectives

Spreadsheet Basics

* Screen elements
* Adding and renaming worksheets
* The standard toolbar - opening, closing, saving, and more.

Modifying A Worksheet

* Moving through cells
* Adding worksheets, rows, and columns
* Resizing rows and columns
* Selecting cells
* Moving and copying cells
* Freeze panes
* Exercise

Formatting Cells

* Formatting toolbar
* Format Cells dialog box
* Dates and times
* Styles
* Style dialog box
* Create a new style
* Format Painter
* AutoFormat
* Exercise

Formulas and Functions

* Formulas
* Linking worksheets
* Relative, absolute, and mixed referencing
* Basic functions
* Function Wizard
* Autosum
* Exercise

Sorting and Filling

* Basic ascending and descending sorts
* Complex sorts
* Autofill
* Alternating text and numbers with Autofill
* Autofilling functions
* Exercise

Graphics

* Adding clip art
* Add an image from a file
* Editing a graphic
* AutoShapes
* Exercise

Charts

* Chart Wizard
* Resizing a chart
* Moving a chart
* Chart formatting toolbar
* Copy a chart to Microsoft Word
* Exercise

Page Properties and Printing

* Page breaks
* Page orientation
* Margins
* Headers, footers, and page numbers
* Print Preview
* Print
* Exercise

Customizing Excel

* Menus
* Customize toolbars
* Recording a macro
* Running a macro
* Exercise

Project

* Based on the Objectives

-------------------------------------------------------------------------------------
Presentation

Powerpoint Presentations are available for users to go through.

Introduction

Working with Data