Certification Training, Microsoft Office Specialist, Word

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

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

Top_Ten_Word

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

Please evaluate my Courses: Visit our school at UDEMY

Read more

Certification Training, Educational Technology, Microsoft Office Specialist

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

Access, Certification Training, Excel, Microsoft Office Specialist

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
Top Ten Tools in Microsoft Excel

Please evaluate my Courses: Visit our school at UDEMY

Read more

Access, Certification Training, Microsoft Office Specialist

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

Certification Training, Microsoft Office Specialist

O, Look! We Do Books

Another researcher has discovered that students want books.  Our students have asked over and over and over again: “Does this course come with books? “Can I keep the books? “Can I write in the books?
 
Digital isn’t the same as print. I have worked in both industries over the years. You can see my posts here and here. This study at least validates what my students already know: we need books.
 

With her new book, Words Onscreen: The Fate of Reading in a Digital World, Naomi Baron, a professor of linguistics at American University, brings more data to the case for print.  Baron and her colleagues surveyed over 300 university students in the U.S., Japan, Germany, and Slovakia, and found a near-universal preference for print, especially for serious reading. (She finds that the format doesn’t matter so much for “light reading.”)

When students were given a choice of various media—including hard copy, cell phone, tablet, e-reader, and laptop—92 percent said they could concentrate best in hard copy.

Learn with us: https://thecomputermama.teachable.com 

Read more

Access, Certification Training, Microsoft Office Specialist

Because Women Match Socks

Study Suggests Women Code Better Than Men This article supports what I have learned in the classroom. I have seen women programmers far exceed what men programmers can do…. because women match socks. Programming is all about On Event Clicks: does the button do what the user expects? The event matches the expectation. Women are very good at matching which kid gets which socks. Guys, not so much.

 

Computer codes written by women get higher approval ratings than the code written by men – but only if the gender of the coder is being hidden

 

I am the one who knows how to teach Microsoft Access! I have developed and deployed robust, commercial databases. I have also learned what it takes to teach database programming.

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

Read more

Certification Training, Microsoft Office Specialist, Outlook

Connections, Connections, Connections

Visit our school at Teachable
Get the books at Amazon.com
Our Complete Guide to Microsoft Outlook is live at Teachable!

ANOTHER Excellent Review! “What you did well in your last course…
For your last course, our review team noted that your teaching was
prepared and polished.” UDEMY

All materials for this program are available online.
  • Step-by-step video demonstrations
  • Companion eBook with 342 pages of detailed instructions
  • Sample presentations and images
  • Practice and Quizzes

Our Complete Guide to Microsoft Outlook teaches how to:

  • Design and format professional E-mail using Themes and images
  • Track and respond to messages
  • Manage the Inbox with Rules and Quick Steps
  • Create appointments, meetings and tasks
  • Plan and collaborate online

The Microsoft Outlook 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 Outlook 2013 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:
Outlook® 2013: Exam 77-423

Read more