12May 2015

Ctrl + C   

Performs the Copy function. You can highlight a word, sentence, bullet point, image or object and press this combination to copy the text including the formatting.

Ctrl + M

Insert a new blank slide. No need to use the Home tab on the Ribbon.

Ctrl + N

Create a new presentation. Don’t go to the File tab or the Office button; just press this combination for a new blank presentation to appear.

Ctrl + O  

Open a new presentation. This will display the Open dialog box allowing you to navigate to any file on your computer. No need to go through the File tab or Office button for this function.

Ctrl + P   

Print the current presentation, this shortcut combination will open the Print Preview window.

Ctrl + S   

Save the presentation. If you have not saved the presentation prior then you will be prompted to give the presentation a file name and specific a location. If the presentation has already been saved before it will save any changes you have made since opening or since you last pressed save.

Ctrl + V   

Performs the Paste function. Use this to Paste anything you have previously cut or copied.

Ctrl + X   

Performs the Cut function. You can highlight a word, sentence, bullet point, image or object and press this combination to cut the text from its original location.

Ctrl + Z   

Undo. Undo. If you make a boo-boo, undo. just UNDO.. You can press this multiple times to undo multiple things.

F12   

The F12 button will automatically perform a Save As regardless of if the file has been saved before or not.

F4

This is one of my favourites! F4 = repeat! If you have just highlighted some text and applied a specific numbered list, highlight the next text and press F4 and it will repeat the last step for you. A big time saver!

Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS
28Apr 2015

Charms

Win+C: Open charms

Win+Q: Search charm

Win+H: Share charm

Win+K: Devices charm

Win+I: Settings charm

Desktop

Win+D: Open Desktop

Win+,: Peek at desktop

Win+B: Back to desktop

Search

Win+Q: Search apps (tip: an even easier way to search apps is to just begin typing from the start screen)

Win+W: Search settings

Win+F: Search files

Windows 8 Apps

Win+Z: Get to app options

Win+.: Snap app to the left

Win+Shift+.: Snap app to the right

Ctrl+Tab: Cycle through app history

Alt+F4: Close an app

Other

Win+X: Open system utility settings menu

Win+PrntScrn: Take screenshot and save to Pictures

Win+Tab: Open switch list

Win+T: Preview open windows in taskbar

Ctrl+ESC: Start screen

Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS
13Apr 2015

Add or Delete Columns Keyboard Shortcut

Managing columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this keyboard shortcut. CTRL + ‘-‘ (minus key) will delete the column your cursor is in and CTRL + SHIFT + ‘=’ (equal key) will add a new column. From an earlier tip, think about CTRL + ‘+’ (plus sign).

Automatically SUM() with ALT + =

Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in every cell above.

Display Formulas with CTRL + `

When you’re troubleshooting misbehaving numbers first look at the formulas. Display the formula used in a cell by hitting just two keys: Ctrl + ` (known as the acute accent key) – this key is furthest to the left on the row with the number keys. When shifted it is the tilde (~).

Jump to the Start or End of a Column Keyboard Shortcut

You are thousands of rows deep into your data set and need to get to the first or last cell. Scrolling is OK but the quickest way is to use the keyboard shortcut CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell.

Logic for Number Formatting Keyboard Shortcuts

At times keyboard shortcuts seem random, but there is logic behind them. Let’s break an example down. To format a number as a currency the shortcut is CRTL + SHIFT + 4.

Tab Between Worksheets

Jumping from worksheet to worksheet doesn’t mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right enter CTRL + PG DN. And conversely change to the worksheet to the left by entering CTRL + PG UP.

Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS
31Mar 2015

General

Open a Workbook -> Ctrl + O

Create New – > Ctrl + N

Save – > Ctrl + S

Preview and Print – > Ctrl + P

Close a Workbook – > Ctrl + W

Help – > F1

Run Spelling Check – > F7

Calculate worksheets – > F9

Create an absolute normal or mixed reference – > F4 

Editing

Cut – > Ctrl + X

Copy – > Ctrl + C

Paste – > Ctrl + V

Undo – > Ctrl + Z

Redo – > Ctrl + Y

Find – > Ctrl + F

Replace – > Ctrl + H

Select All – > Ctrl + A

Edit active cell – > F2

Clear cell contents – > Delete

Formatting

Bold – > Ctrl + B

Italics – > Ctrl + I

Underline – > Ctrl + U

Open Format Cells Dialog Box – > Ctrl + Shift + F

Select All – >Ctrl + A

Select entire row – > Shift+Space

Select entire column – > Ctrl + Space

Hide selected rows -> Ctrl + 9

Hide selected columns – > Ctrl + 0

Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS
16Mar 2015

Office 365 is a hosted collaboration and productivity suite. Hosted meaning, everything you need is online and accessible from virtually anywhere because it’s not installed locally on your computer. And then there’s collaboration and productivity, meaning you get anywhere access to your emails, your contacts, your calendar, and web based versions of the Office suite apps like Word, Excel, PowerPoint, Outlook, and OneNote.

 What is Office 365? How is it different from Microsoft Office?

 “Office 365″ refers to subscription plans that include access to Office applications plus other productivity services that are enabled over the Internet (cloud services), such as Lync web conferencing and Exchange Online hosted email for business, and additional online storage with OneDrive and Skype world minutes for home.

 Many Office 365 plans also include the desktop version of the latest Office applications, which users can install across multiple computers and devices. The Office 365 plans that are online-only are a great choice for certain business needs, and they are compatible with desktop versions of the latest version of Office, Office 2010, Office 2007 (with slightly limited functionality), Office 2011 for Mac, and Office 2008 for Mac.

 All Office 365 plans are paid for on a subscription basis, monthly or annually.

 “Microsoft Office” is the name we still use for our familiar productivity software. Office suites have traditionally included applications such as Word, Excel, PowerPoint, and Outlook. All the new Office suites (for example, Office Standard 2013) include the latest versions of these applications. These suites can be installed on only one PC and do not come with any cloud-based services included in Office 365.

 Will Office 365 work with my copy of Office?

 Office 365 works best with the latest version of Office, Office 2010, and Office 2011 for Mac. Office 365 works with slightly limited functionality with Office 2007. If you have an earlier edition of Office, you will need to update to a newer version of Office in order to use Office 365; or you can subscribe to one of the many Office 365 plans that include the latest version of Office. In addition to getting the latest version of Office as part of your subscription, you will also get automatic updates, so your Office will always be up to date.

 Is Internet access required for Office 365?

 Internet access is required to install and activate all Office 365 plans and to manage your subscription account. Internet connectivity is also required to access Office 365 cloud productivity services, including email, conferencing, IT management, and other services.

Many Office 365 plans also include the desktop version of Office, for example, Office 365 Business Premium and Office 365 Enterprise E3. One of the benefits of having the desktop version of Office applications is that you can work offline and have the confidence that the next time you connect to the Internet all your work will automatically sync, so you never have to worry about your documents being up to date. Your desktop version of Office is also automatically kept up to date and upgraded when you connect to the Internet, so you always have the latest tools to help you work.

What is the cloud?

 “The cloud” is a friendly way of describing web-based computing services that are hosted outside of your organization. When you use cloud-based services, your IT infrastructure resides off your property (off-premises), and is maintained by a third party (hosted), instead of residing on a server at your home or business (on-premises) that you maintain. With Office 365, for example, information storage, computation, and software are located and managed remotely on servers owned by Microsoft. Many services you use every day are a part of the cloud—everything from web-based email to mobile banking and online photo storage. Because this infrastructure is located online or “in the cloud,” you can access it virtually anywhere, from a PC, tablet, smartphone, or other device with an Internet connection.

 How many users does Office 365 support?

 Office 365 is highly scalable and can support everything from a one-person business to companies with tens of thousands of users:

  • Office 365 Business plans are best for companies with one to 300 users.
  • Office 365 Enterprise plans fit organizations ranging in size from a single employee to 50,000-plus users.

What mobile apps are available for Office?

 Office provides the following apps:

  • Office for Android™: View, create and edit documents with touch-friendly Word, Excel and PowerPoint apps. You can count on Office for Android to keep your content and formatting intact so the document looks great when you’re back on your PC or Mac. In Word, add comments or track changes while you work together with others. Review and update Excel spreadsheets and easily add formulas or charts. Make changes to PowerPoint presentations and project them wirelessly on a big screen.You can view documents for free with Office for Android. Editing and creating documents requires an eligible Office 365 subscription: Office 365 Home, Office 365 Personal, Office 365 University, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E3 and E4, Office 365 Enterprise E3 and E4 (Government Pricing), Office 365 Government E3 and E4, Office 365 Education E3 and E4 for Students, Office 365 Education E3 and E4 for Faculty, and Office 365 ProPlus.
  • Office for iPad®: View, create and edit documents with touch-friendly Word, Excel and PowerPoint apps. You can count on Office for iPad to keep your content and formatting intact so the document looks great when you’re back on your PC or Mac. In Word, add comments or track changes while you work together with others. Review and update Excel spreadsheets and easily add formulas or charts. Make changes to PowerPoint presentations and project them wirelessly on a big screen.
    You can view documents for free with Office for iPad. Editing and creating documents requires an eligible Office 365 subscription: Office 365 Home, Office 365 Personal, Office 365 University, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E3 and E4, Office 365 Enterprise E3 and E4 (Government Pricing), Office 365 Government E3 and E4, Office 365 Education E3 and E4 for Students, Office 365 Education E3 and E4 for Faculty, and Office 365 ProPlus.
  • Office Mobile:Office Mobile is preinstalled on Windows Phone 8 and is available for select models of iPhone® and Android phones. Office Mobile offers great Office content viewing and on-the-go content editing capabilities. And you can count on Office Mobile to keep your content and formatting intact so the document still looks great when you’re back on your PC or Mac. Office Mobile for iPhone and Android phones can be used for free for non-commercial use, simply download the app from the store on your phone.In order to edit or create documents or to access documents stored in SharePoint and OneDrive for Business on premises, you must have a qualifying Office 365 plan: Office 365 Business Premium, Office 365 Enterprise, Office 365 Enterprise E3 and E4 (Government Pricing), Office 365 Government E3 and E4, Office 365 Education E3 and E4 for Students, Office 365 Education E3 and E4 for Faculty, Office 365 ProPlus, and Office 365 University.
  • Outlook Mobile:Windows Phone 8 includes a pre-installed version of Outlook that you can use to access your Outlook.com, Office 365, or Exchange email.
  • OneNote:You can use the mobile OneNote app to access your notes while on the go. This app is available on Windows Phone 8, iPhone, iPad, and Android phones.
  • OWA (Online Web App):If you have an Office 365 subscription that includes Exchange Online, you can use the OWA app to sort, scan, and respond to email, and stay on top of your schedule. This app is available on iPhone and iPad.
  • Lync Mobile:If your organization uses the newest version of Lync, you can use the mobile Lync app to stay connected while on your mobile device. This app is available on Windows Phone 8, iPhone, iPad, and Android phones.
  • SharePoint Newsfeed: If your organization uses the newest version of SharePoint, you can use the SharePoint Newsfeed app to access your newsfeed from your mobile device. This app is available on Windows Phone 8, iPhone, and iPad.
Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS
02Mar 2015
  • Many Books:

It provides you with free ebooks for your eBook Reader, iPod or PDA. You can browse for any ebook through the most recommendations or recent reviews from visitors or you can even search and download free books in categories like scientific, engineering, programming, which you may feel interesting. There are 23,568sss eBooks available in it and they’re all free.

Go to : www.Manybooks.com

  • Online Free ebook:

It provides various links to various ebooks (pdf format) spanning in 9 categories which are used fors daily purposes, they are: Business Ebooks, Gadget Ebooks, Engineering Ebooks, Automotive Ebooks, Health & Medical Ebooks , Hobbies Ebooks, Hardware Ebooks, Sport & Martial Art Ebooks, Programming & Technology Ebooks. It is especially designed to add all this stuffs in your Pocket PC, EPOC, Windows CE, Symbian or other handheld device.

Go to www.onlinefreeebooks.net

  • Free-eBooks:

It is an online store for free ebook authors, ebook resources, ebook downloads. Besides of it you can also download free magazines from it. Each ebook has its own short review in the description. You can also submit your own ebook, you just need to become a member of the Free-EBooks.Net to access their library. You can Register it for free.

Go to: www.free-ebooks.net

  • KnowFree:

It is a free website for ebook where users are able to exchange e-books for free and it also gives video training and other materials for educational purposes and also includes self-practice. It consists of thousands of documents like literature, lists, maps, databases, technical references, etc.

 Some more Free Websites to Download E-books :

Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS