Пікірлер
@SergioVillanueva-k2p
@SergioVillanueva-k2p 9 күн бұрын
share the sheet!
@marinameeker4481
@marinameeker4481 14 күн бұрын
Great information and I love your sense of humor. The only thing I would suggest to you is that adjectives are not pluralized. For example, it is a common mistake to say 'My 7 years-old child,' but this sounds wrong. Why? Because in this case, '7-years' is functioning as an adjective. It should always be, 'My 7 year-old child.' And when you write: 'lessons-packed, books editing,' the same rule applies. It is 'lesson-packed' and book editing.' But I really enjoy your video, please keep up the great work!
@sarahscribbles2774
@sarahscribbles2774 Ай бұрын
❤ thank you for summarizing all the boring content available online regarding editing. I applied for editor's job and attempted their test but didn't get an interview call back. This is why I'm polishing my editing knowledge. Thanks a bunch!
@NCN358
@NCN358 2 ай бұрын
Where is the list?
@MeredithSigmon
@MeredithSigmon 2 ай бұрын
Can you provide the code?
@BrightAkplobi
@BrightAkplobi 5 ай бұрын
Sir, the slide looks blurred.
@MariehetPrinsloo
@MariehetPrinsloo 5 ай бұрын
Thanks was very informative
@user-kq3xm5dt7c
@user-kq3xm5dt7c 6 ай бұрын
function track() ( Logger.log("Start processing sheet....") var ss SpreadsheetApp.getActive(): var range ss.getDataRange() // getting data range var rowend range.getLastRow(); // index of last row var columnEndrange.getLastColumn(); // index of last column for(var 13: 1 <= rowEnd; 1++) {//skip 2, ignore column titles Logger.log("Processing row: "1"/"+rowEnd); // getting values of all 4 columns var ups range.getCell(1, 1); // getting cell A. 1 represents rows and 1 represents column A var ups status range.getCell(1, 2); // getting cell 8. 1 represents row and 2 represents column B var fedex range.getCell(1, 3); // getting cell C. i represents rows and 3 represents column C var fedex status range.getCell(1, 4);// getting cell D. i represents rows and 4 represents column D // check if row has no tracking id then stop the process if(ups.getValue() ** && fedex.getValue()){ break; // check if UPS has tracking id with missing status then get the status and update if (ups.getValue() && ups_status.getValue().toLowerCase() != "delivered")( var url="wwwapps.ups.com/tracking/tracking.cgi?tracknum="+ups.getValue(): ups status.setFormula (IMPORTXML (+url+", "//*[@id=\"tt_spstatus\")"); // check if Fedex has tracking id with missing status then get the status and update if(fedex.getValue() && fedex_status.getValue().toLowerCase() != "delivered") var status fetchFedex(fedex.getValue()): fedex status.setValue(status): }
@austinc8176
@austinc8176 6 ай бұрын
Use your own voice. It couldn’t sound worse than this
@elizandromartim
@elizandromartim 6 ай бұрын
???? Code????
@ifebucheokogu1434
@ifebucheokogu1434 7 ай бұрын
Please where is the Part three video 😊 Thanks a lot ..this is quite informative 👍
@michaelcarp8431
@michaelcarp8431 7 ай бұрын
Can you describe the Est. Sales column - what is the time frame for this statistic? Are these quantities sold per day, per week, per month?
@rosybanerjee1884
@rosybanerjee1884 9 ай бұрын
Some company asked me to join as Junior document formatter and promised to pay 2.4 to 3 lakhs INR ( that's approximately $2883 to $3603) per year. But the task required recreation , formatting of raw documents along with proofreading too. Is this genuine offer or I am being duped . I have previously some experience with translation work but not any of this kind.
@kiritmoza
@kiritmoza 10 ай бұрын
Extraordinary.
@kiritmoza
@kiritmoza 10 ай бұрын
Very useful. Thanks
@untiground
@untiground 10 ай бұрын
what an idiot
@akinbiyiomowunmi3259
@akinbiyiomowunmi3259 11 ай бұрын
I am a beginner and I have found this lecture impactful. Thanks for taking your time to get this done. 23:45
@harleycynofficial
@harleycynofficial 11 ай бұрын
I love the humor you put into this. Makes it more fun to learn.
@KevinFrost
@KevinFrost 11 ай бұрын
Sad that barely a year later and this is already out of date, the sheet isn't shared and there's no update from CTL.
@arshadansari6296
@arshadansari6296 11 ай бұрын
To be an author, is difficult to understand it is God gifted One start it from his or her steen age or some times even earlier and by practice to become an author have lacking. MrNitay you proclaims to be an English but, it does not seems to be because your accent is not English
@jamsadiq8818
@jamsadiq8818 Жыл бұрын
Very informative and practicle channel to edit any kind of editing .Really ,i was in search of such kind of channel where i may lern how to prooofreaing of any kind.there are complete oppertunites to learn as professional proofreader..such kind
@aestheticaura573
@aestheticaura573 Жыл бұрын
good effort
@ololademary9188
@ololademary9188 Жыл бұрын
Thank you the tutorial was very helpful
@ranatahir4234
@ranatahir4234 Жыл бұрын
The course is quite helpful. Is there any comprehensive quiz at the end for any Certification?
@buddha2202
@buddha2202 Жыл бұрын
Hello? Can you give an update regarding this?
@svahora
@svahora Жыл бұрын
We need access to the sheet, its currently private - docs.google.com/spreadsheets/d/1SmEcTpM2PyXe-Y6CMGWOzD6hsv8EheckZnf5W5diLtk/edit
@exploreplore5648
@exploreplore5648 Жыл бұрын
Very Informative .Thanks bro
@sadiyaiddrisu3782
@sadiyaiddrisu3782 Жыл бұрын
Thanks so much I appreciate your handwork
@ohizubenita2548
@ohizubenita2548 Жыл бұрын
@ohizubenita2548
@ohizubenita2548 Жыл бұрын
Thanks a lot
@ohizubenita2548
@ohizubenita2548 Жыл бұрын
@aha-sh3wc
@aha-sh3wc Жыл бұрын
Don't I need to have red like billions of books? It is like being a writer?
@victoriaokoro4479
@victoriaokoro4479 Жыл бұрын
Thank you very much. I enjoyed the class. Please I have a question. Can one offer all the services at once? ( I mean all the types of editing)
@United_Wings
@United_Wings Жыл бұрын
Nice
@julletcoley756
@julletcoley756 Жыл бұрын
Thank you for this very helpful presentation. Looking forward to the next lesson.
@sarahm9723
@sarahm9723 Жыл бұрын
This is an excellent tutorial!!! Question. How do you get Hebrew side-by-side with the English? I'd love to have it that way too. (I'm learning Hebrew).
@achintsrivastava6006
@achintsrivastava6006 Жыл бұрын
where do i get full course? is it worth the time?
@LifestylebyJulia
@LifestylebyJulia Жыл бұрын
Thank you for the information!
@romanrollins6763
@romanrollins6763 Жыл бұрын
Has anyone taken this course and become a professional proofreader yet?
@ivanhomeroloyachitika8924
@ivanhomeroloyachitika8924 Жыл бұрын
where's the link to the google sheet?
@serenasupernatural9336
@serenasupernatural9336 Жыл бұрын
How do I set the page for proofreading and editing
@joshmorris3845
@joshmorris3845 2 жыл бұрын
kzbin.info/www/bejne/iaapmZuGo7Z-Zsk
@thegolfswingfeeling
@thegolfswingfeeling 2 жыл бұрын
Thank you for the video. Just what I needed.💪😁
@Virusisthetrue
@Virusisthetrue 2 жыл бұрын
Can you show us some functions like =sum(a1:a2) ?
@dinukakularathna2824
@dinukakularathna2824 2 жыл бұрын
Great video. Thank you!
@raynabarrette3106
@raynabarrette3106 2 жыл бұрын
Can you provide the link to download
@sensiblesydney5058
@sensiblesydney5058 2 жыл бұрын
Nice suggestions. At 10:35, we do not always agree when we nod in context. The term can refer to a greeting, confirmation that one understands, a code or signal, falling asleep, and so on. Also, verbs like "nodded" (which ends in "ed") do not usually appear at the end of a sentence. So "she gave the nod" (an intransitive verb) might be a better choice. However, an action word is often followed by an adverb or a preposition. Thanks!
@ineffable0ne
@ineffable0ne 2 жыл бұрын
17:34 Missing Relevant Info Example: "Somehow... Palpatine returned."
@Watchthisout
@Watchthisout 2 жыл бұрын
Where is the Google sheet ?? It is not listed anywhere on this video
@kaival
@kaival 2 жыл бұрын
when will part 3 be out?
@commit-to-learn
@commit-to-learn 2 жыл бұрын
kzbin.info/www/bejne/aWezY5KFhK2Drbc