ABOUT THIS COURSE

Microsoft Excel 2010 is spreadsheet software designed to perform basic and complex mathematical computations and functions. This is a Beginner course of Microsoft Excel 2010 covering the topics Start with Excel, Cell Basics, Columns and Rows, Saving, Simple Formulas, Printing, Sorting, Outlining, Filtering, Formatting Table etc. This Microsoft Excel tutorial will be a right start for a person who chooses for this course can learn Simple mathematical computations of Microsoft Excel. This Excel online course will mold you to do mathematical computation in Microsoft Excel 2010. YOU CAN REGISTER FOR THE COURSE NOW

COURSE DESCRIPTION

Course includes 12 chapters of Microsoft Excel 2010 and the Course contains 50 Demos in Microsoft Excel 2010 Beginner Course. This will take about 3 Hours. This is a paid course..

WHAT AM I GOING TO GET FROM THIS COURSE

After learning Microsoft Excel 2010 Beginner Course, you will understand and do Start with Excel, Cell Basics, Columns and Rows, Saving, Simple Formulas, Printing, Sorting, Outlining, Filtering, Formatting Table ..

PREREQUISITES

You will need to have a Note Book and Pen to write Microsoft Excel 2010 Beginner Notes. Microsoft Excel 2010 Software is required..

TARGET AUDIENCE

If you are new to Microsoft Excel Spreadsheet, then you can learn Microsoft Excel 2010 Beginner. Everyone who likes to Improve their Skills and more Productive at Work can choose this course and who wants to Learn basic mathematical computations can choose this course..

Course Curriculum

Section 1: Getting Started with Excel
Lesson Objectives
Introduction
The Excel Interface
The Ribbon
The Quick Access Toolbar
Backstage View
Creating and Opening Workbooks
Compatibility Mode
Convert a Workbook
Frequently asked questions
Exam
Section 2: Cell Basics
Lesson Objectives
Introduction
The Cell
Select Single and Multiple Cells
Insert and Delete Cell Content and Delete Cells
Copy & Paste and Cut & Paste Cell Content
Access More Paste Options
Frequently asked questions
Exam
Section 3: Modifying Columns, Rows and Cells
Lesson Objectives
Introduction
Modify Column Width
Modify Row Height
Insert Rows and Columns
Delete Rows and Columns
Wrapping Text and Merging Cells
Frequently asked questions
Exam
Section 4: Formatting Cells
Lesson Objective
Introduction
Change Font and Font Size
Use the Bold, Italic Underline and Border Commands
Font Color and Fill Commands
Text Alignment Commands
Formatting Numbers and Dates
Frequently asked questions
Exam
Section 5: Saving
Lesson Objective
Introduction
Use Save as Command
Use Auto Recover
Save as an Excel 97-2003 Workbook and as PDF
Frequently asked questions
Exam
Section 6: Creating Simple Formulas
Lesson Objectives
Introduction
Creating Simple Formulas
Creating Formulas with Cell References
Create a Formula Using the Point and Click Method
Edit a Formula
Frequently asked questions
Exam
Section 7: Worksheet Basics
Lesson Objectives
Introduction
Rename, Insert and Delete a Worksheet
Copy and Move a Worksheet
Color Worksheet Tabs
To Group and Ungroup Worksheets
Freeze and Unfreeze Worksheet Panes
Frequently asked questions
Exam
Section 8: Printing
Lesson Objectives
Introduction
View Print Pane and Print Selection
Change page orientation
Fit a worksheet on one page
Modify margins while in Print Preview
Use Print Titles
Insert a Break
Frequently asked questions
Exam
Section 9: Sorting Data
Lesson Objectives
Introduction
Sort in Alphabetical, Numerical and Date or Time Order
Custom sorting
Sort by Cell Color, Font Color, or Cell Icon
Sorting Multiple Levels
Frequently asked questions
Exam
Section 10: Outlining Data
Lesson Objectives
Introduction
Outlining Data using Subtotal
Showing and Hiding Data
Removing Groups and Subtotaling
Creating your Own Groups
Frequently asked questions
Exam
Section 11: Filtering Data
Lesson Objectives
Introduction
Filter and Clear Filtered data
Search Filter and Text Filter
Know Date Filter and Number Filter
Frequently asked questions
Exam
Section 12: Formatting Tables
Lesson Objectives
Introduction
Format information as a table
Modifying tables
Frequently asked questions
Exam

Use of this site is subject to express terms of use. By continuing past this page, you agree to abide by these terms.