Posts

Showing posts from May, 2023

How to Sort Google Sheets Automatically with Apps Script

Image
This Google Spreadsheet on Udemy courses has about 50 sheets, one for each programming language, and the sheets are sorted in random order so it is difficult to find a specific sheet. It will take a while to sort the worksheets manually but we can easily automate the process with Google Apps Script and easily navigate through large spreadsheets. Automate Sheet Sorting with Google Apps Script The following code snippet will automatically sort the worksheets in a Google Sheet alphanumerically. The script can arrange the sheets in either ascending or descending order based on the sheet names. To get started, go to Extensions > Apps Script to open the script editor. Then, copy and paste the following code: const sortGoogleSheets = ( ascending = true ) => { const options = { sensitivity : 'base' , ignorePunctuation : true , numeric : true , } ; const compareFn = ( sheet1 , sheet2 ) => { return ascending ? s...

Essential Mac Apps and Utilities - 2023 Edition

Image
Whether you’re new to using a Mac or an experienced Mac user looking to take your productivity to the next level, you’ll find something new and useful in our collection of the must-have Mac Apps of 2023. Most of these apps are free and cater to general Mac users, not just the geek crowd. The Best  Mac Apps & Utilities This collection of essential Mac Apps includes mostly lesser-known apps so the popular ones — like Evernote, 1Password, Dropbox, Skype, OneNote, or Google Drive — aren’t listed here. Also, all the apps here are compatible with Big Sur and Catalina, the current versions of macOS. Wherever possible, I have included the Mac App Store links because the store not only makes it easy for you to install apps on your Mac but, in the case of paid apps, you also have an option for requesting refunds . Let’s get started. Raycast - A powerful Spotlight replacement for your Mac that lets you quickly search and launch apps, search the web, and more. You can also create c...

Find Free Udemy Courses with Google Sheets and the Udemy API

Image
Whether you are looking to learn a programming language , enhance your Microsoft Excel skills, or acquire knowledge in Machine Learning, Udemy probably has a video course for you. Udemy courses are usually affordable, there are no subscription fee and you can learn at your own pace. Free Udemy Courses on Programming While most video tutorials on Udemy require payment, the website also offers some of their highly-rated courses for free. I’ve prepared a Google Sheet that lists all the free programming courses currently available on Udemy. The spreadsheet is updated automatically every few hours. You can also access the web version for easy browsing. ✨ You may use the search function of the browser (Ctrl + F) to find courses for a specific programming language or topic. The courses are sorted by popularity. There’s no secret sauce. Udemy has an developer API that provides access to all the course data available on the website, including user ratings, number of students who hav...