Subpage Listing

Get new Gmail for G-Suite Legacy\Paid users

posted Jul 29, 2018, 7:37 PM by Sanjeev Jain   [ updated Jul 29, 2018, 7:40 PM ] gets its biggest upgrade in the service's history. There's a new Confidential Mode, the ability to set expiration dates and passcodes for emails, and other advanced security features.

If you’re using a G-Suite Legacy\Paid Account, your account administrator will have to turn on the new interface for you.

Here is the hidden link you can use from admin account: Click Here

We hope you find this interesting and valuable. 

For any support please contact us on 1 800 3060 1067  | Vandana@Ceoitbox.In  | Www.Ceoitbox.Com 

             We also conduct unique Tech Workshop to help  you build Remarkable Intranets !                 

Tech Mastery 2018

These Windows shortcuts can save you min 46 hours per year

posted Jul 15, 2018, 7:28 AM by Sanjeev Jain   [ updated Jul 15, 2018, 7:29 AM ]

When it comes to using your computer, it's keyboard shortcuts that get things done the fastest. And for every version of Windows, Microsoft add a few useful new ones to the old standbys. Here are our favorites.

New Windows 10 keyboard shortcuts

The Windows key is the key on your keyboard that has the Windows logo on it. On a regular desktop keyboard, it sits between the Ctrl and Alt keys to the left of the space bar.  Pressed by itself, the Windows key opens or closes the Start menu, but when pressed in combination with other buttons, it works wonders.

Desktop and Cortana shortcuts

  • Windows key + A This key combination opens the Action Center menu at the right side of the screen. Here you can view your notifications and access commonly used settings like Wi-Fi and Bluetooth.
  • Windows key + I If you need to modify your computer’s settings, this is the key combination to press. It opens the Settings app (known in previous Windows versions as Control Panel).
  • Windows key + C Open Cortana in listening mode with this keystroke to perform a quick search using your voice. Voice search is supported in selected countries only. If voice search is disabled or turned off, you can still use text search on Cortana.
  • Windows key + S If you want to find a file or an app installed on your computer or search for a term on the Web, this is the keystroke to press.

Task View and Virtual Desktop

Windows buttonOne of Windows 10’s new useful features is the ability to create multiple virtual desktops. They let you group related applications for more efficient multitasking. For instance, you can open all work-related apps on the first desktop, your browser for personal browsing and personal apps on the second desktop and so on. You can also move open apps from one desktop to another.

  • Windows key + Ctrl + D Create a new virtual desktop with this combination. You can open new sets of applications and programs in the new virtual desktop.
  • Windows key + Ctrl + Left Switch to the next virtual desktop on the left.
  • Windows key + Ctrl + Right Switch to the next virtual desktop on the right.
  • Windows key + Tab Opens Task View, which shows you all the currently running programs on a desktop. If you’re using more than one virtual desktop, you will see them below the switcher in Task View and you can switch between desktops.
  • Windows key + Ctrl + F4 Remove a virtual desktop without terminating the apps running within that desktop. Any open application on the removed desktop will be moved to the next available virtual desktop.

Command Prompt shortcuts

The Command Prompt (or command line terminal or DOS prompt) lets you perform many functions such as moving, copying and deleting files and folders using text-based commands without having to click and use the graphical user interface.

Windows 10’s Command Prompt has new shortcuts, but to be able to use them, you need to set some options in the Options tab. Here’s how:

  1. On the Command Prompt window, right-click on the title bar and select Properties.
  2. On the Options tab, disable Use Legacy Console.
  3. Also, enable Enable Line Wrapping Selection and Extended Text Selection Keys under Text Selection.

The following Command Prompt shortcuts have been staples in text editors and word processors, but they are new to the Command Prompt.

  • Shift + Left Highlights one character to the left of the cursor.
  • Shift + Right Highlights one character to the right of the cursor.
  • Ctrl + Shift + Left Highlights a block of text to the left of the cursor.
  • Ctrl + Shift + Right Highlights a block of text to the right of the cursor.
  • Ctrl + A Highlights all text in the Command Prompt window.
  • Ctrl + C Copies the highlighted text to the Clipboard.
  • Ctrl + V Paste the Clipboard contents to the Command Prompt.

Other helpful keyboard shortcuts

Commonly used shortcuts for Windows

  • F2 Select a file, then press the F2 function key to rename it.
  • F3 Search for a file in File Explorer. If pressed in a browser window, the Find in Page function activates instead.
  • F4 Show the Address Bar in File Explorer.
  • F5 Reload or refresh the content of the current File Explorer window. If used inside a browser, this reloads the web page.
  • F6 Cycle through the different interface elements of the active window. The first time you press this key, the Display Information button will be highlighted, then the Address Bar, and so on. To execute the highlighted button, press the Enter key. If multiple items are highlighted, use the arrow keys to navigate.
  • F10 Activate the shortcut functionality in File Explorer. When pressed, an overlay appears showing letters or numbers on top of menus and buttons. Pressing a button or letter executes the corresponding command or open the corresponding menu or dialogue.
  • Ctrl + C This is the standard Copy shortcut. It copies the selected item (text, objects, files, and so on) to the clipboard.
  • Ctrl + X This is the standard shortcut for the Cut command. When the cut item is pasted elsewhere, it is removed from its original location.
  • Ctrl + V This is the standard keystroke for the Paste function. It puts the Clipboard’s content into the current window.
  • Ctrl + Z Reverse a previous action. This is also known as the Undo shortcut.
  • Alt + Tab Switch to the next open app.
  • Alt + F4 Close a running app or program.
  • Shift + Delete Delete a file permanently, bypassing the Recycle Bin.
  • Windows Key + L Lock the computer screen.
  • Windows Key + D Minimize all running programs and shows the Desktop.

Other shortcuts using the Windows Key

  • Windows Key + E Launch File Explorer, which is used to locate and manage files saved in your computer.
  • Windows Key + G Open the Game Bar so you can take a screenshot or record a video while playing a game.
  • Windows Key + H Press this combo to open the Share charm or side popup so you can quickly share files via email, social media or other apps capable of file sharing.
  • Windows Key + K Opens the Connect Quick menu to quickly connect to a wireless display or audio device.
  • Windows Key + M Minimize all open windows.
  • Windows Key + Shift + M Restore all minimized windows.
  • Windows Key + P Toggle a presentation display mode when using multiple screens. You can choose to show the display on the main screen only, duplicate the display on the second screen, use the second display as an extension or use only the second display attached to the computer.
  • Windows Key + R Open the Run dialog box where you can execute commands, open files and launch programs.
  • Windows Key + T Cycle through apps pinned on the Taskbar. When the app you want is highlighted, press Enter to launch it.
  • Windows Key + U Open the Ease of Access Center window for configuring accessibility features.
  • Windows Key + X Open the Quick Link menu to access tools such as Command Prompt, File Explorer, Settings and Task Manager.
  • Windows Key + Pause Open the System Properties window, which contains technical information about your computer. You can also find here settings that determine how your computer behaves or functions. Requires admin access.
  • Windows Key + PrtScr Take a screenshot of the display and saves it to Computer > Pictures > Screenshots.
  • Windows Key + Arrow key (up/down/left/right) Sometimes you want to see the contents of more than one window at a time. This key combination snaps the current window to the edge of the screen, depending which cursor key you press. Up to four windows can fit on one screen. For instance, to snap a window to the lower right corner, press Windows Key + Down, then press Windows Key + Right.
  • Windows Key + , (comma) Hold down this key combination to temporarily hide open apps and windows and show the Desktop. When the keys are released, the hidden apps and windows return to their original positions.

For more news & articles visit us at

What are Intranets and why they are Critical for your Company

posted Jul 8, 2018, 12:29 PM by Sanjeev Jain   [ updated Jul 8, 2018, 10:27 PM ]

This is a video guide, please see the video below.

Guide to Intranets

We hope you find this interesting and valuable. 

For any support please contact us on 1 800 3060 1067  | Vandana@Ceoitbox.In  | Www.Ceoitbox.Com 

             We also conduct unique Tech Workshop to help  you build Remarkable Intranets !                 

Consolidate multiple email accounts using Gmail

posted May 13, 2018, 10:22 PM by Sanjeev Jain   [ updated Sep 12, 2018, 9:24 AM ]

It is not uncommon to have several email accounts, but checking multiple accounts in different places is tedious. Hence, many people revert to a desktop email client like Thunderbird or Outlook to manage all their mail from one place. 

However, I found that Gmail can do the same and it can do it much better. Since I switched, I no longer have to worry about backing up or moving my profile, I save a bit of RAM as my browser is running anyway, I save several gigabytes of hard drive space, and no matter where I check my mail, it’s always the same familiar inbox and setup greeting me.

Besides, Gmail has an ingenious search feature, some fun and very useful Google Labs plugins, and with browser extensions you can get even more cool features. In other words, it’s bliss and I would like to share that with you.

Let Gmail become your one account to rule them all! 

STEP1: Import Email Accounts Into Gmail

The best way I recommend is that instead of importing email from other accounts, its best that you forward the email from those accounts to your main Gmail account. For more detailed instructions, Click Here

Much like a desktop client, Gmail can handle multiple email accounts. Moreover, it makes importing mail from POP3 accounts fairly easy, by automatically filling in the required POP server information for you.

Let’s say you want to import email from an old Hotmail account, what would you need to do?

  1. Open Google Mail, click the wheel icon in top right and select Settings from the drop-down menu.
  2. In your Gmail settings, go to the Accounts and Import tab.
  3. Under the header Check mail using POP3 click Add a POP3 mail account you own.
  4. Fill in your email address and click Next Step.
  5. In the next window, add your password, check the boxes that apply, and click Add Account.
  6. For more detailed instructions, Click Here

The video below illustrates how to do this easily.

STEP2: Configure your Main Gmail account to send email as other account

If you are using the paid G-Suite account and get the following error you may need to enable this functionality from your Administrator Console.

How do I allow or disallow users to use an outbound gateway?

By default, users cannot use an outbound gateway; the G Suite mail servers deliver all outgoing mail, including mail that uses alternate From addresses.

To allow users to use an outbound gateway:

  1. Sign in to the Google Admin console.
  2. From the dashboard, click Apps, then click G Suite > Gmail > User settings.
  3. In the Allow per-user outbound gateways section, select Allow users to send mail through an external SMTP server when configuring a "from" address hosted outside your email domains.

    When this check box is selected, users who associate additional email addresses with their accounts have the option to enter connection information for an alternate SMTP server. (Learn more about the required steps for the user.) When the check box is not selected, users cannot specify an SMTP server for the additional address.
  4. Click Save changes.

It can take up to an hour for the changes to propagate through Google systems.

Are you using these 3 amazing Google Sheet features ?

posted Feb 9, 2018, 9:16 AM by Sanjeev Jain   [ updated Sep 12, 2018, 8:41 AM by Sanjeev Jain ]

1. Protect your Google Spreadsheet data from accidental or malicious changes with these 3 methods.

The ability to share and collaborate on a spreadsheet in Google Apps is an excellent feature, but it may mean you need to look more carefully at protecting your data from unwanted edits. There are 3 key ways to do this.

Protect a Worksheet

Protect individual worksheets in a Google Spreadsheet. To do this, select Tools from the menu and choose Protect sheet. You have the option to set permissions, much like a Google Doc, that will give editing rights to: anyone invited as a collaborator; only you; or a list of collaborators. If you need to stop collaborators from editing certain cells, you could place those cells in a "Results" worksheet and make that read-only. Formulas can reference any worksheet so cells that need data entry can be "opened up" and cells that have a formula can be "locked" in a protected worksheet.

Set Up Notifications

Get notified of any changes in a Google Spreadsheet by setting up notification rules. To do this, select Tools from the menu and choose Notification rules. You have the option to be notified when changes are made to: the spreadsheet; a specific worksheet; a cell or cell range; collaborators; or (if the spreadsheet is joined to a form) when a user submits a form. Notifications can be sent as soon as a change is made or as a daily summary.

The first 2 options are straightforward changes that offer good options to protect most spreadsheets, by stopping editing and notifying you if changes are made. But what if you need to protect a series of cells or an individual cell? Google Spreadsheets currently doesn't have this functionality, so a workaround is required.

Set Data Validation

Stop individual cells, or a range of cells, from being edited by setting a value that the cell must have. Choose to set a NumberTextDate or Items from a List. Each criteria has further settings, for example: a Number cell can be a range or maximum value; a Text cell can be set to contain or not contain word(s); a Date cell can be set to be a valid date only; and a List cell can only be populated from a list. A further option enables you to either warn the editor that validation rules have not been met but allow the change, or disallow any changes that do not meet the criteria.

Data validation is a very useful method to ensure that cells containing a formula are not mistakenly edited. To do this:

  • select the cell or range you want to be validated
  • select the Text criteria and set the second drop down to "equals"
  • in the blank box add your cell formula
  • untick the Allow invalid data box.

2. Try SPARKLINE for Sheets: miniature charts in a single cell

Google have just introduced a great feature in Sheets: SPARKLINE

The SPARKLINE function allows you to create miniature charts within a single cell to rapidly provide an attractive visual representation of data and trends.

Google recently added the two new types - column and winloss - along with the existing line graph and bar chart.

Our example shows a sheet with some data (source Wikipedia) on human population by country and represents the trend in population growth/decline over the years 1990, 2008, 2025.

We show 3 types of SPARKLINE charts: line, bar & column.

The function codes for each are:


Bar:=SPARKLINE(C2:E2,{"charttype","bar"; "color1", "blue"; "color2", "red"})

Column:=SPARKLINE(C2:E2,{"charttype","column";"max",1500; "color", "orange"; "lowcolor", "blue"; "highcolor", "red"})

Here’s a link to a copy of our example sheet. Click on  “Make a copy” option to take a copy for yourself to have play with.

3. The Explore function in sheets magically turns the data in your Google Sheets into charts and analysis


Google’s constant innovation continually provides Apps users with new ways to use and gain benefits from files and data.

The Sheets Explore function generates charts enabling insight and analysis on data for Sheets users who have little knowledge or confidence in using charts or just saving you some time making your own.

In the examples below we’ve used this handy demo sheet with some simple data: Example Spreadsheet

To access Explore, open a spreadsheet.

To work on a specific portion of your data you can select a range of cells. By default, Explore works on where your cursor is in the current worksheet.

  • In the bottom right, look for the Explore icon Explore.
  • When the icon is green you can click it to see recommendations and tips.
  • When the icon is grey, there is no analysis to see.
  • Charts and analysis will pop-up, showing trends and patterns in the data in your worksheet.
  • Hover over a chart to see which data in the spreadsheet is being used in that chart.
  • You can change the recommendations by selecting different areas of data in your worksheet.

To close the Explore panel, click the X in the top right corner.

To add a chart or formula into your spreadsheet

  • To add a chart or formula from the Explore panel into your worksheet you can it onto your spreadsheet.
  • Alternatively by clicking the Insert chart icon Insert chart.

Note: You must have edit permission on the file to be able to add a chart or formula to a spreadsheet.

Once a chart is added into your spreadsheet you can use the Advanced edit… option from the drop-down menu in the top right of the chart

Use the This Example Spreadsheet (Click Here) and have a play!

Hope you liked the above article. We do some amazing & unique workshops that can help you Scale up & Automate business. 

With these tools in our workshop you can automate 70% of  your business:

Are you using heat maps in Spreadsheets?

posted Feb 9, 2018, 9:16 AM by Sanjeev Jain   [ updated Sep 12, 2018, 8:45 AM ]

1. How to turn your data set into a heat map 

The recent update to conditional formatting in Google Sheets allows you to turn any data set into a coloured heat map with just a couple of simple steps. This is great for identifying trends and patterns and cuts out the process of having to create a separate chart or graph.

A data heat map highlights each cell with a different colour depending on the figure. So you can set the colour to a light shade for low figures and a darker colour for high figures. A great example is using the heat map to identify trends in your sales report, allowing you to see what months have been the most successful.

To create your own heat map, follow the simple steps below:

  • Select your data in the Google Spreadsheet.
  • Go to Format - Conditional Formatting (or Right click). This will open a Conditional format rules panel.
  • Select the colours for your Minpoint, Midpoint and Maxpoint
  • Adjust your Midpoint to a Percentile

To easily identify your data even further, you can select your data and click add new rule. If you want to see your top figures (e.g. above £1000) select greater than in Format cells if… add your Value into the box and you can choose to have these figures in bold for example.

2. Turn on colourful rows or columns via this neat  trick


In Google Sheets the Conditional Formatting feature provides the ability to format cells if they meet certain conditions, such as if they contain a certain word or a number.

e.g. if a cell contains the string “Yes” make the background green, or “No” make the background red.

To access Conditional Formatting in a Google Sheet:

  • Click Format > Conditional formatting (A toolbar will open to the right)
  • Create a rule via Add a new rule
  • Use Apply to a range to select the range to be formatted
  • Under the Format cells if… drop down select Custom formula is (the last option)
  • In the box Value or formula use one of the following formulae:



Apply to Even Rows


Apply to Odd Rows


Apply to Even Columns


Apply to Odd Columns


Then select the Formatting style such as a colour.

3. Say goodbye to spelling mistakes in Google Sheets


For the majority of us fast typers Spell Check plays an important role spotting our mistakes as we type.

Luckily for us Spell Check has finally been added to the new Google Sheets. Spell Check with Google Sheets behaves just the same as it does with Docs or Slides. You can choose to check your entire Sheet, individual worksheets or even columns and cells. Here’s how to spell check your Sheet:

  • Highlight the cell range or columns you wish to check
  • Click the tools tab and select Spelling
  • Google will identify any mis-spellings
  • Click change, ignore or add to dictionary

If you are working with a Sheet created in the old version of Google Sheets, Spell Check is also available, in a slightly different format. After you choose Spelling, a pop up box will open - simply click on the identified mis-spelling and choose from a list of suggested corrections.

Hope you liked the above article. We do some amazing & unique workshops that can help you Scale up & Automate business using Free Technology that is already in front of you. Find our more using links below:

Identify and Preventing Phishing Attacks

posted Oct 31, 2017, 6:22 AM by Sanjeev Jain   [ updated Sep 12, 2018, 5:53 AM ]

When we think of hackers and cyber criminals, we tend to think of  them as masterminds wearing hoodies, shutting down websites with  their out-of-this-world coding skills (and godly swagger of course!).

Well, that’s not always the case. Using a simple yet highly impactful technique like Email Phishing, any  Tom, Dick, or Harry can fool users to commit online fraud.

You don’t need to learn a dozen coding languages to employ phishing  scams and take control of systems. A huge part of the reason that phishing is so popular is its lack of  sophistication.

The below slides explain what is Phishing & how you can protect your valuable data from such attacks.

PhishingScams 8 Helpful Tips To Keep You Safe

Click on this to download the E book

Technology for transporters

posted Aug 7, 2017, 8:00 AM by Sanjeev Jain

Was invited to speak about leveraging technology for Transporters at the GST Convention for All India Transporters Welfare Association  on 29th July 2017.

How to Track Processes using this Amazing Google Sheet

posted Jul 4, 2017, 10:12 AM by Sanjeev Jain   [ updated Jul 4, 2017, 11:54 PM ]

Scaling up an organisation requires that you setup processes for everything - From Getting the Order to Getting the Payment. 

Even after spending hours upon hours in developing flowcharts, procedures and checklists, businesses still struggle to ensure that the processes are actually followed. 

In the video below we show you how to use this Amazing Google Sheet to track each and every process in your organisation with ease. 

Please fill out the form below to receive a copy of the "CEOITBOX Process Tracking Sheet"

CEOITBOX Tech Tips Capture Page

Windscribe - Free VPN and Ad Block

posted Sep 17, 2016, 10:46 PM by Sanjeev Jain   [ updated Sep 17, 2016, 10:47 PM ]

Windscribe helps you mask your physical location, circumvent censorship, block ads and trackers on websites you use every day.
Windscribe is a desktop application and browser extension that work together to block ads, trackers, restore access to blocked content and help you safeguard your privacy online.

* Access Anything from Anywhere
Internet was meant to be open, but that's no longer the case. Services providers block users from different countries, and governments block entire sections of the Internet. Break out of corporate and government firewalls and Unlock geo-restricted content.

* Leave No Trace
Leave no digital footprints behind. Our desktop apps and browser extensions
work together to reduce your exposure to tracking and surveillance. 

* Share Privacy with Others
Use next time you send anyone a link to anything and show how much tracking is actually happening on most websites.
It combines a full VPN that will encrypt all of your communications with browser-based anti-tracking tools, and ad-blocker, and more (like secure link generators and a firewall, neither of which you’ll probably use, or really need, but they’re there.) The service is freemium, and allows you a single connection on a single device, 10GB of data transfer, and your choice of nine exit server countries before you’ll have to upgrade to Windscribe Pro which unlocks all of those limitations.
Best of all, the service does work like any VPN, and it doesn’t block specific protocols or destinations, so you can use it freely to either get around location restricted content, secure yourself on public or untrusted Wi-Fi networks, or share files securely. There are desktop versions of the app for Windows and macOS (pro users get access to OpenVPN configs for Linux), mobile versions for iOS and Android (only pro users get the Android app), and browser-based privacy tools for Chrome and Firefox (and a package for Opera.) Hit the link below to learn more.


YouTube Video

1-10 of 31