Visual Basic macros are no longer supported in Excel 2008 for Mac, which might make things a little difficult for you if you're used them a lot in the past, or if somebody else gives you spreadsheets using them. The Microsoft Office for Mac team shows you just how to deal with Visual Basic macros in this how-to video. 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.
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. 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
Alps md 1300 printer drivers for mac. 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 |
|
| |
![Microsoft excel 2008 for mac tutorial Microsoft excel 2008 for mac tutorial](https://i.ytimg.com/vi/iMO4Shnj1kI/maxresdefault.jpg)
Microsoft Excel 2008 For Mac Tutorial
HOMEEMPLOYERSTESTING CENTERSCERTIFICATION LISTINSURANCE QUOTESAFFILIATESCONTACT US
© 2002-2011 National Computer Science Academy, All Rights Reserved.
© 2002-2011 National Computer Science Academy, All Rights Reserved.