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?
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. These steps can be recorded as a Macro if you wish to create your own keyboard click.
I am a fan of Conditional Formatting. Let’s look at the options. Here is a YouTube that you can watch if you wish. Thanks for stopping by.
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.
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
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.
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.
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:
A Table is a Table is a TableA 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!
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.