- Find training courses for Excel. Skip to main content. Excel for Mac Help. Excel 2013 training. Microsoft Store.
- Microsoft Office 2008 for Mac All-in-One For Dummies Cheat Sheet By Geetesh Bajaj, Jim Gordon Get the most out of Microsoft Office 2008 for Mac with handy tips for working in Office in general as well as word-processing in Word, making spreadsheets in Excel, creating PowerPoint slides, and e-mailing with Entourage.
Mar 01, 2008 The Microsoft Excel 2008 for Mac Quick Source guide is a clear and concise tool for learning the features in Excel 2008 for Mac. Features contained in this guide include NEW features such as Using the Elements Gallery, Using the Toolbox, Inserting an Equation, and Using the Objects Palette.
Free Exams! Test your skills with one of our certification exams and see how you stack up right now. Homepage Visit our homepage and find out more about what NCSA can do for you. Learn More About Us Find out more about how our certifications can benefit you. Course Descriptions View a complete listing of certifications available through NCSA. Microsoft Office 2003 HTML Tag Library Visit our HTML tag library, a free reference we provide to our visitors. Certificate Database Lookup a certification in our online database. QuickBooks Enterprise Solutions 8.0: Contractor Edition targets growing and mid-sized contracting businesses and comes in five-, 10-, 15- and 20-user versions. It has the capacity to handle the. Quickbooks Enterprise Solutions 8.0 Download Search Tips Your search for Quickbooks Enterprise Solutions 8.0 may return better results if you avoid searching for words like: crack, serial, keygen, activation, code, hack, cracked, etc. Crack quickbooks enterprise free. Affiliate Program Make money by helping people get the computer training and certification they need. Sign-up Here! Support Center If you have questions or concerns feel free to visit our online support center. |
Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including: |
Customers Include:
|
|
Course Highlights
About This Course This Microsoft Office Excel course teaches you how to effectively use the Excel for Mac through comprehensive lessons and engaging quizzes, allowing the user to choose which lesson to learn. New users will be guided through the fundamentals of the Excel 2008 for Mac interface, while experienced users will be brought up to speed on the new navigation and functionality of this 2008 edition. Microsoft Excel for Mac 2008: Beginner 1.0 Getting Started 1.1 Launching Excel 2008 1.2 Touring the Excel Window 1.3 Save vs. Save As 1.4 About XML 1.5 Opening & Closing Files 1.6 Getting Help 2.0 Entering Data 2.1 Navigation Techniques 2.2 Data Entry Techniques 2.3 AutoFill 2.4 AutoComplete 2.5 Undo & Redo 3.0 Changing Worksheet Layout 3.1 Inserting Rows, Columns & Cells 3.2 Deleting Rows, Columns & Cells 3.3 Adjusting Column Widths & Row Heights 3.4 Hiding Columns & Rows 3.5 Moving & Copying Data 3.6 Creating Named Ranges 3.7 Go To, Find and Replace 4.0 Entering Formulas 4.1 Anatomy of Formula 4.2 AutoSum 4.3 Basic Functions 4.4 Copying Formulas 5.0 Formatting 5.1 Using the Formatting Palette 5.2 Number Formats 5.3 Merging & Splitting Cells 5.4 Using AutoFormat 6.0 Printing 6.1 Changing Margins & Page Orientation 6.2 Exploring Worksheet Views 6.3 Adding Headers & Footers 6.4 Adding Print Titles and a Print Area 6.5 Viewing & Setting Page Breaks 7.0 Charts 7.1 Creating an Embedded Chart 7.2 Creating a Chart Sheet 7.3 Adding & Removing Chart Data 7.4 Format & Resize Charts 8.0 Recap Microsoft Excel for Mac 2008: Intermediate 1.0 Managing Workbooks 1.1 Creating New Workbooks from a Template 1.2 Rename & Move Workbook Tabs 1.3 Insert & Delete Worksheets 1.4 Copy & Paste Worksheets 1.5 Splitting Your Worksheet View 1.6 Freezing & Unfreezing Your View 2.0 List & Data Management 2.1 List Guidelines 2.2 Sorting 2.3 AutoFilter 2.4 Advanced Filter Using Single Criteria 2.5 Advanced Filter Using Multiple Criteria 2.6 Automatic Subtotals 3.0 Using Cell References 3.1 Using Relative Cell References 3.2 Using Absolute Cell References 3.3 Using Mixed Cell References 4.0 Auditing 4.1 About Auditing 4.2 Tracing Precedents 4.3 Tracing Dependants 4.4 Tracing Errors 5.0 Creating Web Pages from Workbooks 5.1 Publishing a Web Page 5.2 Viewing Your Published Web Page 6.0 Using Excel with Other Applications 6.1 Importing Data to Excel 6.2 Exporting Data from Excel 6.3 About XML 7.0 Customizing Excel 7.1 Customizing Excel’s Toolbar 7.2 Modifying Excel Preferences 8.0 Using Scenarios & Watching Cells 8.1 Creating & Displaying Scenarios 8.2 Editing & Removing Scenarios 8.3 Summarizing Scenarios 9.0 PivotTables & PivotCharts 9.1 About PivotTables 9.2 Creating a PivotTable 9.3 Modifying a PivotTable 10.0 Recap Microsoft Excel for Mac 2008: Advanced 1.0 Collaborating 1.1 Inserting & Deleting Comments 1.2 Viewing & Printing Comments 1.3 Protect Workbooks, Worksheets & Cells 1.4 Enable Workbook Security 1.5 Share Workbooks 1.6 Working with Templates 2.0 Advanced Formulas & Functions 2.1 IF Functions 2.2 Nested IF Functions 2.3 Using the VLOOKUP Function 2.4 Using the HLOOKUP Function 2.5 Using the DSUM Function 3.0 Data Consolidation 3.1 About Data Consolidation 3.2 Three Dimensional Formulas 3.3 Data Consolidation by Position 3.4 Data Consolidation by Category 4.0 SmartArt 4.1 About SmartArt 4.2 Creating a List 4.3 Creating a Hierarchy 4.4 Creating a Pyramid 4.5 Editing SmartArt 5.0 Track Revisions 5.1 Tracking Changes 5.2 Accepting & Rejecting Changes 6.0 Data Validation & Conditional Formatting 6.1 Working with Data Validation Rules 6.2 Set Conditional Formatting 6.3 Use Expressions in Conditional Formatting 7.0 Recap |
|
| |
HOMEEMPLOYERSTESTING CENTERSCERTIFICATION LISTINSURANCE QUOTESAFFILIATESCONTACT US
© 2002-2011 National Computer Science Academy, All Rights Reserved.
© 2002-2011 National Computer Science Academy, All Rights Reserved.
by Greg Bowden (372 pages)
The Learning Microsoft Excel 2008 tutorials provide spreadsheet lessons to teach or learn Microsoft Excel 2008.
The Learning Microsoft Excel 2008 tutorials provide spreadsheet lessons to teach or learn Microsoft Excel 2008.
Module 1 introduces the Excel basics of entering labels, values and formulas, formatting cells and worksheets, copying cell data, creating charts and using the drawing tools. Module 2 introduces advanced Spreadsheet features including IF statements, Lookup commands, creating sales invoices, payroll/payslip systems, financial and date calculations, AutoFormat, styles and save options. Support files that provide all the images and data required to complete the activities are included with the product. |
Prices
- Chapters and Sample Pages
- Chapter Descriptions
Module 1: Excel 2008 Basics
Contents (Modules 1 & 2) | view pages (356k) |
Chapter 1: Introduction to Microsoft Excel (27 pages) | |
Chapter 2: Formatting Cells (26 pages) | view sample pages(1.07 MB) |
Chapter 3: Further Formatting (15 pages) | |
Chapter 4: Copying Cell Data (22 pages) | view sample pages(1.14 MB) |
Chapter 5: Larger Spreadsheets (18 pages) | |
Chapter 6: Using Worksheets (17 pages) | view sample pages(808k) |
Chapter 7: Displaying Data in Charts (16 pages) | |
Chapter 8: More Detailed Charts (23 pages) | |
Chapter 9: The Drawing Tools (24 pages) | view sample pages(1.09 MB) |
Module 1 Project (Multi- user version only) |
Module 2: Excel 2008 Advanced Exercises
Chapter 10: Making Predictions with Excel (12 pages) | |
Chapter 11: Making Decisions with Excel (21 pages) | view sample pages (831k) |
Chapter 12: Lookup Commands (11 pages) | |
Chapter 13: Creating Sales Invoices (30 pages) | view sample pages (1.27 MB) |
Chapter 14: Sharing Data Between Files (24 pages) | |
Chapter 15: Payroll Systems (20 pages) | view sample pages(752k) |
Chapter 16: Financial Applications (18 pages) | view sample pages(611k) |
Chapter 17: Date Calculations (13 pages) | |
Chapter 18: Useful Tools (11 pages) | |
Module 2 Project (Multi-user version only) |
The tutorials can be used onscreen next to the software package, from a tablet or printed. Assignments are provided at the end of each chapter and the multi-user version provides projects at the end of each module.
Module 1 Chapter Descriptions
Chapter 1: Introduction to Microsoft Excel
This chapter introduces:
- the components of the Excel screen
- moving around the spreadsheet
- entering labels and values
- entering formulas
- saving and printing
Chapter 2: Formatting Cells
This chapter introduces the basics of formatting the content of cells: It includes:
- formatting single cells and groups of cells
- formatting values to currency and per cent
- adjusting column widths and row heights
- using the format cells dialogue bo.
- approaches for creating spreadsheets
- using borders
- wrap text
Chapter 3: Further Formatting
This chapter demonstrates some more detailed cell formatting techniques, such as:
- using the Format Painter tool
- setting borders
- drawing and erasing borders
- border styles
- setting cell shading
- setting text colour
- centring across selection
- text wrapping within cells
- printing formulas
Chapter 4: Copying Cell Data
This chapter demonstrates the many cell duplicating commands that Excel provides. It includes:
- Fill Right, Fill Down and Fill Series
- AutoFill and AutoFill options
- Absolute and Relative references
- the AutoSum command
- application of the copy commands
Microsoft Excel Tutorials Pdf
Chapter 5: Rearranging Data
This chapter demonstrates how to manage larger spreadsheets and rearrange data within them. It includes:
- inserting rows and columns
- editing cells contents
- sorting labels and values
Chapter 6: Using Worksheets
![Free Free](https://i.ytimg.com/vi/NCjoqMCAgMU/maxresdefault.jpg)
This chapter demonstrates how to manage spreadsheet files using worksheets. It includes:
- copying data between worksheets
- duplicating a worksheet
- moving worksheets
- deleting worksheets
- setting tab colours
- creating worksheets for Equation Dumps
Chapter 7: Displaying Data in Charts
This chapter introduces simple chart creation techniques. It includes:
- setting the chart type
- setting chart layouts
- setting chart location
- modifying charts
- using the Chart tools
- changing the chart type
- exploding pie slices
- printing charts
- deleting charts
Chapter 8: More Detailed Charts
This chapter demonstrates the more detailed chart techniques, such as:
- plotting multiple column data
- changing axis scales
- formatting columns, axes and walls
- plotting charting in their own worksheet
- comparison charts
- custom charts
Chapter 9: The Drawing Tools
This chapter demonstrates some of the Drawing Tools that can be used to enhance a spreadsheet's appearance. It includes:
- shading cells.
- importing graphics and clip art.
- using shape tools.
- adding text to shapes.
- setting graphics properties
- using WordArt.
- using fill effects
Module 1 Project
The multi-user version provides a project for students to apply their spreadsheet skills:. It involves creating a payroll for the EasyTune Car Care company.
Module 2 Chapter Descriptions
Chapter 10: Making Predictions With Excel
Microsoft Excel 2008 Tutorial For Mac Torrent
This chapter covers how to use formulas to predict outcomes. It involves:
- predicting the income for a motel
- using manual prediction methods
- using the Goal Seek command
Chapter 11: Making Decisions With Excel
This chapter introduces the IF command which allows Excel to make decisions. It includes:
- simple IF statements
- using greater than, less than
- using greater than or equal to
- using AND and OR in IF statements
- Conditional formatting
Chapter 12: Lookup Commands
This chapter uses for the Lookup command. It includes:
- the structure of the Lookup command
- looking up a interest rate table
- creating an income tax calculation
- calculating real estate commissions
Chapter 13: Creating Sales Invoices
This chapter combines the use of IF and Lookup commands to produce sales invoices. It includes:
- formatting the invoice
- naming cells
- looking up stock values from a table
- using IF statements to ensure calculations are only carried out when values are entered
- turning zero values off
- creating a master invoice
- setting print areas
Chapter 14: Sharing Data Between Files
This chapter demonstrates how to link files so that it data is changed in one file other linked files are updated. It includes:
- naming cells
- linking an Office file to 3 Department file.
- editing cells contents
- looking at all 4 files at once
Chapter 15: Payroll Systems
This chapter how to create a payroll linked to payslips. It involves:
- completing a payroll worksheet
- linking a payslip worksheet to the payroll
- using link formulas
- setting macros and buttons to automate the payslips
Chapter 16: Financial Applications
This chapter demonstrates some examples of financial applications that spreadsheets can be used for, such as:
- an electronic cheque book
- a home loan simulator
- compound interest calculations
Chapter 17: Date Calculations
This chapter demonstrates some of the some of the calculations that can done on date values. It includes:
- a library overdues system
- extended IF formulas
- a debt collection system
Chapter 18: Useful Tools
This chapter demonstrates some useful tools that students can use when creating spreadsheets. It includes:
- Help Features
- Save options
- style and table formats
- Office 2010 vl edition. custom styles
- changing styles
- spell checking
Module 2 Project
The multi-user version provides a project for students to apply their spreadsheet skills. Students are required to create an invoice/stock list system for Quantum Electronics (a stereo systems manufacturer).
Home | Products | iPad | Downloads | Testimonials | Ordering | Contact Us |