![]() This chapter shows how the spreadsheet, the electronic counterpart of the paper ledger, has evolved in Excel, taking advantage of the features of the associated versions of Microsoft Office, and the operating systems (Windows 7, Windows Vista, and Windows XP). Link to Workbooks Create External References Styles of Reference Source Workbook Changes Apply the Updates Turn Off the Prompt Excel in Word Publish as PDF (or XPS) Save on the Web Access the SkyDrive Folder Share Workbooksġ71 172 174 176 177 178 179 180 182 183 185 186 ![]() ![]() Templates Online Templates More Excel Resources What-If Analysis Summary Reports Goal Seek Optimization Project Worksheet Solver ![]() Number Formats Text Formats Relative References Absolute References Name References Operators Calculation Sequence Functions AutoSum Formula Errors Add CommentsĬreate an Excel Table Edit Tables Table Styles Table Totals Count Unique Entries Structured References Calculated Columns Insert Rows Custom Sort Print a Table Summarize a Table Convert to a RangeĪudit Formulas Protect Formulas Check for Errors Backup AutoSave and AutoRecovery Startup Switches Create a Shortcut Ribbon KeyTips Using KeyTips Minimize the Ribbon Quick Access Toolbar Mini Toolbar Print WorksheetsĬreate a Chart Default Chart Type Change Chart Layout Legend and Data Table Change Chart Type Pie Chart 3-D Pie Chart 3-D Column Chart Share Data Line Chart Stock Chart Mixed Types Print Charts Use Existing Data Import Data Navigate the Worksheet Scroll with Wheel Mouse Navigate with Keystrokes Sort Rows Find Entries Filter Information Remove Duplicate Entries Check Spelling Freeze Headers and Labels Hide Columns or Rows Protect a WorksheetĢ1 22 24 25 26 28 29 30 31 32 34 35 36 37ģ9 40 42 44 46 47 48 49 50 52 53 54 55 56įunction Library Logical Functions Lookup/Reference Functions Financial Functions Date & Time Functions Text Functions Math & Trig Functions Random Numbers Other Functions: Statistical Other Functions: Engineering Excel Add-ins Evaluate Formula The Excel Window Create a Workbook Add Data to the Worksheet Build the Worksheet Fill Cells Complete the Worksheet Format the Text Number Formats Print the Worksheet Insert, Copy and Paste Excel Help Contextual Help Excel File Formats The Spreadsheet Concept Microsoft Excel Microsoft Office 2010 Features of Excel 2010 System Requirements The Office 2010 Ribbon Office Starter Edition Excel Starter 2010 Excel 2010 and Windows XP Excel 2010 and Windows 7 Menu to Ribbon Reference ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |