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

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

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

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

Getting it Right

My big brother was one of the first people to watch our Microsoft Office videos. He then offered several hours of “helpful,” unsolicited comments about the narration.

<Really? I don’t recall asking for advice.>

 Getting it Right: We struggled with the voice and narration. We wanted to record the narration the way it is taught in a live classroom. Something about the presentation and pacing is very effective.

We Succeeded. From one of our students: “This course was excellent. It was extremely efficacious in that it was designed to be hands-on, task based, with an incremental and coherent progression that clarified each skill that was to be developed in a manner that created a deep tacit understanding of the material. This was crucial because learning by rote, a teaching methodology I have encountered with other material, evaporates in the mind very quickly over a short period of time.

“In addition, Ms. Nofs’ personal teaching style, evidenced in the course and in her online persona “The Computer Mamma,” proved singularly useful in helping to highlight essential points and sustain interest in the material at hand.

“Her variations of intonation and stress combined with her use of pace, repetition, discourse markers, asides, rhetorical questions, etc., kept the material fresh and facilitated retention of the intended key points. It also made one feel as if a dialogue were being created between teacher/specialist and student. Her teaching style was very effective pedagogically.

“I highly recommend her courses – in person and online.”

P.M, Ph.B., M.A., A.D.V.S.

 

Learn with us!

Teachers Pay Teachers

https://www.teacherspayteachers.com/Browse/Search:computer%20mamas%20microsoft

Read more

Digital Design Theory: The BEST Job EVER in the Whole World

Digital Design Theory:I am really lucky. My job lets me color outside the lines and be creative. We had a blast with “Go, Blue” the video for Beginning Microsoft Word. Every screen has something animated.

Little Video Shows:I’ve wanted to do this since 1995 when I first figured out how eLearning would work. I saw that the story should be fun and educational. However, the story, or teaching, was only the top layer of many layers that linked to online content: reference links as well as up-sell links.

For our product, Microsoft Office, the story focuses on successful women and men who get the job done well. Our lessons show real world examples of practical solutions. I could draw it all out on storyboards, but how could anyone produce it in 1995?

The Computer Mama on PBS: I picked up the phone and called WFUM PBS in Flint. I announced (nope, didn’t ask) that I was going to do a program on computers. I had no television experience, no portfolio, not even a good suit. I was amazed when the Station Manager, Mr. Leon Collins, invited me to create a pilot program.

What fun!The hardware, the teleprompter and the editing software fascinated me. I remember Leon trying to explain the details of the co-production agreement but I just wanted to play with the talking Barney puppet and watch it interact with the program on PBS.

What did I learn?You should turn off the mic when you take a break. Everyone in the sound room heard me mouthing off to Mancini.

Great Software Works: Fast forward to 2015 and look at the tools that are available to teach and tell the story. The best shows can be produced on a desktop. The videos can have hyperlinks to more content online. The software is robust, affordable, and easy to use. The results are professional.

To my University of Michigan colleagues: Go Blue! Good luck, Coach Jim Harbaugh.

As Garrison Keillor sang: ”I’m, I’m from MICHIGAN and you’re from someplace else.”

Read more