
Project: A Sample Spreadsheet that introduces the Home Ribbon
In this lesson you will:
1. Practice entering the labels and data.
2. Use the Home Ribbon to apply number formats.
3. Create a formula to calculate the retail price.
4. Use the AutoSum to calculate costs.
5. Use the AutoSum to SUM the profit.
6. Use the Home Ribbon to format cell borders.
7. Investigate options to hide and unhide data.
8. Identify and use the Cell Styles.
Project; A sample spreadsheet that calculates the wholesale and retail costs, and the profits.
In this lesson you will:
1. Practice entering the labels and data.
2. Use the Home Ribbon to apply number formats.
3. Create a formula to calculate the retail price.
4. Use the AutoSum to calculate costs.
5. Use the AutoSum to SUM the profit.
6. Use the Home Ribbon to format cell borders.
7. Investigate options to hide and unhide data.
8. Identify and use the Cell Styles.
Project: A checkbook and a spreadsheet that compares employee salaries to the average.
In this lesson you will learn how to:
1. Review how to enter labels and data.
2. Review how to calculate the balance.
3. Identify methods to audit your equations.
4. Use currency formatting on the Home Ribbon.
5. Identify the options that format the decimals.
6. Use formulas for SUM, AVERAGE, COUNT.
7. Learn the COUNTA Function.
8. Practice the Max and Min Functions.
9. Use the IF Logical Function.
Project: A sample spreadsheet that demonstrates the Chart Tools: Design Layout and Format.
In this lesson, you will learn how to:
1. Present data visually in a Chart
2. Create and format a Pie Chart
3. Edit the Chart Layout
4. Design and edit a Column Chart
5. Format the Shape Styles and Shape Fill
Project: An introduction to the Picture Tools and using pictures in a spreadsheet
In this lesson you will learn how to:
1. Add pictures to a spreadsheet.
2. Use the Picture tools to format the Picture Style and Picture Effects.
3. Use the tools to format the Picture Size.
4. Crop a Picture and Crop to Shape.
5. Make Picture Corrections by adjusting the Brightness, Contrast, Color Saturation and Tone.
6. Apply Artistic Effects.
7. Use the Adjustment tools to Compress a picture for Print, Screen, E-mail, or use the document resolution
Project: A practice spreadsheet with SmartArt graphics that you do not have to save.
In this lesson, you will learn how to:
1. Insert and Format Shapes.
2. Add Text to Shapes.
2. Edit the Text Direction.
3. Format Shapes with Quick Styles and Effects.
4. Create linked Text Boxes.
5. Use SmartArt.
6. Format and edit the SmartArt
Thank you for letting me be your guide.
I hope that you learned a few new skills that you can take to work with you. You done good. Got cookies?
eBeth Elizabeth Nofs, the Computer Mama
THANK YOU COUPON: If you wish to enroll in another Computer Mama course for only $10.00 (SAVE $190.00) please use this code: COOKIES
Keep in Touch: https://thecomputermama.us
If you would like to stay in touch, please join me at my website for:
New subscribers welcome!
Buy the books at Amazon: https://thecomputermama.us/books-page/
If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 this course will help you build the skills and knowledge you need.
With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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.
In Beginning Microsoft Excel, you will cover important topics, including how to:
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