- MS Excel Basics
Microsoft Excel Advanced: Participant Guide 10 Conditional Formatting Conditional formatting in Excel enables you to highlight cells with a certain color depending on the cell's value. Using this feature can make analyzing data easier by applying visual styles to the data. Navigate to the Conditional Formatting spreadsheet. Excel 2007 Training Manual ACUIA June 2013 Excel 2007 Page 9 Changing the look of your PivotTable 1. Click the ‗Design‘ ribbon on the access toolbar (see Exhibit 1-9). From here, you can add color to your PivotTable, add banded rows and columns, and include subtotals. EXHIBIT 1-9 Updating your PivotTable when data is added to your dataset 1.
- Editing Worksheet
- Formatting Cells
- Formatting Worksheets
- Working with Formula
- Advanced Operations
- MS Excel Resources
- Selected Reading
Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.
Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.
Acer drivers. By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.
This tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications.
Before proceeding with this tutorial, you should have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations.