Pivot Tables are amazing tools in Microsoft Excel that allow us to create interactive tables that automatically extract, organize, and summarize large amounts of data. Additionally, Pivot Table reports can be used to analyze data, make comparisons, detect patterns and relationships, and discover trends.
Want more — you got it! Watch our awesome Pivot Table tutorial below (hosted on our YouTube Channel) and let us know what you think.
Also be sure to check out our new website, Learn iT! Anytime for training videos for the entire MS Office suite!
On the anniversary of his 14th year at Learn iT!, we are proud to announce Jim Mollé as our featured employee.
Jim has been a consistent and amazing instructor throughout the years – he’s been our Instructor of the Year three times, in fact. And yet, his numerous accomplishments expand well beyond instructing.
Earned his Microsoft Office Master Instructor Certification in 1997,
Built all of our Microsoft Office Course outlines,
Mentored over 30 Learn iT! instructors,
Recorded all of Learn iT!’s Microsoft Office Learn iT! Anytime videos
All of that –yet perhaps his greatest accomplishment was converting Learn iT!’s paper courseware to digital. Jim’s revolutionary idea in June of 2000 was so forward thinking that it is now the norm for most training companies – and think about all the trees he saved!
In short, Jim is a true Learn iT! Hall of Famer.
“Jim Mollé is like family to me, I couldn’t imagine Learn iT! without him”
Damon Lembi, CEO Learn iT!
“Jim is the team member that makes things happen; he knows how to read the audience, cater courses to their needs, clients ask me time and time again to please have Jim Molle come back and teach our classes. Not only is Jim wonderful in the classroom he is an amazing Project Manager for Microsoft Office Migrations. Over so many years I have had the pleasure to work with Jim, and he always delivers A+ results!!”
Dalit Lewis, Senior Account Executive, Learn iT!
“Learn iT! is my “go to” partner for Microsoft Office training. All the instructors at Learn iT! are outstanding, Jim Mollé in particular is a step above the rest.”
Stu Shader, Business Productivity Specialist, Microsoft
So you (or your parents) just got an iPad and are feeling clueless. Or, maybe you want to learn some of the advanced features – like how to set up a video and music network between your PC and iPad.
And you’ll definitely want to know how to find it if it gets lost or stolen, right?
Well, today is your lucky day, because Learn iT! Anytime has launched iPad Training!
You can start with our “Beginner” module, or go to “Beyond the Basics” to get right to where you need help.
Microsoft® Lync® — an enterprise-ready communications platform integrates the various modes of communication necessary for people and businesses to be productive.
With Lync, users can keep track of their contacts’ availability; send an IM; start or join an audio, video, or web conference; or make a phone call—all through a consistent, familiar interface.
Lync is built to fully integrate with Microsoft Office. The Microsoft Lync 2010 desktop client is available for Windows and for Mac and mobile versions are available for Windows Phone, iPhone/iPad, and Android devices.
For more information, or to watch a sample video, go to Learn iT! Anytime.com – and use coupon code “linkedin” (without quotes) for a special discount!
Are you familiar with SmartArt — the diagram generating tool in Microsoft Office that displays text inside shapes? It’s perfect for creating anything from simple graphics to cutting-edge business diagrams.
To create a SmartArt graphic in Microsoft Excel, Word, PowerPoint or Outlook:
Click the Inserttab and then the SmartArt icon in the Illustrations group.
When the Choose a SmartArt Graphic dialog appears, choose the type of graphic from the category list on the left, and then the actual graphic to create.
If you’re unsure how a graphic should be used, click on the graphic to see its name and a description.
Here’s the best part, Microsoft has made it easy to quickly and easily switch between colors and shapes. When you “right click” your mouse, you can try different options until you find the one that best illustrates and conveys your message.
Also, consider the amount of text that you have. In general, SmartArt graphics are most effective when the number of shapes and the amount of text are limited to key points.
