Excel 101
Initial Knowledge
- 084890dd.exe: Installs a folder named 084890Data on your C drive. This folder contains all the data files that you will use to complete this course.
- 084890s3.doc: Pre-test/Post-test
- Excel2007ExamMapping.doc: Tells you how the skills you learn here will map to the Microsoft Certified Application Specialist (MCAS) Certification Exam.
- ol84-890.rtf: Outline of the course
- PowerPoint Slides (coming soon)
Course Content
Lesson 1: Creating a Basic Worksheet
- Topic 1A: Explore the User Interface and the Ribbon
- Topic 1B: Navigate and Select in Excel
- Topic 1C: Obtain Help
- Topic 1D: Enter Data and Save a Workbook
- Microsoft Office Compatibility Pack (for people without Office 2007)
http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
- Topic 1E: Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Topic 2A: Create Basic Formulas
- Topic 2B: Calculate with Functions
- Topic 2C: Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Topic 3A: Manipulate Data
- Topic 3B: Insert and Delete Cells, Columns, and Rows
- Topic 3C: Search for Data in a Worksheet
- Topic 3D: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Topic 4A: Modify Fonts
- Topic 4B: Add Borders and Color to Cells
- Topic 4C: Change Column Width and Row Height
- Topic 4D: Apply Number Formats
- Topic 4E: Position Cell Contents
- Topic 4F: Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Topic 5A: Print Workbook Contents Using Default Print Options
- Topic 5B: Set Print Options
- Topic 5C: Set Page Breaks
Lesson 6: Managing Large Workbooks
- Topic 6A: Format Worksheet Tabs
- Topic 6B: Manage Worksheets in a Workbook
- Topic 6C: Manage the View of Large Worksheets
Extras
- VBA Programs
- The Ultimate Excel Cheat Sheet
http://www.investintech.com/articles/excelcheatsheet/
- Office 2007 Ribbon Overview
- 2003 to 2007 Command Reference Guide:
Rest the mouse pointer over an Excel 2003 menu or button in this interactive environment to learn its new location in Excel 2007.
- "Get Started" tab (add-on for Excel 2007)
- Training
- Tutorials (created by BYU-Idaho)
http://www.byui.edu/onlinelearning/tutorials/office2007/excel.htm
- Courses (online at Microsoft.com)
- Prior Class Archives:
Initial Knowledge
- 084890dd.exe: Installs a folder named 084890Data on your C drive. This folder contains all the data files that you will use to complete this course.
- 084890s3.doc: Pre-test/Post-test
- Excel2007ExamMapping.doc: Tells you how the skills you learn here will map to the Microsoft Certified Application Specialist (MCAS) Certification Exam.
- ol84-890.rtf: Outline of the course
- PowerPoint Slides (coming soon)
Course Content
Lesson 1: Creating a Basic Worksheet
- Topic 1A: Explore the User Interface and the Ribbon
- Topic 1B: Navigate and Select in Excel
- Topic 1C: Obtain Help
- Topic 1D: Enter Data and Save a Workbook
- Microsoft Office Compatibility Pack (for people without Office 2007)
http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
- Microsoft Office Compatibility Pack (for people without Office 2007)
- Topic 1E: Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Topic 2A: Create Basic Formulas
- Topic 2B: Calculate with Functions
- Topic 2C: Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Topic 3A: Manipulate Data
- Topic 3B: Insert and Delete Cells, Columns, and Rows
- Topic 3C: Search for Data in a Worksheet
- Topic 3D: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Topic 4A: Modify Fonts
- Topic 4B: Add Borders and Color to Cells
- Topic 4C: Change Column Width and Row Height
- Topic 4D: Apply Number Formats
- Topic 4E: Position Cell Contents
- Topic 4F: Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Topic 5A: Print Workbook Contents Using Default Print Options
- Topic 5B: Set Print Options
- Topic 5C: Set Page Breaks
Lesson 6: Managing Large Workbooks
- Topic 6A: Format Worksheet Tabs
- Topic 6B: Manage Worksheets in a Workbook
- Topic 6C: Manage the View of Large Worksheets
Extras
- VBA Programs
- The Ultimate Excel Cheat Sheet
http://www.investintech.com/articles/excelcheatsheet/ - Office 2007 Ribbon Overview
- 2003 to 2007 Command Reference Guide:
Rest the mouse pointer over an Excel 2003 menu or button in this interactive environment to learn its new location in Excel 2007. - "Get Started" tab (add-on for Excel 2007)
- Training
- Tutorials (created by BYU-Idaho)
http://www.byui.edu/onlinelearning/tutorials/office2007/excel.htm - Courses (online at Microsoft.com)
- Tutorials (created by BYU-Idaho)
- Prior Class Archives:
