October 20, 2015
In today’s post, nosotros are introducing you lot to a collection of of import add-ons to work on your Google Sheets to exercise smarter spreadsheets amongst beautiful designs together with to a greater extent than sophisticated functionalities. Using these extensions volition enable you lot to add together dissimilar styles together with fonts to your spreadsheets; take duplicate values betwixt 2 tables or inward ane sheet; detect together with build clean upward data; divide names to several columns, search inward values, formulas, notes together with hyperlinks inward all sheets at once; easily generate Gantter schedules from your sheets; add together reminders to your sheets; smart autofilling of information into other columns based on the values of the other columns, together with many more.
1- Styles
'This plus volition brand adding beauty to your spreadsheet a breeze. It's hence slow to use, all you lot demand to exercise is select a few cells you lot desire to fashion together with hence click ane of the styles inward the Style viewer sidebar.'
2- More Fonts
'Follow five uncomplicated steps to detect duplicate or unique values betwixt 2 tables or inward ane sheet. This plus comes amongst 2 useful wizards. One volition assistance you lot compare 2 dissimilar tables or columns together with take duplicates; the other volition search for unique together with duplicate rows inside ane sheet. '
4- Power Tools 
'One-click solutions for daily tasks: divide cells, take duplicates, alter case, detect together with build clean upward data, piece of work amongst formulas & more. Power Tools plus cuts the clicks on repeated tasks together with brings features for organizing together with unifying information inward Google Sheets. '
5- Split Names 
'Smart Autofill plus uses Machine Learning via the Google Prediction API to fill upward missing values inward a column of data, based on other information inward the column together with the information inward following columns. It volition await for patterns inward the rows of information where at that spot are values introduce inward the column, together with apply them to fill upward inward the missing values of the column.'
In today’s post, nosotros are introducing you lot to a collection of of import add-ons to work on your Google Sheets to exercise smarter spreadsheets amongst beautiful designs together with to a greater extent than sophisticated functionalities. Using these extensions volition enable you lot to add together dissimilar styles together with fonts to your spreadsheets; take duplicate values betwixt 2 tables or inward ane sheet; detect together with build clean upward data; divide names to several columns, search inward values, formulas, notes together with hyperlinks inward all sheets at once; easily generate Gantter schedules from your sheets; add together reminders to your sheets; smart autofilling of information into other columns based on the values of the other columns, together with many more.
1- Styles
'This plus volition brand adding beauty to your spreadsheet a breeze. It's hence slow to use, all you lot demand to exercise is select a few cells you lot desire to fashion together with hence click ane of the styles inward the Style viewer sidebar.'
2- More Fonts
'More fonts plant precisely similar the default fonts inward your spreadsheet. After selecting about cells to format, only click More Fonts inward the plus bill of fare together with select a font. If you lot desire to select from fifty-fifty to a greater extent than fonts together with run across what they await like, all you lot demand to exercise is select Show More Fonts inward the menu. This volition opened upward the spreadsheet sidebar where you lot tin forcefulness out run across the total listing of fonts formatted inward their ain style. '
3- Remove Duplicates
3- Remove Duplicates
'Follow five uncomplicated steps to detect duplicate or unique values betwixt 2 tables or inward ane sheet. This plus comes amongst 2 useful wizards. One volition assistance you lot compare 2 dissimilar tables or columns together with take duplicates; the other volition search for unique together with duplicate rows inside ane sheet. '
4- Power Tools
'One-click solutions for daily tasks: divide cells, take duplicates, alter case, detect together with build clean upward data, piece of work amongst formulas & more. Power Tools plus cuts the clicks on repeated tasks together with brings features for organizing together with unifying information inward Google Sheets. '
5- Split Names
'Enable this plus for your sheets if you lot e'er demand to lead get-go together with final names inward dissimilar columns. You tin forcefulness out consummate this task inward a click: select the cite parts you lot demand together with click "Split" to lead them pulled out to separate cells. That's it!'
'This plus allows you lot to rapidly generate Gantter™ schedules from Google Sheets. With ane click, you lot tin forcefulness out highlight a listing of tasks inward Sheets to exercise a Gantter™ schedule or work a template to exercise a to a greater extent than robust schedule amongst start date, goal date, resource, together with notes! Once your Gantter™ schedule is created you lot tin forcefulness out work Gantter for Google Drive™ to opened upward together with relieve your files straight from Drive together with work all the ability of Gantter™ to educate gantt charts, assign resources, rail toll together with completion for all your projection tasks.'
7- Add Reminders
7- Add Reminders
'This spreadsheet tin forcefulness out hold upward a uncomplicated personal task listing or a project-management interface that requires team-wide coordination. Add Reminders lets you lot have e-mail reminders earlier dates inward a specific column of your spreadsheet are reached.'
Buat lebih berguna, kongsi:
