Sinopsis
Microsoft Excel 2007 represents a major upgrade to this industry-standard powerhouse. The interactive video tutorials included on this training CD give an in-depth introduction to all the major features of the program, from entering and formatting data to the creation of complex formulas. Total running time: 4 hrs 17 mins Table of Contents Getting Started What can Excel do? Using the Excel Ribbon Using the Office button Using the Quick Access toolbar Creating a new workbook Moving around workbooks and worksheets Entering and Editing Data Editing cells and entering text AutoComplete, AutoFill and custom lists Entering and formatting numbers Entering and formatting dates Entering formulas with the AutoSum tool Undo and Redo Cut, Copy and Paste Drag and Drop Excel Formulas Formula basics Adding formulas to an invoice Operator precedence Relative and absolute references Using named ranges Calculating markup Formatting Cells Setting Font attributes Text alignment and text wrap Using the Format Painter Using Cell Styles Creating your own styles If statements Concatenation The SUMIF function COUNT, COUNTA and COUNTBLANK COUNTIF and COUNTIFS Excel Functions If statements Concatenation The SUMIF function COUNT, COUNTA and COUNTBLANK COUNTIF and COUNTIFS Editing Cells, Columns and Rows Highlighting cells, rows and columns Setting column width Setting row height Inserting and deleting rows and columns Inserting and deleting cells Editing Worksheets Inserting and deleting sheets Renaming and colouring sheet tabs Reordering sheets Moving sheets between workbooks Hiding and unhiding sheets The Freeze Panes command Splitting a worksheet into panes Page Setup and Printing Using Quick Print Print Preview Excel's three page view modes Orientation, margins and page size Headers and Footers Print Titles Print Area Creating charts Anatomy of an Excel chart Creating a chart Manipulating charts Creating a column chart Creating a line chart Creating a pie chart Creating a bar chart Printing charts
Reseña del editor
Microsoft Excel 2007 represents a major upgrade to this industry-standard powerhouse. The interactive video tutorials included on this training CD give an in-depth introduction to all the major features of the program, from entering and formatting data to the creation of complex formulas. Total running time: 4 hrs 17 mins Table of Contents Getting Started What can Excel do? Using the Excel Ribbon Using the Office button Using the Quick Access toolbar Creating a new workbook Moving around workbooks and worksheets Entering and Editing Data Editing cells and entering text AutoComplete, AutoFill and custom lists Entering and formatting numbers Entering and formatting dates Entering formulas with the AutoSum tool Undo and Redo Cut, Copy and Paste Drag and Drop Excel Formulas Formula basics Adding formulas to an invoice Operator precedence Relative and absolute references Using named ranges Calculating markup Formatting Cells Setting Font attributes Text alignment and text wrap Using the Format Painter Using Cell Styles Creating your own styles If statements Concatenation The SUMIF function COUNT, COUNTA and COUNTBLANK COUNTIF and COUNTIFS Excel Functions If statements Concatenation The SUMIF function COUNT, COUNTA and COUNTBLANK COUNTIF and COUNTIFS Editing Cells, Columns and Rows Highlighting cells, rows and columns Setting column width Setting row height Inserting and deleting rows and columns Inserting and deleting cells Editing Worksheets Inserting and deleting sheets Renaming and colouring sheet tabs Reordering sheets Moving sheets between workbooks Hiding and unhiding sheets The Freeze Panes command Splitting a worksheet into panes Page Setup and Printing Using Quick Print Print Preview Excel's three page view modes Orientation, margins and page size Headers and Footers Print Titles Print Area Creating charts Anatomy of an Excel chart Creating a chart Manipulating charts Creating a column chart Creating a line chart Creating a pie chart Creating a bar chart Printing charts
"Sobre este título" puede pertenecer a otra edición de este libro.
