Hero image

The Computer Mamas

About the Author: Elizabeth Nofs Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for Office 2010 and 2007(MCAS) met the Microsoft Vendor of Approved Courseware requirements.

About the Author: Elizabeth Nofs Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for Office 2010 and 2007(MCAS) met the Microsoft Vendor of Approved Courseware requirements.
Microsoft Excel 2013 Advanced: PivotCharts
thecomputermamathecomputermama

Microsoft Excel 2013 Advanced: PivotCharts

(0)
This lesson teaches how to edit and format a PivotChart in Microsoft Excel. If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. If you are interested in Microsoft Excel 2013, here are some Resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Create a Price Sheet Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
Microsoft Excel 2013 Intermediate: Text and Date Formulas
thecomputermamathecomputermama

Microsoft Excel 2013 Intermediate: Text and Date Formulas

(0)
This lessons teaches Text, Date and simple Financials formulas. Project: Use formulas to format TEXT, DATE, and TIME. Use FINANCIAL formulas to calculate a car payment Intermediate Excel Objectives In this lesson, you will learn how to: 1. Practice modifying cell contents and formats. 2. Use the Paste Special options. 3. CONCATENATE (combine) data with a formula. 4. Modify and format TEXT with formulas. 5. Use DATE and TIME formulas. 6. Use FINANCIAL formulas to calculate a car payment. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. Other Recommended Microsoft Excel 2013 Sample Files (Not Included) Microsoft Excel 2013 Beginning: Sample Files Microsoft Excel 2013 Intermediate: Sample Files Microsoft Excel 2013 Advanced: Sample Files If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
Microsoft Access 2013 Beginning: More Query Designs
thecomputermamathecomputermama

Microsoft Access 2013 Beginning: More Query Designs

(0)
Microsoft Access 2013 Beginning: More Query Designs Project: Parameter Queries with calculated Fields from the customer and movie Tables. Beginning Access Objectives In this lesson, you will learn how to: 1. Create a Query in Design View and use the Show Table command to add a Record Source. 2. Add Fields to the QBE Grid. 3. Create a Field that combines (Concatenates) two or more Fields together. 4. Create a Parameter Query that prompts the User to enter more information when the Query runs Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Beginning: Query Designs
thecomputermamathecomputermama

Microsoft Access 2013 Beginning: Query Designs

(0)
Microsoft Access 2013 Beginning: Query Designs Project: Create Select Queries based on the Table tblMovies. Beginning Access Objectives In this lesson, you will learn how to: 1. Use the Query Wizard to select a Table as the Record Source and add Fields in a Select Query. 2. Sort the Query Results. 3. Edit the Query Criteria in Design View. 4. Add, Delete and Rearrange Fields in the QBE Grid. 5. Save the Select Query Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Beginning: Hello, Access!
thecomputermamathecomputermama

Microsoft Access 2013 Beginning: Hello, Access!

(1)
Microsoft Access 2013 Beginning: Hello, Access! Project: Introduction to Access database objects. Create and modify a customer Table. Beginning Access Objectives In this lesson, you will learn how to: 1. Create a new, blank Access database. 2. Use the Navigation Pane to find Access Objects. 3. Create and modify Tables: Add a Text Field. 4. Modify the Fields and test the Data Validation. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample database • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database
thecomputermamathecomputermama

Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database

(0)
Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database Project: Create a Table and use the Primary Key to create a relationship to an existing Table Advanced Access Objectives 1. Define the Primary Key in a new Table 2. Add a Foreign Key to a Table 3. Use the Primary Keys to create Relationships between Tables 4. Add a Subdatasheet and format the Tables to Show/Hide and Freeze the Columns in Datasheet View Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Beginning: Report Designs
thecomputermamathecomputermama

Microsoft Access 2013 Beginning: Report Designs

(0)
Microsoft Access 2013 Beginning: Report Designs Project: A Report created with the Report Wizard and formatted with a Theme Beginning Access Objectives In this lesson, you will learn how to: 1. Use the Report Wizard to create a Report based on a Table. 2. Modify a Report in Report Layout View. 3. Apply a Theme and edit the Report Header to include a Logo. 4. Add Page Numbers to the Report Footer. 5. Use the Report Sort and Filter options. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Beginning: Designing Forms for Real Users
thecomputermamathecomputermama

Microsoft Access 2013 Beginning: Designing Forms for Real Users

(0)
Microsoft Access 2013 Beginning: Designing Forms for Real Users Project: Edit the Form Controls with the Form Design Tools and the Property Sheet. Beginning Access Objectives In this lesson, you will learn how to: 1. Go to the Design View and use the Form Design Tools to edit the Form Fields. 2. View the Property Sheet for the Form and the individual Form Controls. 3. Add a picture to the Form Header and use the Property Sheet to resize the picture. 4. Arrange the Form Fields and edit the Tab Order Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Word 2013 Intermediate: Rain Washes Out Hamburg (Create a Newsletter)
thecomputermamathecomputermama

Microsoft Word 2013 Intermediate: Rain Washes Out Hamburg (Create a Newsletter)

(0)
A newsletter formatted with two columns. The graphics include a satellite photo and a chart designed in Excel. Explore the Picture Tools and learn how to adjust images. This lesson demonstrates all of the tools and options in Microsoft Word 2013. If you wish to prepare students for the Microsoft Certification Exam 77-418: Microsoft Office Word 2013 OR Microsoft Certification Exam 77-425 Part 1 and 77-426 Part 2: Microsoft Office Word 2013 Expert this course has everything you need. Here you will find beginning through advanced lessons that demonstrate these required MOS topics. This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample documents, and graphic files • Practice, Quizzes and Skill Test If you are interested in Microsoft Word 2013, here are some Resources you may consider: Microsoft Word 2013 Beginning Microsoft Word 2013 Beginning: Go Blue! Microsoft Word 2013 Beginning: Fancy Colors Microsoft Word 2013 Beginning: First Prize Microsoft Word 2013 Beginning: Using Quick Parts Microsoft Word 2013 Intermediate Microsoft Word 2013 Intermediate: Newsletter Microsoft Word 2013 Intermediate: Use the Resume Template Microsoft Word Intermediate: Charlotte's Website Microsoft Word 2013 Intermediate: Create a Mail Merge Microsoft Word 2013 Advanced Microsoft Word 2013 Advanced: Tabs and Tables Microsoft Word 2013 Advanced: Formatting Tables Microsoft Word 2013 Advanced: Styles 1 Microsoft Word 2013 Advanced: Styles 2 Microsoft Word 2013 Advanced: Prepare to Share
Microsoft Access 2013 Intermediate: Report 1 (Totals)
thecomputermamathecomputermama

Microsoft Access 2013 Intermediate: Report 1 (Totals)

(0)
Microsoft Access 2013 Intermediate: Report 1 (Totals) Project: A Report with Conditional Formatting as well as a Command Button that opens a Form with an OnClick Event Intermediate Access Objectives 1. Apply Report Design options including Theme, Logo, and a Background Image 2. Add Page Breaks and Page Numbers. 3. Apply Conditional Formatting to the data. 4. Program a Command Button to open a Form OnClick and format the Shape. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft  Access 2013 Advanced
thecomputermamathecomputermama

Microsoft Access 2013 Advanced

(1)
Access 2013 Advanced Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • eBook with 347 pages of detailed instructions (PDF) • Sample databases • Practice, Quizzes and Skill Test All materials for this program are available online. The following resources are available to download throughout the lessons: • Advanced Guide to Microsoft® Access 2013 • Microsoft Access 2013 Advanced Sample files In Microsoft Access, you’ll cover basic through advanced topics, including: • Understand how to create and Normalize a database • Learn how to create relationships between Tables in a Database: using Key data • Understand Primary Keys and Relationships • Create a Receipt Form that uses a Report and Subreport to calculate the total • Become skilled at working with Dates in a Query • Visualize the results and export the Reports • Learn strategies for Archiving data using Action Queries • Optimize a database for Multi-Users and improve network performance The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Advanced: Many-to-Many Relationships
thecomputermamathecomputermama

Microsoft Access 2013 Advanced: Many-to-Many Relationships

(0)
Microsoft Access 2013 Advanced: Many-to-Many Relationships This is an introduction to the lessons in the Access 2013 Advanced programming. Please review our Microsoft Access lessons available on TES and download the zipped files that include eBook (PDF), video (MP4) and sample files. An overview of our Microsoft Access lessons available on TES: 1. Representing many-to-many relationship with a Table and Subdatasheet. 2. Using Primary Keys to create Relationships between Tables. 3. Creating a blank Form and adding buttons to open Forms and Reports. 4. Finding common errors in Forms and Queries and correcting the mistakes. 5. Calculating Totals in a Report Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. Please review our Microsoft Access lessons available on TES and download the zipped files that include eBook (PDF), video (MP4) and sample files. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Access 2013 Intermediate: Hello, Again!
thecomputermamathecomputermama

Microsoft Access 2013 Intermediate: Hello, Again!

(0)
Microsoft Access 2013 Intermediate: Hello, Again! Project: A Lesson on creating Relationships in Microsoft Access This is the INTRODUCTION to the Intermediate Guide to Access. If you wish to learn database programming, please consider our many lessons posted on TES. Thanks! eBeth Intermediate Access Objectives In this lesson, you will learn how to: 1. Representing a one-to-many relationship with a Form and Subform 2. Using a Query Criteria to make a Combo Box that looks up a value on a Form 3. Creating a blank Form and adding buttons to open Forms and Reports 4. Finding common errors in Forms and Queries and correcting the mistakes 5. Calculating Totals in a Report Another Computer Mama Guide: www.thecomputermama.com In Microsoft Access, you’ll cover basic through advanced topics, including: • Learn how to navigate the online course and submit your assignments • Understand the purpose of Tables and how they are used in a database • Edit the Form Properties to help Users navigate the Form Fields and enter data • Learn how to design Queries and use Queries to lookup records in the Tables • Use Query Criteria and Parameter Queries to select specific records in the Tables • Learn how to design and modify Reports in Layout and Design Views • Learn how to manage Database files: Save and Save As The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
Microsoft Excel 2013 Beginning: It All Adds Up
thecomputermamathecomputermama

Microsoft Excel 2013 Beginning: It All Adds Up

(0)
A beginning lesson that introduces Microsoft Excel 2013. This lesson creates a product list and calculates the prices. If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. Other Recommended Microsoft Excel 2013 Rersources Microsoft Excel 2013 Beginning Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Advanced If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Create a Price Sheet Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
Microsoft Excel 2013 Beginning
thecomputermamathecomputermama

Microsoft Excel 2013 Beginning

(0)
Microsoft Excel 2013 Beginning Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you build the skills and knowledge you need. • Step-by-step demonstrations • 220 pages of detailed instructions • Sample presentations and images • Practice, Quizzes and Skill Test The following resources are available to download: • Beginning Guide to Microsoft® Excel 2013 (PDF) In Microsoft Excel, you’ll cover basic through advanced topics, including: • How to enter data and format cells and apply number formats • Practice how to create formulas and audit the cell references • Learn how to represent data as Charts • Use pictures and graphics The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428
Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs
thecomputermamathecomputermama

Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs

(0)
This lesson teaches the differences between Relative and Absolute Cell references in Microsoft Excel. If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. Other Recommended Microsoft Excel 2013 Sample Files (Not Included) Microsoft Excel 2013 Beginning: Sample Files Microsoft Excel 2013 Intermediate: Sample Files Microsoft Excel 2013 Advanced: Sample Files If you are interested in Microsoft Excel 2013, here are some links you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
Microsoft Excel 2013 Advanced
thecomputermamathecomputermama

Microsoft Excel 2013 Advanced

(0)
Microsoft Excel 2013 Advanced Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you build the skills and knowledge you need. • Step-by-step demonstrations • eBook with 220 pages of detailed instructions (PDF) • Sample presentations and images • Practice, Quizzes and Skill Test All materials for this program are available online. The following resources are available to download throughout the lessons: • Advanced Guide to Microsoft® Excel 2013 • Microsoft Excel 2013 Advanced Sample files In Microsoft Excel Advanced, you’ll cover advanced topics, including: • Analyze data visually with a PivotChart. • Create a PivotChart and Show the Field List. • Edit the Value Field Settings. • Filter the data in the PivotChart. • Edit the Chart Layouts. • Apply a Chart Style. • Use Slicers The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428
Microsoft Excel 2010 Intermediate: In Print
thecomputermamathecomputermama

Microsoft Excel 2010 Intermediate: In Print

(0)
This lesson is a comprehensive review of the print options in Microsoft Excel. The topics include editing the Page Setup and changing the margins, size, background and titles. If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. Other Recommended Microsoft Excel 2013 Resources (Not Included) Microsoft Excel 2013 Beginning Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Advanced If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
Microsoft Excel 2013 Intermediate: Using Named Ranges
thecomputermamathecomputermama

Microsoft Excel 2013 Intermediate: Using Named Ranges

(0)
This lesson teaches how to Named Ranges in formulas. If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Create a Price Sheet Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
Microsoft Excel 2013 Beginning: Chart and Chart Tools
thecomputermamathecomputermama

Microsoft Excel 2013 Beginning: Chart and Chart Tools

(0)
This lessons uses the Chart Tools and the new Quick Clicks to edit Charts in Excel. UPDATED: If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. Other Recommended Microsoft Excel 2013 Resources (Not Included) Microsoft Excel 2013 Beginning Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Advanced If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Create a Price Sheet Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts