By Mariel Aim | in Online Courses
>All the work you're doing in a repetitive manner in Google Sheets or Excel could be automated. It requires no coding skills, add-ons, or special tools - all you need to know is how to execute advanced formula combinations that will do all the automation for you. This course focuses on teaching you the right skill set, so you could solve any business modeling task you might ever experience. You will learn the key formulas, practice them, build a complex but rewarding project, and then try to solve the challenges on your own. The course is designed to give you advanced-level skills that you will feel comfortable executing later in your own work.
Important Details
Requirements
By Laurence Svekis | in Online Courses
This course will help you build your own Dynamic and interactive quiz that uses only Google Sheet data to output the contents of the quiz, and JavaScript on your web page or website. You will be amazed at what you can do with just a few lines of code and how easy it is to connect Google Sheets to your website. This is a great solution to avoid backend code using only Google Script which is essentially JavaScript with a bunch of methods in the cloud.
Important Details
Requirements
By Grant Klimaytys | in Online Courses
Have you ever wondered how much time you waste doing these things manually? The truth is many people spend too much time clicking, typing, and editing. A massive waste of time on repetitive tasks! This course will show you the main shortcuts you'll use every single day in Google Sheets. It's an online spreadsheet offered by Google as part of their GSuite. If you write or edit 1 spreadsheet each day, then you could save 45 minutes every day. That comes out to 5 working weeks every single year! Go fast now with Google Sheets.
Important Details
Requirements
By Bryan Hong | in Online Courses
If you want to get better at Microsoft SQL so you get a better paying job or just get answers and insights from your data fast, then you are in the right place! With 15 lectures, this course will cover the must-know SQL queries and features. From simple table queries up to writing subqueries. After this class, you will be able to get valuable data insights anytime from your raw data.
Important Details
Requirements
By Bryan Hong | in Online Courses
If you learn only 5 Excel keyboard shortcuts and apply them each day, you will save hours each week, which means you can go home or log off early for once! In this course, there are several modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes, and a list of all 50 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep. From formatting to UI shortcuts, this course got it covered.
Important Details
Requirements
By Bryan Hong | in Online Courses
The course covers all of Excel's must-know features for importing, cleaning up, and transforming messy data that gets downloaded from an external data source or an Excel file. No matter if you are a beginner or an advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel. In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals, and get noticed by top management & prospective employers!
Important Details
Requirements
By Bryan Hong | in Online Courses
Last time you opened an Excel Power BI Dashboard and are overwhelmed by the number of things to do. You don't know how to make the best use of your time. But it doesn't have to be this way! This 1-hour course will help you understand how BI works and how to use it to your advantage for processing data and creating reports. Whether it's for business or personal related projects, this course will help anyone use Bi freely and easily.
Important Details
Requirements
By Bryan Hong | in Online Courses
If you're already familiar with the basics of Power Query, it's now time to advance to Data Cleansing. This 1-hour course will teach you data cleansing techniques using various Excel features. You will learn the structure of the M code, how to create your own formulas, and see them in action with real examples.
Important Details
Requirements
By Bryan Hong | in Online Courses
Creating a report from raw data and putting it into charts should not be a troublesome task. At least, not anymore with this 1-hour course. With 26 lectures, this course will discuss basic to advanced charts. From your common line chart up to trendlines and waterfall chart. Start making insightful reports and visuals with Excel now!
Important Details
Requirements
By Bryan Hong | in Online Courses
If you're working with a lot of data, going manual to calculate them one by one is probably not a good idea. That is why Microsoft Excel is packed with formulas. It allows you to design better spreadsheets — sort, calculate, format, group, and visualize data. This then results in more efficient data translation, less complexity, and reduced errors. This course will help you master the top 50 formulas you can use in Excel so you can 'play along' with data.
Important Details
Requirements
By Yoda Learning | in Online Courses
If you're dealing with a bunch of data, sorting, and organizing will help you a lot. This course will teach you how to use Google Sheets and organize your information into neat spreadsheets. You can use many of these skills in Excel too. Some of the topics that will be discussed here are as follow: working with Google Sheet's checkbox, sparklines for Dashboards, using slicer on a table, add pop-up calendar date picker, coloring raws based on a cell value, and more.
Important Details
Requirements