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 PowerPoint 2013 Beginning: Every Picture Tells a Story

Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story

Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story Project: A PowerPoint show that uses pictures to tell the story In this lesson, you will learn how to: 1. Use the Picture Tools Ribbon to format the Picture Styles. 2. Modify the Picture Borders and Picture Effects. 3. Crop and Resize a picture. 4. Apply image Corrections such as Soften/Sharpen, Brightness/Contrast, Artistic Effects 5. Manipulate images: Compress, Change or Reset and Remove Background. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Microsoft Certification Exam 77-422: Microsoft Office PowerPoint 2013, this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations. • Companion eBook with detailed instructions. • 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: • Beginning Guide to Microsoft® PowerPoint 2013 • Microsoft PowerPoint 2013 Beginning Sample files With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft PowerPoint 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. The Microsoft PowerPoint 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-422: Microsoft Office PowerPoint 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: PowerPoint® 2013: Exam 77-422
thecomputermama
Microsoft Excel 2013 Intermediate: Text and Date Formulas

Microsoft Excel 2013 Intermediate: Text and Date Formulas

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
thecomputermama
Microsoft Access 2013 Advanced: Many-to-Many Relationships

Microsoft Access 2013 Advanced: Many-to-Many Relationships

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
thecomputermama
Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships

Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships

Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships Project: Create several Tables with Primary and Foreign Keys Advanced Access Objectives 1. Identify the levels of database design: First, Second and Third Normal Form. 2. Create Tables in Design View that have Primary and Foreign Keys. 3. Create Tables that do not have repeating groups: Third Normal Form. 4. Document the Relationships. 5. Edit the Joins between Tables to ensure Data Integrity and Enforce Referential Integrity 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
thecomputermama
Microsoft PowerPoint 2013 Advanced: Top Ten Reasons to Hire Me! (More Animations)

Microsoft PowerPoint 2013 Advanced: Top Ten Reasons to Hire Me! (More Animations)

A slide show that uses Custom Animation. If you wish to prepare for Microsoft Certification Exam 77-422: Microsoft Office PowerPoint 2013, this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample presentations and images • Practice, Quizzes and Skill Test If you are interested in Microsoft PowerPoint 2013, here are some Resources you may consider: Microsoft PowerPoint 2013 Beginning Microsoft PowerPoint 2013 Beginning: Working with Text Boxes Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story Microsoft PowerPoint 2013 Beginning: SmartArt Microsoft PowerPoint 2013 Advanced Microsoft PowerPoint 2013 Advanced: Animations! Microsoft PowerPoint 2013 Advanced: Charts and Chart Tools Microsoft PowerPoint 2013 Advanced: More Animations Microsoft PowerPoint 2013 Advanced: Multi Media and Videos Microsoft PowerPoint 2013 Advanced: Online and in Print
thecomputermama
Microsoft Access 2013 Intermediate: Hello, Again!

Microsoft Access 2013 Intermediate: Hello, Again!

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
thecomputermama
Microsoft Access 2013 Beginning: More Query Designs

Microsoft Access 2013 Beginning: More Query Designs

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
thecomputermama
Microsoft Access 2013 Beginning: Query Designs

Microsoft Access 2013 Beginning: Query Designs

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
thecomputermama
Microsoft Access 2013 Advanced: Many-to-Many Relationships

Microsoft Access 2013 Advanced: Many-to-Many Relationships

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
thecomputermama
Microsoft  Access 2013 Advanced

Microsoft Access 2013 Advanced

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
thecomputermama
Microsot Word 2013 Intermediate: Online!

Microsot Word 2013 Intermediate: Online!

Create a simple flyer in Word that includes hyperlinks to videos and pictures. 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
thecomputermama
Microsoft Excel 2013 Advanced

Microsoft Excel 2013 Advanced

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
thecomputermama
Microsoft Excel 2013 Advanced: PivotTables

Microsoft Excel 2013 Advanced: PivotTables

PivotTables combine all of the best Data Tools: Sort, Filter, and Subtotal. This lesson teaches how to summarize data in an interactive PivotTable in Microsoft Excel 2013. 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
thecomputermama
Microsoft Access 2013 Beginning: Form Design

Microsoft Access 2013 Beginning: Form Design

Microsoft Access 2013 Beginning: Form Design Project: Create two Forms with the Form Wizard Beginning Access Objectives In this lesson, you will learn how to: 1. Create a Form with the Form Wizard. 2. Modify the Forms in Layout View with the Form Design Tools. 3. Apply a Theme to a Form. 4. View the Property Sheet and use the Properties to resize and position a picture. 5. Use the Design Ribbon to Format the Header. 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
thecomputermama
Microsoft Outlook 2013: Tasks and Time Management

Microsoft Outlook 2013: Tasks and Time Management

Microsoft Outlook 2013: Tasks and Time Management Project: Four Tasks that are tagged for follow up. Microsoft Outlook Objectives In this lesson you will learn how to: 1. Create Tasks to document date, time, location and details. 2. Manage Task Details. 3. Assign a Task to an Outlook User. 4. Accept or decline a Task assignment 5. Update a Task, end a Status Report 6. Mark a Task complete and move it to a folder. If you wish to prepare for Microsoft Certification Exam 77-422: Microsoft Office Outlook 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample presentations and images • Practice, Quizzes and Skill Test Download this lesson as a PDF file Microsoft Outlook 2013: Tasks and Time Management (eBook PDF) Download the Sample Files: There are no sample files for this lesson If you are interested in Microsoft Outlook 2013, here are some Resources you may consider: Microsoft Outlook 2013: Hello, Outlook! Microsoft Outlook 2013: Messages and Messengers Microsoft Outlook 2013: From Me to You Microsoft Outlook 2013: Signed, Sealed and Delivered Microsoft Outlook 2013: Contacts and Connections Microsoft Outlook 2013: Calendar (Eight Days a Week) Microsoft Outlook 2013: Tasks and Time Management Microsoft Outlook 2013: Outlook and the Internet Microsoft Outlook 2013: Outlook in Print Microsoft Outlook 2013: Advanced Search Options Microsoft Outlook 2013: Outlook Email Accounts
thecomputermama
Microsoft Word 2013 Intermediate: Rain Washes Out Hamburg (Create a Newsletter)

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

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
thecomputermama
Microsoft Excel 2013 Advanced: Form Design

Microsoft Excel 2013 Advanced: Form Design

This lesson teaches how to edit and format a Form in Microsoft Excel. Create drop-down fields with Data Validation! 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 Advanced: Form Design
thecomputermama
Microsoft Access 2013 Beginning: Report Designs

Microsoft Access 2013 Beginning: Report Designs

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
thecomputermama
Microsoft Excel 2013 Beginning: Chart and Chart Tools

Microsoft Excel 2013 Beginning: Chart and Chart Tools

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
thecomputermama
Microsoft Outlook 2013: From Me to You

Microsoft Outlook 2013: From Me to You

Microsoft Outlook 2013: From Me to You Project: An E-mail message that uses a Table for the HTML design and includes pictures and SmartArt. Microsoft Outlook Objectives In this lesson you will learn how to: 1. Create an E-mail message that includes graphics and SmartArt. 2. Format the E-mail message as a Table and use the Table Tools to modify the layout and design. 3. Attach content to an E-mail message and work with the Attachments Ribbon. 4. Forward an attachment. 5. Save attachments and save a message in an external format. If you wish to prepare for Microsoft Certification Exam 77-422: Microsoft Office Outlook 2013 this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample presentations and images • Practice, Quizzes and Skill Test Download this lesson as a PDF file Microsoft Outlook 2013: From Me to You (eBook PDF) Download the Sample Files: Phone.gif Laptop.gif Keep It Clean.gif Sign6Small.gif If you are interested in Microsoft Outlook 2013, here are some Resources you may consider: Microsoft Outlook 2013: Hello, Outlook! Microsoft Outlook 2013: Messages and Messengers Microsoft Outlook 2013: From Me to You Microsoft Outlook 2013: Signed, Sealed and Delivered Microsoft Outlook 2013: Contacts and Connections Microsoft Outlook 2013: Calendar (Eight Days a Week) Microsoft Outlook 2013: Tasks and Time Management Microsoft Outlook 2013: Outlook and the Internet Microsoft Outlook 2013: Outlook in Print Microsoft Outlook 2013: Advanced Search Options Microsoft Outlook 2013: Outlook Email Accounts
thecomputermama
Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story

Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story

Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story Project: A PowerPoint show that uses pictures to tell the story In this lesson, you will learn how to: 1. Use the Picture Tools Ribbon to format the Picture Styles. 2. Modify the Picture Borders and Picture Effects. 3. Crop and Resize a picture. 4. Apply image Corrections such as Soften/Sharpen, Brightness/Contrast, Artistic Effects 5. Manipulate images: Compress, Change or Reset and Remove Background. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Microsoft Certification Exam 77-422: Microsoft Office PowerPoint 2013, this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations. • Companion eBook with detailed instructions. • 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: • Beginning Guide to Microsoft® PowerPoint 2013 • Microsoft PowerPoint 2013 Beginning Sample files With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft PowerPoint 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. The Microsoft PowerPoint 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-422: Microsoft Office PowerPoint 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: PowerPoint® 2013: Exam 77-422
thecomputermama
Microsoft Excel 2013 Advanced: PivotCharts

Microsoft Excel 2013 Advanced: PivotCharts

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
thecomputermama
Microsoft Excel 2013 Advanced: Using Tables

Microsoft Excel 2013 Advanced: Using Tables

Use the Table Tools in Microsoft Excel 2013 to organize and format data in a spreadsheet. This lesson demonstrates how to select a Range, format as a Table, highlight data with Conditional Formatting and use the AutoSum. 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
thecomputermama