Microsoft Excel 2010
PDF Link:- View
Downloading Update coming soon Download PDFMicrosoft Excel 2010
Introduction:
Microsoft released Microsoft Excel 2010 in 2009, featuring many improved functionalities compared to previous versions. A significant change from Excel 2003 to Excel 2007 was the introduction of the ribbon in the user interface (UI), replacing the collection of menus and toolbars with a single ribbon mechanism. Excel 2010 maintains the ribbon and introduces some new features. The ribbon in Excel 2010 is fully customizable, whereas the ribbon in Excel 2007 is not.
In addition to changes in the ribbon, the default background color in Excel 2010 is now grey, whereas the 2007 Office system background was blue. Excel 2010 enables more ways to manage and share information than its predecessors, facilitating better decision-making.
New Features of Excel 2010:
User Interface: The Excel 2010 user interface is redesigned and now uses the Microsoft Office Fluent user interface (UI), introduced in the 2007 Microsoft Office system. The Fluent UI is designed to make it easier for users to find and use the full range of features that Office applications provide.
The Ribbon: The ribbon is designed to make commands easier to use, providing quicker access to all commands in Excel 2010. It allows for easier future additions and customizations. In Excel 2010, users can customize the ribbon, creating custom tabs and groups to contain frequently used commands. The ribbon can also be hidden while working to maximize document space.
Backstage View: The Microsoft Office Backstage is a companion feature to the ribbon. Accessed from the File menu, the Backstage view helps manage Word documentation files, replacing the Microsoft Office Button and File menu used in earlier releases. It is used to manage files and their data, such as creating and saving files.
Sparklines: Sparklines are a new visualization feature in Excel 2010. They are small, cell-sized graphics used to show trends in a series of values through line, column, or win/loss charts. Sparklines allow viewers to see information-dense graphics in a single cell, enhancing the reader's comprehension of the data.
Slicers: Slicers make filtering and interpreting data easier, improving PivotTables and CUBE functions in a workbook. Slicers interactively float above the grid, behaving like report filters, and can be linked to PivotTables, PivotCharts, or CUBE functions to create interactive reports or dashboards.
New Statistical Functions: The function library in Excel is improved in Excel 2010. Accuracy, consistency, and a new functions user interface are added, with new algorithms implemented to improve the accuracy of statistical, financial, and math functions.
Backstage View: The new Backstage view replaces the traditional File menu, making all file management tasks available in Backstage. Options for saving and publishing worksheet data to a SharePoint site are conveniently located in the Share tab in Microsoft Office Backstage.
Compatibility Mode Tool: New features in Excel 2010 are disabled when opening previous versions of Excel. For instance, the new 2010 Sparklines and Slicers features are disabled when opening earlier versions of Excel. Workbooks created in the Excel 97-2003 file format (.xls) automatically open in Compatibility Mode. Workbooks created in Excel 2010 but destined for users with earlier Excel versions should turn on Compatibility Mode to prevent accidental use of incompatible functions and features.
PivotTable Enhancements: PivotTables are easier and faster to use in Excel 2010. Multithreading helps speed up data retrieval, sorting, and filtering in PivotTables.
Filtering: Large worksheet filtering enables quick location and display of specific data in tables and PivotTable views. The new search filter capability reduces time spent sifting through large data sets.
Conditional Formatting: Conditional formatting allows references to be made to different sheets in the workbook. It helps discover and display important trends and highlight data exceptions. More styles, data bar options, and new icon sets are made available. References to other worksheets are allowed in conditional formatting rules, and the dependencies of the formulas used are stored, reducing the need for frequent reevaluation of the entire conditional format.
Starting Microsoft Excel 2010: To start Microsoft Excel 2010 on the Windows 7 operating system, follow these steps:
- Click on the Start button.
- Click on the Programs folder.
- Click on the Microsoft Office folder.
- Click on Microsoft Office Excel 2010.
OR,
Directly type "Microsoft Office Excel 2010" in the search programs and files box. Then, click on Microsoft Office Excel 2010 to open it.
Parts of Excel 2010: The user interface of the Excel 2010 window is similar to that of Excel 2007. The only difference is that the Ribbon is customizable in 2010, and the Office button is replaced by the File menu. The main parts of Microsoft Excel 2010 are given below:
Creating a New Workbook: To create a new workbook in Excel 2010, follow these steps:
- Click on the File menu and click on the New option.
- The available template list appears on the right pane.
Step 2:
- If you want to create a new worksheet from another template, select the desired template by clicking the respective template folder and selecting the desired template.
- After selecting any desired template, click on the create button.
- If you want to use an online template, search for the desired template from the Office online template or type your template name in the Office online search box and press the enter key. Then, click on the Download button.
Saving: To save a workbook, follow these steps:
- Click on the File menu and click on the Save As option, then the Save As dialog box appears.
- Select the required location and type the name in the file name box.
- Click on the Save button.
Opening an Existing Workbook: To open an existing file, follow these steps:
- Click on the File menu and click on the Open option; then the open dialog box appears.
- Go to the required location and select the desired file that you want to open, then click on the Open button.
Here, we will learn only the new features included in Excel 2010 because most of the things are similar to those in Excel 2007 that you have already learned in previous chapters. Let's learn some new things.
Using Sparklines to Visualize Data Within a Single Cell: With Sparklines, a new feature in Excel 2010, you can create small charts in a single cell to quickly discover patterns in your data. It's a quick and easy way to highlight important data trends, such as seasonal increases or decreases, saving you time. To do this, follow these steps:
- Select an empty cell or group of empty cells in which you want to insert one or more sparklines.
- On the Insert tab, in the Sparklines group, click the type of sparkline that you want to create: line, column, or win/loss.
- In the Data box, type the range of the cells that contain the data on which you want to base the sparklines.
Conditional Formatting in Excel 2010: Conditional Formatting in Excel 2010 gives you more control over styles and icons, improved data bars, and the ability to highlight specific items.
PDF Link:- View
Microsoft Excel 2010
Introduction:
Microsoft released Microsoft Excel 2010 in 2009, featuring many improved functionalities compared to previous versions. A significant change from Excel 2003 to Excel 2007 was the introduction of the ribbon in the user interface (UI), replacing the collection of menus and toolbars with a single ribbon mechanism. Excel 2010 maintains the ribbon and introduces some new features. The ribbon in Excel 2010 is fully customizable, whereas the ribbon in Excel 2007 is not.
In addition to changes in the ribbon, the default background color in Excel 2010 is now grey, whereas the 2007 Office system background was blue. Excel 2010 enables more ways to manage and share information than its predecessors, facilitating better decision-making.
New Features of Excel 2010:
User Interface: The Excel 2010 user interface is redesigned and now uses the Microsoft Office Fluent user interface (UI), introduced in the 2007 Microsoft Office system. The Fluent UI is designed to make it easier for users to find and use the full range of features that Office applications provide.
The Ribbon: The ribbon is designed to make commands easier to use, providing quicker access to all commands in Excel 2010. It allows for easier future additions and customizations. In Excel 2010, users can customize the ribbon, creating custom tabs and groups to contain frequently used commands. The ribbon can also be hidden while working to maximize document space.
Backstage View: The Microsoft Office Backstage is a companion feature to the ribbon. Accessed from the File menu, the Backstage view helps manage Word documentation files, replacing the Microsoft Office Button and File menu used in earlier releases. It is used to manage files and their data, such as creating and saving files.
Sparklines: Sparklines are a new visualization feature in Excel 2010. They are small, cell-sized graphics used to show trends in a series of values through line, column, or win/loss charts. Sparklines allow viewers to see information-dense graphics in a single cell, enhancing the reader's comprehension of the data.
Slicers: Slicers make filtering and interpreting data easier, improving PivotTables and CUBE functions in a workbook. Slicers interactively float above the grid, behaving like report filters, and can be linked to PivotTables, PivotCharts, or CUBE functions to create interactive reports or dashboards.
New Statistical Functions: The function library in Excel is improved in Excel 2010. Accuracy, consistency, and a new functions user interface are added, with new algorithms implemented to improve the accuracy of statistical, financial, and math functions.
Backstage View: The new Backstage view replaces the traditional File menu, making all file management tasks available in Backstage. Options for saving and publishing worksheet data to a SharePoint site are conveniently located in the Share tab in Microsoft Office Backstage.
Compatibility Mode Tool: New features in Excel 2010 are disabled when opening previous versions of Excel. For instance, the new 2010 Sparklines and Slicers features are disabled when opening earlier versions of Excel. Workbooks created in the Excel 97-2003 file format (.xls) automatically open in Compatibility Mode. Workbooks created in Excel 2010 but destined for users with earlier Excel versions should turn on Compatibility Mode to prevent accidental use of incompatible functions and features.
PivotTable Enhancements: PivotTables are easier and faster to use in Excel 2010. Multithreading helps speed up data retrieval, sorting, and filtering in PivotTables.
Filtering: Large worksheet filtering enables quick location and display of specific data in tables and PivotTable views. The new search filter capability reduces time spent sifting through large data sets.
Conditional Formatting: Conditional formatting allows references to be made to different sheets in the workbook. It helps discover and display important trends and highlight data exceptions. More styles, data bar options, and new icon sets are made available. References to other worksheets are allowed in conditional formatting rules, and the dependencies of the formulas used are stored, reducing the need for frequent reevaluation of the entire conditional format.
Starting Microsoft Excel 2010: To start Microsoft Excel 2010 on the Windows 7 operating system, follow these steps:
- Click on the Start button.
- Click on the Programs folder.
- Click on the Microsoft Office folder.
- Click on Microsoft Office Excel 2010.
OR,
Directly type "Microsoft Office Excel 2010" in the search programs and files box. Then, click on Microsoft Office Excel 2010 to open it.
Parts of Excel 2010: The user interface of the Excel 2010 window is similar to that of Excel 2007. The only difference is that the Ribbon is customizable in 2010, and the Office button is replaced by the File menu. The main parts of Microsoft Excel 2010 are given below:
Creating a New Workbook: To create a new workbook in Excel 2010, follow these steps:
- Click on the File menu and click on the New option.
- The available template list appears on the right pane.
Step 2:
- If you want to create a new worksheet from another template, select the desired template by clicking the respective template folder and selecting the desired template.
- After selecting any desired template, click on the create button.
- If you want to use an online template, search for the desired template from the Office online template or type your template name in the Office online search box and press the enter key. Then, click on the Download button.
Saving: To save a workbook, follow these steps:
- Click on the File menu and click on the Save As option, then the Save As dialog box appears.
- Select the required location and type the name in the file name box.
- Click on the Save button.
Opening an Existing Workbook: To open an existing file, follow these steps:
- Click on the File menu and click on the Open option; then the open dialog box appears.
- Go to the required location and select the desired file that you want to open, then click on the Open button.
Here, we will learn only the new features included in Excel 2010 because most of the things are similar to those in Excel 2007 that you have already learned in previous chapters. Let's learn some new things.
Using Sparklines to Visualize Data Within a Single Cell: With Sparklines, a new feature in Excel 2010, you can create small charts in a single cell to quickly discover patterns in your data. It's a quick and easy way to highlight important data trends, such as seasonal increases or decreases, saving you time. To do this, follow these steps:
- Select an empty cell or group of empty cells in which you want to insert one or more sparklines.
- On the Insert tab, in the Sparklines group, click the type of sparkline that you want to create: line, column, or win/loss.
- In the Data box, type the range of the cells that contain the data on which you want to base the sparklines.
Conditional Formatting in Excel 2010: Conditional Formatting in Excel 2010 gives you more control over styles and icons, improved data bars, and the ability to highlight specific items.
Please wait for the Next Post to appear in:
