Excel 2010 Core-Microsoft Excel 2010 is the most powerful spreadsheet applications available today.

Microsoft Excel 2010 is the most powerful spreadsheet applications available today.

Excel 2010 Core

Microsoft Excel 2010 is the most powerful spreadsheet applications available today.

A brief summary

Microsoft Excel 2010 is one of the most powerful and widely used spreadsheet applications available today. Excel's functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world. The new version of Excel 2010 has a whole new look and feel along with many new features but you will not have to worry about spending a lot of time learning a new program. Instead, the new design and new features will help you organize your work more efficiently and help you complete your everyday tasks quickly. 

Instructor:

Prachi Sharma

What you will learn

Managing the worksheet environement

Creating Cell Data

Formatting Cells and Worksheets

Managing Worksheets and Workbooks

Applying Formulas and functions

Presenting Data Visually

Sharing Worksheet Data with Others

Analysing and Organising Data

Course Fee: Rs. 1500.00

Certification By: Millionlights

Managing the Worksheet Environment, Creating Cell Data

Navigate through a worksheet, Print a worksheet or workbook, Personalize environment by using Backstage, Construct cell data, Apply AutoFill, Apply and manipulate hyperlinks

Formatting Cells and Worksheets

Apply and modify cell formats, Merge or split cells, Create row and column titles, Hide and unhide rows and columns, Manipulate Page Setup options for worksheets, Create and apply cell styles

Managing Worksheets and Workbooks, Applying Formulas and Functions

Create and format worksheets, Manipulate window views, Manipulate workbook views, Create formulas, Enforce precedence, Apply cell references in formulas, Apply conditional logic in a formula (<,>,=), Apply named ranges in formulas, Apply cell ranges in formulas

Presenting Data Visually, Sharing worksheet data with other users

Create charts based on worksheet data, Apply and manipulate illustrations, Create and modify images by using the Image Editor, Apply Sparklines, Share spreadsheets by using Backstage, Manage comments

Analyzing and Organizing Data

Filter data, Sort data, Apply conditional formatting

Back to top