Microsoft Excel 2010

Microsoft Excel is a spreadsheet application often installed by default as part of the Microsoft Office suite on business computers. Excel workbooks contain individual worksheets, which you can use to create lists and spreadsheets. It can be used to store and retrieve numerical data in a grid format of columns and rows. It is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions.


Duration:45 hours
Validity:1 month
Cost:

Rs.3,450.00

Who uses Excel?

Business Owners, Teachers, Office Workers, Accountants and people who use computer for businesses (like tracking expenses, accounting, auditing, etc.), all of them use Excel – It is a staple in their work-life!

Microsoft Excel is not merely a book-keeper’s tool, but it is also very useful for scientific and engineering calculations. You can for example write basic mathematical models in which you can observe all the numerical consequences of changing any one variable.

 

Course Details

Microsoft Excel is an Electronic Spreadsheet Program and also one of the most used software applications of all time. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. It is a spreadsheet program that is used to manage, analyze, and present data. It includes many powerful tools that can be used to organize and manipulate large amounts of data, perform complex calculations, create professional-looking charts, enhance the appearance of worksheets, and more. Our Course provides you an overview of Excel 2010 user interface and covers how to perform basic tasks such as creating and saving workbooks, selecting cells, rows, and columns, entering and editing data, formatting text and numbers, positioning cell contents, applying cell styles, and getting help.

 

Course Overview

Introduction to Microsoft Excel

The lessons in this course provide opportunities to use some of the updated features and improvements in Microsoft Excel 2010, including:

  • Creating dynamic worksheets by using PivotTables
  • Combining data from multiple sources
  • Analyzing alternative data sets
  • Automating repetitive tasks by using Macros, etc. 
Setting up a Workbook
In this lesson, you will learn how to create & modify workbooks, modify worksheets and customize the Excel 2010 program window.
Working with Data and Excel Tables
In this chapter, you will learn how to enter & revise data, move data within a workbook, find & replace data, correct & expand upon worksheet data, define Excel tables.
Performing Calculations on Data
In this chapter, you will learn how to name groups of data, create formulas to calculate values, summarize data that meets specific conditions, find and correct errors in calculations.
Changing Workbook Appearance
In this chapter, you will learn how to format cells, define styles, apply workbook themes and Excel table styles, make numbers easier to read, change the appearance of data based on its value and add images to worksheets.
Focusing On Specific Data by Using Filters
In this chapter, you will learn how to limit data that appears on your screen, manipulate worksheet data and define valid sets of values for ranges of cells.
Reordering and Summarizing Data
In this chapter, you will learn how to sort worksheet data, organize data into levels and look up information in a worksheet.
Combining Data from Multiple Sources
In this chapter, you will learn how to use workbooks as templates for other workbooks, link to data in other worksheets and workbooks, consolidate multiple sets of data into a single workbook and group multiple sets of data.
Analyzing Alternative Data Sets
In this chapter, you will learn how to define an alternative data set, define multiple alternative data sets, vary your data to get a desired result by using Goal Seek, find optimal solutions by using Solver and analyze data by using descriptive statistics.
Creating Dynamic Worksheets by Using PivotTables
In this chapter, you will learn how to analyze data dynamically by using PivotTables. You will learn how to filter, show, hide, edit & format PivotTable and its data. You also get to learn how to create PivotTables from external data.
Creating Charts and Graphics
In this chapter, you will learn how to create charts, customize the appearance of charts, find trends in your data, summarize your data by using sparklines, create dynamic charts by using PivotCharts, create diagrams by using SmartArt, create shapes and mathematical equations.
Printing
In this chapter, you will learn how to add headers & footers to printed pages, prepare worksheets for printing, print worksheets, print parts of worksheets and print charts.
Automating Repetitive Tasks by Using Macros
In this chapter, you will learn how to enable and examine macros, create and modify macros, run macros when a button is clicked and run macros when a workbook is opened.
Working With Other Microsoft Office Programs
In this chapter, you will learn how to include Office documents in workbooks, store workbooks as parts of other Office documents, create hyperlinks and paste charts into other documents.
Backstage View and File Menu
Microsoft added the Ribbon to Excel 2010 to make working in your spreadsheet easier. In this chapter, you will learn how to use Microsoft’s typical WYSIWYG interaction model for a command and other features.
Excel Web App And Other Ways To Share Workbooks
After creating your workbooks in Excel, you will probably want to share those workbooks with co-workers, managers, or employees. In this lesson, you learn how to do this and how Excel 2010 offers many more ways to share a workbook than previous Excel versions.
Keyboard Shortcuts
This chapter points out which of the old keyboard shortcuts still work, shows you some new shortcuts and introduces you to the new keyboard accelerators.

Check out our sample video tutorials

Duration:

45 hours

Validity:

1 month

Cost:

Rs.3,450.00

This course is interactive and not taught in real-time. So you can login at your convenience and do your classes and exercises. Our interactive interface offers useful features such as fast forward, rewind, pause and you can even redo a lesson before moving ahead. These features help you track your progress and learn just what you want. Included are project files to allow you to learn right along with the instructor using the exact same files that they use. Each individual lesson has been provided with an eBook and a quiz to test your knowledge of each lesson before you take your final test. In addition to this hands-on learning experience, our trainers will evaluate your course work, clarify questions and give relevant feedback to help you grow