Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

Excel 2013 in Easy Steps

by: Michael Price

On-line Price: $16.95 (includes GST)

Paperback package 192

32%Off Retail Price

You save: $8.00

CLEARANCE Item - Special discount -limited stock
_____________________
N.Sydney : In Stock

Retail Price: $24.95

Publisher: In Easy Steps,30.07.13

Category: Level: B/I/A

ISBN: 1840785748
ISBN13: 9781840785746

Add to Shopping Cart

Excel 2013 in easy steps shows the user how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application. The guide uses detailed images and easy-to-follow instructions to get users up to speed with Excel, whether they are just upgrading from a previous version or are a new user.

Table of Contents:
1. Introduction -- The Spreadsheet Concept -- Microsoft Excel -- Microsoft Office 2013 -- System Requirements -- Excel 2013 under Windows 7 -- Excel 2013 and Windows 8 -- The Office 2013 Ribbon -- Exploring Excel 2013 -- Excel Office Web App -- 2. Begin with Excel -- 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 -- 3. Manage Data -- Use Existing Data -- Import Data -- Navigate the Worksheet -- Scroll with Wheel Mouse -- Keystrokes and Touch -- Sort Rows -- Find Entries -- Filter Information -- Remove Duplicate Entries -- Check Spelling -- Freeze Headers and Labels -- Hide Columns or Rows -- Protect a Worksheet -- 4. Formulas and Functions -- Number Formats -- Text Formats -- Relative References -- Absolute References -- Name References -- Operators -- Calculation Sequence -- Functions -- AutoSum -- Formula Errors -- Add Comments -- 5. Excel Tables -- Create 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 -- 6. Advanced Function -- Function 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 -- 7. Control Excel -- Audit Formulas -- Protect Formulas -- Check for Errors -- Backup -- AutoSave and AutoRecover -- Startup Switches -- Create a Shortcut -- Ribbon KeyTips -- Using KeyTips -- Collapse the Ribbon -- Quick Access Toolbar -- Mini Toolbar -- Print Worksheets -- 8. Charts -- Create 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 Price Data -- Line Chart -- Stock Chart -- Mixed Types -- Print Charts -- 9. Macros in Excel -- Macros -- Create Macros -- Record a Macro -- Apply the Macro -- View the Macro -- Macro to Make a Table -- Edit the Macro -- Use the Macro -- Create Macros with VBA -- Add Macros to the Toolbar -- Debug Macros -- 10. Templates and Scenarios -- Templates -- Online Templates -- Wore Excel Resources -- What-If Analysis -- Summary Reports -- Goal Seek -- Optimization -- Project Worksheet -- Solver -- 11. Links and Connections -- Link to Workbooks -- Create External References -- Styles of Reference -- Source Workbook Changes -- Apply the Updates -- Turn Off the Prompt -- Save Workbook Online -- Using Excel Web App -- Excel in Word -- Publish as PDF (or XPS) -- Index.