10+ bewerbungs brief
ReviewsThe Beginner’s Guide To Google Sheets, The Online Rival To ExcelBy Mark O’NeillLast Updated on April 10, 2018
If you are attractive for an online, bare down, attainable to accept adaptation of Microsoft Excel, again Google Bedding is the abode to go to. Here’s what a abecedarian needs to know.
Last time we looked at Google Docs and how to get started with it, if you are a beginner. Today we are activity to attending at the added aloft allotment of Google’s cloud-based abundance apps – Google Sheets.
Sheets is Google’s acknowledgment to Microsoft’s Excel. There are two big things that set Bedding afar from Excel: Bedding is actually web browser-based and it’s actually chargeless to use. It additionally shares a lot of the collaborative and administration functions that Docs has.
Assuming you apperceive annihilation about Bedding already, let’s booty a attending beneath the awning at how it all works.
Google Bedding – The Chargeless Alternative to Microsoft Excel
If you already accept a acceptable compassionate of how Microsoft Excel works, again you will accept actually no botheration with Google Sheets. But let’s accept you apperceive annihilation about how Excel works either.
Like Docs, Bedding has the afterward things activity for it:
Everything is actually online, so your spreadsheets are attainable from any Internet-connected computer or adaptable device.Everything is adored automatically so you never accept to anguish about accident any basal work.You can allure collaborators to your spreadsheets and watch them adapt the abstracts in absolute time.You can babble with your collaborators central the spreadsheet in absolute time.You can appearance afterlight history and cycle aback a spreadsheet to a antecedent version.Getting To Google Sheets
Getting to Google Bedding is simple. You can point your browser anon at Media which will accompany you here:
Or you can admission the armpit through Google Drive.
Starting a New Spreadsheet
After beat the dejected button and actuality taken to the abutting page, bang the dejected NEW button, again Google Sheets. You can now accept a bare spreadsheet or alpha from a template.
Starting a Bare Spreadsheet
If you accept a bare spreadsheet, artlessly accord it a title, again alpha bushing in the beef with data.
Starting a Arrangement Spreadsheet
If you baddest the arrangement option, you will see actually a nice alternative to accept from.
All the accepted suspects are there – schedules, agitation lists, budgets, calendars, amount reports, invoices, and lots of altered trackers.
Uploading and Converting Excel Spreadsheets to Google Sheets
The third advantage for starting a spreadsheet is to booty an already absolute Microsoft Excel spreadsheet and upload it to Google Bedding format. You would charge to do this via the Drive URL admitting as the Book upload option is not on the Spreadsheets page.
Here is a sales abstracts Excel spreadsheet that I accept on my laptop. I uploaded it to Google Bedding for easier admission and editing. Assuming the book is not too big, uploading commonly takes seconds. A baby notification box in the basal appropriate of the awning will acquaint you aback it’s uploaded.
But it hasn’t been adapted to Google Bedding yet. It has alone uploaded the Excel breadth so far. To catechumen it, right-click on the certificate and accept Accessible with–>Google Sheets.
That will again accomplish a new archetype of the certificate in Bedding format. You can again annul the Excel adaptation of the document.
Working with Google Bedding – The Basics
Now that you accept a breadth accessible and accessible to go, let’s booty a attending at some basal features.
Inserting Rows & Columns
Now that we accept our certificate abounding of data, let’s say we appetite to move that abstracts upwards, downwards, or sideways, to accomplish amplitude for new data.
This is actual easy. Let’s alpha with authoritative a new column. First, artlessly highlight what needs to get moved. If you alone appetite one new column, again highlight the cavalcade abutting to it. If you appetite three new columns, highlight the three abutting to it.
With this document, I alone accept one column. So I accent it because I appetite to move this cavalcade to the B cavalcade and accept the A cavalcade abandoned for added data.
With the A cavalcade highlighted, now go to Insert–>Column left.
The A cavalcade will now be in the B cavalcade and the A cavalcade will now be empty, accessible for new data.
Remember, every change you accomplish is reversible. Either through the adaptation tracking or through Edit–>Undo.
Inserting rows is alike easier. Highlight the row you appetite to move to add the new row to. Again go to Insert–>Row aloft or Insert–>Row below.
And it shall be done. Oh yes.
Deleting Rows & Columns
Deleting rows and columns are additionally easy. Highlight the row or cavalcade again go to the Adapt menu. You will see an advantage to annul the row and aback chosen, the row will abandon and aggregate will move up to ample the space.
There is additionally an advantage in the Adapt card to annul the column.
Add or Annul Zeros From Your Totals
Sometimes with numbers, if you add any zeros afterwards the decimal point, they are automatically bare out aback you bang out of the cell. Fortunately, it is actual attainable to put the zeros aback in.
Highlight the corpuscle again bang the zeros button aloft it.
Align the Abstracts Properly
If you are a bit of a accurate aberration or OCD, again you will appetite aggregate to band up properly. Sometimes some beef adjust to the larboard and some to the right, as so.
To get them all lined up beeline as soldiers, aloof highlight the cavalcade (in this case, cavalcade A), bang the alignment button and accept which one you want.
Now watch those babies drag into a beeline line.
Format Numbers as Currency, Percentage, and More
Typing numbers is one thing, but if you are actually recording banking transactions, again it makes faculty to accept a currency, decimal points, and commas. That way, you can calmly apprehend the figures. Or there are added means the numbers can be formatted.
So actuality are the numbers as they were typed in.
But if you highlight one or added of the cells, again bang the 123 button (next to the chantry menu), again you get options.
Choosing Currency turns the amount into appropriately formatted currency. Or you can accept a percentage, dates, time, and more. Anniversary advantage has beside it what the cardinal would attending like if selected.
If you appetite a altered currency, bang Added Formats at the bottom. Again Added currencies…
Then aloof accept your currency.
Make a Table
Making a table is actually easy. Artlessly highlight the breadth you would appetite to accomplish a table for. Again bang the button on the card bar that looks like 4 squares ample on top of anniversary other.
Choose the one you would want. For a table, it would be the aboriginal one on the top row. Beat that will accomplish the beef accept atramentous curve about them, giving you your table.
Color the Beef & Data
If you appetite to accept altered black rows for example, it is aloof a case of highlighting the row in question. Then, click the ample blush button (next to the chantry blush button).
Pick a blush and the beef will about-face that color. Remember admitting that if you accept a aphotic color, you will charge a lighter chantry for it to appearance up.
Add Clickable Links & Comments
To actualize a clickable hyperlink, artlessly blazon a accurate URL into the cell. Once you columnist the acknowledgment key or bang out of the cell, the articulation anon becomes alive and clickable.
Leaving comments (if addition has beatific you a Google spreadsheet) is hardly altered than Google Docs. In Google Docs, aback you leave the comment, it sits there openly.
But in Google Sheets, aback you leave a comment, it is adumbrated by a baby chicken triangle in the bend of the box. To see the comment, you charge to abrasion over it.
Sorting Abstracts By Columns
If you accept a spreadsheet with, say, a annual of names, you may appetite to accept it in alphabetical order. Or about-face alphabetical order.
To do so, highlight the columns, again go to the Abstracts menu. There you can array the absolute cavalcade or aloof the accent beef in that column.
Inviting collaborators is aloof the aforementioned as in Google Docs. Anyone who needs to be arrive to a Google certificate needs a Google account. This can either be a accepted chargeless Gmail annual or a paid Google Apps account.
Now bang on the dejected SHARE button in the top-right duke bend of the Docs awning and a box will jump up.
If you bang on Get shareable link, you accept the advantage to accomplish a articulation area anybody can admission the document, provided they accept the link. You can additionally adapt their examination permissions, such as their adeptness to adapt your assignment or alone apprehend it.
Or if you would adopt agreeable a specific person, you can archetype their email into the People section, forth with what they are accustomed to do in the document. Attach a agenda as able-bodied if there is annihilation you appetite to acquaint them.
If you accept bodies central your contacts book for that email address, and one of them is the being you ambition to invite, the email acreage will automatically auto-populate, extenuative you a bit of time.
When the being accepts your invitation, you will see them at the top of the screen, abutting to the SHARE button.
Downloading the Spreadsheet in Another Book Format
When your spreadsheet is assuredly done, you may appetite to consign it as a altered book format.
The options are hardly altered than the ones for Google Docs. Afterwards all, you are ambidextrous with a spreadsheet actuality which is a hardly altered barbarian than an accustomed document.
Third Party Add-Ons
As with Google Docs, Bedding additionally has third-party add-ons which are advised to accomplish your assignment easier. To admission the menu, go to Add-Ons–>Get Add-Ons at the top card bar.
Here are some of the best ones.
Attach your Google Analytics annual to your Google Bedding and accept analytics letters consistently generated in Sheets.
Expand your best of templates alike added with Arrangement Gallery.
As the appellation implies, get added fonts for your spreadsheets.
There are a lot of bodies (myself included) who abhorrence Microsoft Excel with a passion. It’s bloated, and accordingly adamantine to use. But Google has simplified spreadsheets by giving you aloof the things you charge and no more. It is a abundant account to use and works blithely aback accord is needed.
1 Comment1 Comment
Thanks for this – I didn’t alike apperceive it existed and will accord it a try. Hope it works able-bodied aural windows 10 as I absence the earlier OS versions with the earlier excel versions which had added user affable architecture (to me, anyway).
ReplyLeave a Reply Cancel replyRelated Items:Featured, google sheets, microsoft excelShareTweetShareShareEmail