Excel 2010 - Accelerated Learning & Certification Course

In this short course you will learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application - Microsoft Excel 2010. Gain confidence in creating and formatting spreadsheets and charts, sorting and filtering, advanced formulas and functions.

Course Features

Study from anywhere
Self-paced (You can choose to complete the course quickly)
Learning Materials provided

Put the international Microsoft Office Specialist qualification on your CV.

With the globally recognized Microsoft Office Specialist (MOS) certification, you can prove your skills with ease. Whether you’re looking for the ideal job, trying to advance in your present career, or pursuing academic goals, the MOS certification validates your skills, demonstrates your abilities, and gives you the advantage needed to advance in today's competitive academic and professional environments.

MOS is the internationally benchmarked qualification for desktop productivity. Qualified individuals enjoy formal recognition of their skills, increased potential for higher earnings and an average of 20% improvement in productivity. 87% of surveyed employers observed increased competency in their certified employees.

Your Excel 2010 Accelerated Learning & Certification Course contains everything you need to learn, practice and pass the 77-882 Microsoft Office Specialist Excel 2010 exam.

The Excel 2010 training contained in this course will cover the following topics:

Lesson 1: Introducing Excel What is Excel? Understanding Basic Terminology Mouse Symbols Using the Quick Access Toolbar Using the Ribbon Identifying Screen Symbols Types of Data Entering Text Entering Numbers Entering Dates and Times Inserting Symbols and Special Characters Moving Around the Worksheet Saving Workbooks Creating a New Workbook Switching Between Workbooks Opening a Workbook Closing a Workbook Working with the Compatibility Mode Managing Files and Folders	Lesson 2: Constructing Cell Data Editing Cells and Undoing Changes Cutting, Copying and Pasting Data Using the Office Clipboard Using Paste Special Copying and Moving Cells Using the Mouse Inserting Rows and Columns Deleting Rows and Columns Inserting and Deleting Cells Changing the Column Widths Adjusting the Row Height Using AutoFit Hiding/Unhiding Rows & Columns Finding Data Replacing Data Using AutoFill Renaming Worksheets Inserting or Deleting Worksheets Moving or Copying Worksheets Hiding/Unhiding Worksheets Adding Color to the Worksheet Tabs
Lesson 3: Using Formulas Creating and Editing Formulas Mathematical Operators Referencing Other Worksheets Common Excel Functions Conditional Functions Using Absolute Cell References Using Mixed Absolute and Relative Cell References Displaying and Printing Formulas	Lesson 4: Formatting the Worksheet Formatting Numbers and Decimal Digits Changing Cell Alignment Changing Fonts and Sizes Applying Cell Borders Using Colors and Patterns Paste With Live Preview Using the Format Painter Clearing Cell Contents and Formatting Applying Themes Modifying Themes Using Cell Styles Conditional Formatting Using the Ribbon Conditional Formatting Using the Rules Manager Conditional Formatting with IF Function
Lesson 5: Viewing and Printing Workbooks Creating and Arranging Worksheet Windows Splitting Panes Freezing Panes Changing the Zoom Printing and Previewing the Workbook Changing the Workbook Views Customising the Page Layout Setting Page Breaks Page Formatting Adding a Header or Footer Printing Titles or Range of Cells Printing Selected Worksheets Changing Excel Default Settings	Lesson 6: Working with Charts Creating a Basic Chart Moving and Resizing Charts Changing Chart Types Working with Pie Charts Changing the Chart Layout and Location Using Spaklines Printing Charts
Lesson 7: Working with Graphics Drawing Shapes Moving and Resizing Shapes Formatting Shapes Using WordArt Inserting Pictures and Clip Art Using the Image Editor Inserting Screenshots Modifying Graphics Objects Resizing, Reshaping and Scaling Objects Rotating Objects Using SmartArt Graphics	Lesson 8: Analyzing, Organizing and Sharing Workbooks Sorting by Single-Level Data Sorting by Multi-Level Data Filtering Information Working with Named Ranges Creating Named Ranges Modifying and Deleting Hyperlinks Using Comments Importing Data Files Exporting Data from Excel Changing Workbook Properties Sharing Workbooks Using E-mail Save To Web Using SharePoint

Validate Your Proficiency in Microsoft Office 2010

Professionals skilled in the latest Microsoft technologies are always in demand. This MOS certification will help you stand out as someone truly knowledgeable in Microsoft Office 2010 applications.

By completing this course, you're showing employers that you're able to work productively and efficiently with Microsoft Excel 2010.

Your Price:
$198.00 inc GST

Product Code / ISBN:
ATK3243-1

Related Products / Courses

	Access 2010 - Accelerated Learning & Certification Course Designed as an intensive individual program to assist users of Microsoft Outlook achieve a level of proficiency sufficient to allow them to successfully pass their International Certification Vendor exam. ATK3245-1	$198.00
	Outlook 2010 - Accelerated Learning & Certification Course Designed as an intensive individual program to assist users of Microsoft Outlook achieve a level of proficiency sufficient to allow them to successfully pass their International Certification Vendor exam. ATK3242-1	$198.00
	PowerPoint 2010 - Accelerated Learning & Certification Course Designed as an intensive individual program to assist users of Microsoft PowerPoint achieve a level of proficiency sufficient to allow them to successfully pass their International Certification Vendor exam. ATK3246-1	$198.00
	Word 2010 - Accelerated Learning & Certification Course Designed as an intensive individual program to assist users of Microsoft Word achieve a level of proficiency sufficient to allow them to successfully pass their International Certification Vendor exam. ATK3240-1	$198.00
	MOS 2010 Master - Accelerated Learning & Certification Course This MOS 2010 Master Course is designed as an all inclusive training program that will rapidly prepare you to successfully become a Microsoft Office 2010 Master. ALKMOS	$759.00

Excel 2010 - Accelerated Learning & Certification Course

Course Features

Put the international Microsoft Office Specialist qualification on your CV.

The Excel 2010 training contained in this course will cover the following topics:

Validate Your Proficiency in Microsoft Office 2010

Your Price: $198.00 inc GST

Related Products / Courses

Contact IC Central

Freecall 1300 44 55 60

Subscribe to our Mailing List

Contact IC Central

Freecall 1300 44 55 60

Your Price:
$198.00 inc GST