Must have Gadget : Lumia 950XL with Free Fitbit Flex + Free Office 365


fitbit-header-phones

Bundle smartphone deals which come along with free value add-ons are almost non-existent in the South African smartphone market. When last did you buy a brand new smartphone and get some freebies thrown, just to say thank you? Well Microsoft is offering an unbelievable deal when you buy the flagship Windows 10-based Lumia 950XL smartphone. Continue reading

How To Use Office 2016 For Free


There are various ways you can access Microsoft’s latest Office suite

office-2016_story

So Office 2016 is out and you want to get your hands on it so bad, but you are not willing to part with your money . . .just yet? Well there is good news for you : If you’re not a power user and don’t need all the latest and greatest features, then you can access Office 2016 . . .well.  . .for free!

Continue reading

Microsoft Office 2016 Released


Now Generally Available Worldwide

office-2016-windows

As promised, Office 2016 has been released is now generally available worldwide. The full Office for Windows 2016 suite includes new versions of Word, Excel, PowerPoint, OneNote, Outlook, Project, Visio and Access.  Along with Office 2016 for Windows, Microsoft also released Office 2016 for Mac as a one-time purchase option, along with several new and enhanced Office 365 services. Continue reading

Microsoft Office 2016 : Coming 22 September


The Long Awaited Release Is Finally Here

office-2016_story

Microsoft officials have confirmed that the Office 2016 for Windows rollout will begin on September 22. This is not a big surprise for most people in the tech world, however the release of Office 2016 is perfect timing as it comes  hot on the heels of the release of Microsoft flagship operating system, Windows 10. Continue reading

Office 365 : Buy Or Rent MS Office


Software Subscription : The Future Of Software Delivery

slideoffice

Recently my colleague and fellow blogger, Sonja setup my Office365 work account. After a few minutes of information overload (yes, even us developers are vulnerable to that too!) I decided to settle down, research and acquire a thorough understanding of Office 365, and most importantly understand why I need it my life, and I must say the results were startling! Continue reading

Dropbox Comes To Microsoft Office Online


Some Partnerships Not Only Make Sense, They Actually Improve Users Productivity!

BLOG-Office-Dropbox-Blue-Blog

 

Microsoft announced on the 9th of April 2015 that Office Online users can now link their Dropbox accounts to Office Online and be able to browse, open and edit Office files when using the Webified version of Office. Now with this new partnership users can now create Office documents in Office Online and save them directly in Dropbox! The best news is, the feature is now available to all Office Online users Continue reading

How to Enter Sample Filler Text in Microsoft Word


To generate the random text start a new line of text with one of the following formulas.  Type the following in your Word document:

Word Random Text

=rand(8)

This would generate 8 random paragraphs of text.

=rand(?)

This gives you how ever many paragraphs you substitute for the question mark. eg: =rand(2) gives you 2 paragraphs of random text.

=lorem(8)

This would generate 8 random paragraphs of non-sense Latin.

Another option you have is to control how many lines each paragraph has.

=rand(p,l)

Where the p = ? of paragraphs and the l = how many lines per paragraph.

=rand(9,15)

This would give you 9 paragraphs with each paragraph containing 15 lines respectively.

A final note: If your Word formulas do not work it is most likely because the autocorrect options are turned off. Find the AutoCorrect button from Word options, Proofing.

Check out Steve Chase Docs for more interesting blogs

Banner-MOS2010

Microsoft Office Certifications


Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their skills and advance their careers.

With three certification levels, the MOS credential allows individuals to validate their skills and progress toward their career goals.

With the new MOS 2013 exams, testing candidates are presented with a project that they must complete. Rather than being a series of required tasks, individuals now must complete a project that delivers a better indicator of real world Office 2013 use. As such, individuals are measured on their performance at a deeper skill level.

At the Core and Expert level, individuals get certified in specific Microsoft Office applications. At the Master level, individuals must successfully complete 4 certification exams – 3 required and 1 elective.

InfoGraphic by LGIT Smart Solutions

MOS Certifications

MOS aligned courses at LGIT Smart Solutions:

PowerPoint:

Beginner  |  Intermediate  |  Advanced

Word:

Beginner  |  Intermediate  |  Advanced

Access:

Beginner  |  Intermediate  |  Advanced

Outlook:

Beginner  |  Advanced

OneNote:

1-day Course

Office 365:

End-User

Excel:

Beginner  |  Intermediate  |  Advanced

Optional:  Pivot Tables  |  VBA Excel

SharePoint:

Intro  |  End-User  |  Power-User

 

Avoid repeating yourself: Create a Word macro


repeatRepeatedly entering the same information in document after document, over and over…there has to be a quicker way, right? Word macros can save you time (and potentially, some sanity) by automating repetitive tasks.

Let’s say you’re a real estate agent. Every time you sell a house you have to add a client’s name and address to multiple documents. Creating a macro automates adding all of a client’s contact information wherever you need to.

Setting up the macro

Creating a macro is straightforward and doesn’t require any coding knowledge. You simply tell Word when to start and stop recording a series of steps; for example, from when you start typing a client’s name to when you finish. Then Word will perform all of those steps automatically when you click a button or enter a keyboard shortcut that you assigned to that macro.

Here’s a step-by-step

WordMacro

Click here to read the step-by-step further