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
16Feb 2015
  • Ctrl + Shift + C (Copies the formatting of selected text)

This is very useful when you only want to copy the formatting of the text only and not the text itself. Use ‘Ctrl + Shift + V’ on a selected text to apply the formatting you just copied.

  • F4 (Repeats your most recent command)

Word remembers the last action you performed and pressing this shortcut will repeat that action. This is very handy when you have to apply some action repeatedly.

  • Ctrl + F6 (Cycles through all open Word documents)

When you have multiple word documents open (pretty much all the time in my case) this shortcut allows you to cycle through them. Use ‘Ctrl + Shift + F6′ to cycle back.

  • Alt + Shift + Left/Right arrow key (Creates headings)

Hold the  Alt+Shift  keys down and press the Left or Right arrow on the keyboard – Left arrow to create a main Heading or Right arrow to create a subheading. Alternatively, use ‘Ctrl+Alt+1′ to create a Heading 1, ‘Ctrl+Alt+2′ to create a Heading 2.

  • Double click and Triple Click (Select word or paragraph)

Double-click on a word to select it, triple-click to select the paragraph. Ctrl+Click to select a sentence.

  • Alt + drag the mouse vertically (Make a vertical text selection)

Really useful when you want to select some texts/words vertically

  • Ctrl + 0 (Applies or removes 12 points of space above the current paragraph)

If you want to improve readability by adding some space above a line then this shortcut should do it.

  • Shift + Left/Right Arrow keys (Selects text character by character)

When you have selected some text using your mouse and you missed a few characters, this shortcut can save you without having to deselect and re-select again.

  • Ctrl + drag (Copies the selected text or object)

This shortcut allows you to copy a picture for example and drop it exactly where you want it easily.

  • Ctrl + F (Opens the Find tab)

Use this shortcut to open the find tab when you want to search of a text in word. Use ‘Ctrl + H’ if you want to use find and replace.

  • Few shortcuts for quick text formatting

Ctrl+B to make bold,  Ctrl+I to make italic, or  Ctrl+U to underline. Use  Ctrl+L to left-justify text,  Ctrl+E to center it,  Ctrl+J  to justify it, and  Ctrl+R to right-justify it.

  • Shift + F5 (Returns to the last edit point)

Very useful when you have to copy some text from other parts of the document and you want to return to where you were in order to paste it.

  • Shift + F3 (Changes the case of any selected text)

This word shortcut is very useful when you want to toggles through the capitalization options. If you have a few lines of text in all uppercase and you want it to be in lowercase then this shortcut should make your life heaps easier.

  • Ctrl + Enter (Inserts automatic page break)

It’s amazing how many people use manual page break (Press enter key repeatedly to bring some chapter/line to the next page)! Manual page break is a maintenance nightmare cause as soon as you enter a line in the document you will have to manually fix all the other pages again. Use page break and make your word editing life easier.

  • Ctrl + Shift + N (Applies the Normal style)

This removes the formatting of the selected text. Very handy when copying stuff from the web which has different formatting applied to the text than your document. This shortcut will remove all those formatting and make it consistent with the formatting of your document.

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

Common password mistakes:

Many people create passwords based on their spouse’s names, kids names or birthdays, a hobby, or a simple pattern, since those types of passwords are easy to remember. Unfortunately, they are also very easy for hackers to guess.

Create strong passwords:

  • Never use personal information such as your name, birthday, or spouse’s name. Personal information is often publicly available, which makes it much easier for someone to guess your password.
  • Use a longer password. Your password should be at least six characters long, and for extra security it should ideally be at least 12 characters (if the site allows it).
  • If you need to write down your passwords, keep them in a secure place. It’s even better if you encrypt your passwords, or just write down hints for them that others won’t be able to understand.
  • Don’t use the same password for each account. If someone does discover your password for one account, all of your other accounts will be vulnerable.
  • Try to include numbers, symbols, and both uppercase and lowercase letters (if the site allows it).
  • Avoid using words that can be found in the dictionary.
  • Random passwords are the strongest. For example, “m&t7T5$dAY”.
Keshnie Bhugwandin on twitterKeshnie Bhugwandin on linkedin
Keshnie Bhugwandin
Training and Business Unit Developer NETWORK CONFIGURATIONS
  • 1
  • 2