Hello, Animation!

Animation is the heart and soul of PowerPoint. Animation keeps your audience interested and focused on your key points. Animation Effects can be applied to pictures or text. A picture can have more than one Animation. For example, a baseball can fly in (Entrance) and fly out (Exit). The Animation can include sound as well. This lesson is fun, creative and playful.

Every picture tells a story. Pictures motivate your audience and focus on the message you are trying to convey. Please add one or two pictures to each slide.

Try it: Insert Pictures
Begin on Slide 2.
Go to Insert ->Illustrations->Picture.
You will be prompted to Browse for the pictures.
Add pictures to each slide.

Memo to our Readers: Our computer courses offer many sample graphics online. You can also use your own pictures if you wish.

Add Something to Animate: This presentation uses a sports metaphor to promote the message. Think about sports. There’s always something “moving on the screen” when you are watching it.

Try it: Add an Animation
The football on Slide 2 is selected.
Go to Animations ->Animation
.
Select: Fly In.
What Do You See, Now? By default the picture probably flies up from the bottom, and that just isn’t the right direction for a football, is it?

Keep going…

Edit the Effect Options
Each animation Effect
has options. For example, you can change the direction of the animation. A football should fly in from the top, not rise from the bottom.

Try it: Edit the Effect Options
The football on Slide 2 has the Fly In animation effect. It is selected.
Go to Animations ->Animation.
Go to Effect Options->From Top-Right.
What Do You See? The football begins in the top right corner and stops where you placed it on the slide.

I enjoy teaching this lesson yesterday at college.
Here is a YouTube video you can watch if you wish.

PowerPoint 2013 Advanced: Top 10 Reasons to Hire Me!

I hope you enjoy these tools in PowerPoint. Thanks for stopping by.

eBeth
Elizabeth Nofs, the Computer Mama

 

New Subscribers Welcome: https://thecomputermama.us

Buy the books at Amazon: https://thecomputermama.us/books-page/

Visit our school at: https://thecomputermama.teachable.com/

Read more

The Right Tool for the Task

When something goes wrong, everyone wants to go through the data and find out what happened. The Data Tools are: Sort, Filter, Group and Subtotal. A PivotTable combines all of the best Data Tools together. A PivotTable presents the data in a visual, interactive format. PivotTables summarize, sort, compare and filter the data. A PivotTable summarizes data and displays the results. It is a reporting tool that works very well. Here is how you start.

Try This: Insert a PivotTable
This is an example of the Monthly Sales spreadsheet. Select all.

Go to Insert ->Tables.
Click on PivotTable.

OK, Try This: Choose the data

If you selected the entire Monthly Sales sheet, Excel will display the Table or Range: ‘Monthly Sales’!$A:$H  In words, that means “name of your spreadsheet” ! “all of the data in Column A through Column H.”

And Try This, Too: Where do you want to place the new PivotTable report? The choices are create a new PivotTable in a new worksheet or place it on an existing worksheet.

Select: New Worksheet.
Click OK.

That’s all it takes to create the PivotTable. The next steps are fun: working with the data. The PivotTable Field list on the right side is simple to use. Here is a YouTube video you can watch if you wish.

Microsoft Excel 2013 Advanced: PivotTables

Thanks for stopping by.
eBeth

Elizabeth Nofs, the Computer Mama

 

New Subscribers Welcome: https://thecomputermama.us
Buy the books at Amazon: https://thecomputermama.us/books-page/
Visit our school at: https://thecomputermama.teachable.com/

Read more

Statistical Functions in Microsoft Excel

Microsoft Excel has an extensive set of statistical functions. These functions work well if you select and Name a Range of data. Here are the steps.

Select a Range: By definition, a RANGE is a one or more cells on a spreadsheet. The cells may be adjacent or not.

Define a Range: The Name Box is a special tool in the top left corner by the Formula bar. You can use the Name Box to Define a Range

Syntax Rules for Defined Names: The first character must be a letter. The next characters can be text, numbers, periods and underscores. Names can be up to 255 characters.

Names cannot include Cell References. For example, a Name cannot be $B$1. Names cannot include “C”, “c”, “R”, or “r” because they are used as shorthand for selecting Columns and Rows in the Name Box.

Spaces are not allowed.

Examples of Statistical Formulas Available in Excel

  • SUMIF
  • SUMIFS
  • COUNTIF
  • COUNTIFS
  • AVERAGEIF
  • AVERAGEIFS

I just taught this lesson yesterday at college. Here is a YouTube video you can watch if you wish.

Microsoft Excel 2013 Intermediate: Name that Tune

Thanks for stopping by.
eBeth

Elizabeth Nofs, the Computer Mama

 

New Subscribers Welcome: https://thecomputermama.us

Buy the books at Amazon: https://thecomputermama.us/books-page/

Visit our school at: https://thecomputermama.teachable.com/

Read more

Conditional Formatting in Excel

Today’s question comes from www.quora.com. This is an interesting question!  I like to use Conditional Formatting. People have a hard time reading numbers. You can use color to show trends or make comparisons, say High, Medium, and Low, or highlight specific information. Conditional Formatting

How do I select all of the text in a Cell in Excel? 

Conditional Formats

Microsoft Excel calls this Conditional Formatting. The color depends on the condition, which you can choose. Microsoft Excel has a library of Conditional Formatting including Data Bars, Color Sets and Icons. Each of these formats is based on Conditional Formulas, or Rules. Let’s start with a simple Rule: show me any amount that is above the average. Let’s look at the options.

Try It: Above or Below Average?

Select Column H. In the sample spreadsheet, this is the column with the Amount.
Go to Home ->Styles -> Conditional Formatting.
Go to Top/Bottom Rules.
Select: Above Average.

What Do You See? You will be prompted to select the colors when you select a Top/Bottom Rule. 

Try This: Find TEXT Using Find and Replace

Select the entire spreadsheet.

Go to Home ->Editing -> Find and Replace

Select: Go To…

Do This: Click Special.

Select: Constants

Select: Text.

Please note: None of the other options are selected.

When you click OK all of the Text will be highlighted.

These steps can be recorded as a Macro if you wish to create your own keyboard click.

I am a fan of Conditional Formatting. Here is a YouTube that you can watch if you wish. Thanks for stopping by.

Microsoft Excel 2013 Advanced: Tables Work for Me!

eBeth

Elizabeth Nofs, the Computer Mama

New Subscribers Welcome: https://thecomputermama.us

If you would like to stay in touch, please subscribe to my website for:

  • News and Course Announcements
  • Coupons and Freemiums
  • Guides and Mini-courses
  • New subscribers welcome!

Buy the books at Amazon: https://thecomputermama.us/books…

Visit our school at: https://thecomputermama.teachable.com/

Read more

MOS Certification

What Do I Need to Know?

The Microsoft Office Specialist certification uses computer exams to measure whether you mastered the specific skill sets in the Microsoft Office Specialist Program: Access, Excel, Outlook, PowerPoint, Word, OneNote, and SharePoint.

You can choose which exam(s) to take according to which skills you want to validate. The Microsoft Office Specialist certification exams ask you to demonstrate that you can find, format and update the tools in Microsoft Office. The certification exams are project based, not multiple guess. You need to edit a document or create a formula.

The CORE exams cover 80% of the options, so someone preparing for these tests should learn beginning and intermediate steps. The EXPERT Exams are interesting. The options are not difficult to find-.

O, Look! It’s sez More Options on the bottom of every menu.

The Expert tasks in every project require using the options in the right order. The example is the Mail Merge in Microsoft Word. The Mailing Ribbon and the Mail Merge Wizard are both designed to guide the user through a sequence of steps successfully. Each expert certification exam is looking for skill and efficiency with these automation tools.

For More Information:
www.certiport.com
www.microsoft.com

Sixty Minutes to Success: Each of these lesson is available here in a course online.

Our Promise: No cost or ankle biters.

Sign In to Learn More:  https://thecomputermama.teachable.com/

New Subscribers Welcome: https://thecomputermama.us

If you would like to stay in touch, please subscribe to my website for:

  • News and Course Announcements
  • Coupons and Freemiums
  • Guides and Mini-courses
  • New subscribers welcome!

Buy the books at Amazon: https://thecomputermama.us/books-page/

Visit our school at: https://thecomputermama.teachable.com/

 

MOS 2016 Certification
Core Certification: Pass any 1 test:
Word 2016 Core: Exam 77-725
Excel® 2016 Core: Exam 77-727
PowerPoint® 2016: Exam 77-729
Access® 2016: Exam 77-730
Outlook® 2016: Exam 77-731

Expert Certification: Pass either test:
Word 2016 Expert: Exam 77-726

Excel 2016 Expert: Exam 77-728

MOS 2013 Certification
Core Certification: Pass any 1 test:
Word 2013 Core: Exam 77-418
Excel® 2013 Core: Exam 77-420
PowerPoint® 2013: Exam 77-422
Access® 2013: Exam 77-424
Outlook® 2013: Exam 77-423

Expert Certification: Pass either test:
Word 2013 Expert Part 1: Exam 77-425
Word 2013 Expert Part 2: Exam 77-426

Excel 2013 Expert Part 1: Exam 77-427
Excel 2013 Expert Part 2: Exam 77-428

MOS 2010 Certification 
Core Certification: Pass any 1 test :
Word 2010 Core: Exam 77-881
Excel® 2010 Core: Exam 77-882
PowerPoint® 2010: Exam 77-883
Access® 2010: Exam 77-885
Outlook® 2010: Exam 77-884

Expert Certification: Pass either test:
Word 2010 Expert: Exam 77-887
Excel® 2010 Expert: Exam 77-888

Master Certification Requirements:
Pass required and elective tests:

Required
Word 2010 Expert: Exam 77-887
Excel® 2010 Expert: Exam 77-888
PowerPoint® 2010: Exam 77-883

Elective
Access® 2010: Exam 77-885 or
Outlook® 2010: Exam 77-884

Read more

Teaching Technology

I Teaching Microsoft Office!

Learn with us

VISIT OUR SCHOOL AT TEACHABLE
GET THE BOOKS AT AMAZON.COM

Watch the Video on YouTube!
Watch the Video on YouTube!

I started teaching in 1984 with my Mighty Macintosh. When I began teaching Microsoft Office, I was surprised how many people recorded my classes and came back a second time. Who would want to hear eight hours of Excel Formulas…again? People were hungry for knowledge and job skills. Nom Nom Nom. We filled our classes on Word, Excel, PowerPoint and Outlook.

Our first TV shows were created at WFUM-PBS, Flint.  We wanted to capture the spirit and action of the live classroom and reach a bigger audience. We also wanted to link all of the broadcast lessons to our Microsoft Office Specialist certification training: 100% video coverage.

Trying to capture the Live Performance into little video lessons has been challenging. Speaking in front of an audience is different from writing a textbook or making a video. Live classes have a relaxed pace: there is time to wait for the laughter or the a-ha responses. The videos seem to hurry-up.

In 2006, we launched our first virtual classroom online. Our Microsoft Office Specialist course is available in hundreds of colleges nationally. Thousands of students enrolled in our courses and learned new skills. Teachers learned new skills as well.  There are many new tools for teaching online: Live Chat, Forums and Discussions.

Offline: Our students want books. Students learn better with the hard copy. However, print is a different production path than online, so it was a lot of work. Our hard work succeeded. Our Microsoft Office 2007 courses were approved and we became a Microsoft Vendor of Approved Courseware.

As it sez on our website: When you use Approved Courseware to prepare for the Microsoft Office Specialist certification exams, you know you are using the very best study materials.

In 2013 our Microsoft certification videos went online! It was so much fun that it didn’t seem like work.

I know, I know: Watching a video does not make you an expert.
You can’t become a skilled professional just watching the show.

The best use of videos is to demonstrate a sequence of events. At some point, your hands have to learn the steps. Expertise is knowledge in motion. Our courses are hands on, project-based. You have to create and edit documents, spreadsheets and presentation.

Our courses include everything needed to prepare for the MOS certification exams:

  • Step-by-step video demonstrations
  • Companion eBook with detailed instructions
  • Sample spreadsheets
  • Practice, Quizzes and Skill Test

I guess you can tell that I really enjoy teaching Microsoft Office. And, it shows! The best part, is not the software or the new technology….But the results.When people learn new skills, they can enjoy the tools.

Learn more, earn, more, be more successful. Everyone wins!
And that’s what I like.

Learn with me:

Visit our school at Teachable
Get the books at Amazon.com

Read more

Top 10 Tools in Microsoft Word

TypewriterWhere Does Word Fit In? 

Each of the applications in Microsoft Office has a purpose. Microsoft Excel does Formulas. PowerPoint presents slides, and Outlook manage emails.

Where does Microsoft Word fit in? Most people use Word as a digital typewriter. A freemium such as Google Docs or Word Online is all a basic User may need: Big, bold, blue. (Kids React: Typewriters)

Others use Word as a power tool at work. Lawyers and scientists use all of the Advanced features, especially the References and Review Ribbons. These two Ribbons are not part of the freemium products.

Here is a video that compares Microsoft Office
Online and Click to Download (Desktop) software.

Office 365: Getting Started

As I researched the answer to this question I noticed that the Tools could be grouped by their common function: Media Styles (pictures, shapes, video formatting), Text Styles, Review, and References.

So Here are the Top Ten Tools in Microsoft Word

  • Picture Tools
  • Shape and SmartArt Tools
  • Use these tools to create a business letter
  • Templates and Quick Parts: Create a Resume
  • BONUS: Video Tools!
  • Review Tools: Prepare for publication
  • More Professional Tools: Styles and Reference
  • BONUS: Table Tools

And the NUMBER ONE OPTION in Microsoft Word…
Create an Interactive FORM with the Developer Tools!

Laptop

Sixty Minutes to Success: Each of these lessons is available in a FREE course online.
Our Promise: No cost or ankle biters.

Sign In to Learn More:  https://thecomputermama.teachable.com/

I think you will enjoy these Power Tools in Microsoft Word.
Thanks for stopping by.
eBeth

Top_Ten_Word

New Subscribers Welcome: https://thecomputermama.us
If you would like to stay in touch, please subscribe to my website for:

  • News and Course Announcements
  • Coupons and Freemiums
  • Guides and Mini-courses

Buy the books at Amazon: https://thecomputermama.us/books-page/

Visit our school at: https://thecomputermama.teachable.com/
Save $100 on our COMPLETE Word, Excel, Access, PowerPoint and Outlook courses at www.thecomputermama.teachable.com/
Coupon code: MORE_COOKIES

 

Read more

Good to the Last Drop?

Coffee
Good to the Last Drop!

Our “Top Ten” Word and Excel courses have a new content release program: DRIP.

With DRIP programming, the lessons are released one day at a time. Students receive an email each day with a summary of the day’s goals and benefits. The emails also include an invitation to return to our course and enjoy the next topic. The purpose of DRIP programming is to “engage students” with more interactivity.

This BETA software and a new concept for me. What are your thoughts about this format? Please use this blog if you wish to start a discussion.

You can also contact me HERE if you have any questions.

Thanks, eBeth

Read more

Top 10 Tools in Microsoft Excel

Today’s question is from an Academic Advisor at one of our college partners:

“What Skills in Excel are important for Access?”

Good Question. Microsoft Office is a suite of software. To rely solely on one app, say Microsoft t Excel, misses the point. The Office apps work together. Access is a powerful tool for getting good data. Excel is how you analyze and visualize that information.

These are the TOP TEN TOOLS in Microsoft Excel that are used in Access:

  • Format TEXT (UPPER, LOWER, SUBSTITUTE)
  • Combine TEXT from different cells (CONCATENANTE)
  • Find the DATE: Month, Day, Year
  • Calculate the payment (FINANCIAL)
  • BONUS: Find the best payment (SCENARIOS)
  • LOOKUP the information in a Table
  • Calculate SUM, AVERAGE, MAX, MIN and COUNT

Sixty Minutes to Success: Sign In to Learn More
Our promise: No cost or ankle biters.

https://thecomputermama.teachable.com/

Top Ten Tools in Microsoft Excel

Read more

A Table is a Table is a Table

A Table is a Table is a Table A Table is one of the fundamental benefits of having a computer. Information can be organized as Rows and Columns. Each of the Microsoft Office programs uses Tables to create structure. Each program also adds their own power tools. For Word, it is working with text. Excel uses Tables to show off the functions in the total Row. Of course! Excel is an excellent way to analyze data and work with Formulas.  Tables in Access define the database.

The Computer Mama noticed: Word can Total numbers in a Column,
but Excel does it better!

 

Here are four YouTube Videos that show
the best options for each program. Enjoy!


Tables in Word

Create an interactive form using the Developers Tools

  • Merge cells in a Table.
  • Show Developer Toolbar.
  • Add a Text Control Form Field, a Date Picker Control, and a Combo Box Control.
  • Protect a document.
  • Apply, Create and Modify Themes.
  • Insert and edit a Cover Page.

Tables in Excel

Format data as a Table and calculate the Totals

  • Create a Table.
  • Use the Header Row and Table Tools.
  • Locate the Quick Style Formats.
  • Use the Table Tools to add a Total Row.
  • Convert Tables to Text.
  • Convert Text to Tables.

Tables in Access

Hello, Access! Create a customer Table.

  • Create a new, blank Access database.
  • Use the Navigation Pane to find Access Objects.
  • Create and modify Tables: Add a Text Field.
  • Modify the Fields and test the Data Validation

 

 

 

Tables in PowerPoint

Play with Tables in PowerPoint
Get serious and add a spreadsheet

  • Create and modify Tables.
  • Format the Table Borders, Shading and Effects.
  • Merge and Split Cells and modify the Cell Size.
  • Modify Rows and Columns in a Tables.
  • Add an Excel spreadsheet into a presentation

 

 

 

But Wait! There’s more! These courses are online in our school. Our certification courses include eBooks, videos, sample files, practice and skill tests. Everything you need to become an expert.

Visit our school at Teachable
Get the books at Amazon.com

Read more