Excel 2010 (77-882)
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
12 Months
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
Completion Certificate awarded upon completion to show employers your new skills
Free upgrade on to our state of the art platform
12 Months unlimited Access
Excel 2010 (77-882)
Excel 2010 MOS Certification training courses prepare students for the MOS exams by teaching greater skill mastery in Microsoft Excel 2010. Candidates must pass one exam in order to earn the MOS credential.
The MOS exams provide a valid and reliable measure of technical proficiency and expertise in Microsoft Office Excel 2010 by evaluating the ability to use the advanced features in the product to solve real-world business problems.
In today’s competitive economic climate, having certifications that validate one’s skills are essential to “set yourself apart from the pack” in the marketplace. Having Microsoft certifications not only increase one’s marketability but also validates an employee’s skills and experience to a potential employer. IT University is committed to helping all of our students in their given profession and has designed this bundle specifically to help any Business, HR, Sales, Office, Administration or Accounting professional gain the skills and certification they need to help them attain the positions they desire.
In today’s marketplace computers are a part of daily life for almost everyone in an office setting. Many people spend hours on projects that could take minutes if they had the necessary training to expedite their day to day tasks.
Facilities
Location
Start date
Start date
About this course
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
Reviews
Subjects
- Excel
- Office IT
- Art
- MS Excel
- Ms Office
- Introducing
- Outline
- Existing
- Workbooks
- Templates
- Personalizing
Course programme
Introduction
- Course Outline
- Introducing Excel 2010
- The Excel Interface
- Keyboard Shortcuts
- Section Review
- Creating, Saving and Closing Workbooks
- Personalizing Files and Opening Workbooks
- Viewing Existing Workbooks and Applying Templates
- Keyboard Shortcuts
- Section Review
- Creating and Managing Worksheets
- Navigating the Worksheets
- Keyboard Shortcuts
- Section Review
- Worksheet Basics and Cell Range Selection
- Entering Cell Content and Multiple Cells
- AutoContent and Undo, Redo and Repeat
- Updating and Clearing Cell Content
- Inserting and Deleting, Rows and Columns
- Copying, Cutting, Pasting and Moving Contents
- Keyboard Shortcuts
- Section Review
- Formatting Cells and Applying Formats
- Alignment
- Merging Cells and Cell Styles
- Numbers
- Apply and Modify Formats
- Using Table Features
- Keyboard Shortcuts
- Section Review
- Creating Formulas
- Using Cell References
- Managing and Updating Formulas
- Creating Functions
- Conditional Statements
- Error Messages
- Keyboard Shortcuts
- Section Review
- Find and Replace
- Sorting
- Filtering
- Conditional Formatting and Keyboard Shortcuts
- Section Review
- Naming Cells and Ranges
- Hyperlinks
- Section Review
- Charting
- Layout Chart Element Options and Format
- Spark lines
- Keyboard shortcuts
- Section Review
- Preparing to Print with Page Layouts
- Section Review
- Sharing a Document and Managing Comments
- Section Review
- Inserting and Formatting Pictures
- Inserting and Formatting Clip Art
- Inserting and Formatting Shapes, Word Art and Text Boxes
- Inserting and Formatting Smart Art
- Keyboard Shortcuts
- Section Review
- Section Review
- Course Review
Excel 2010 (77-882)