The Programming Buddy Club Logo
The Programming Buddy Club
Search
Excel Essentials for Analytics (A Concise Introduction) | Free Udemy Course
Scroll Down to get the courseGet The Course

Excel Essentials for Analytics (A Concise Introduction) | Free Udemy Course

Free Free100% off
New Free Udemy Course

Excel for Analytics - Free Course | Free Udemy Course

new
4.2
(9 ratings)
1408 students
Created by:
Julio Hernan Losada Perez
Course Language EnglishCourse Caption English [Auto]Course Length 01:49:53 to be exact 6593 seconds!Number of Lectures 23
This course includes:
  • 2 hours hours of on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • 18 additional resources

My name is Julio Losada. I have postgraduate studies in Mathematics, Economics and Computer Science. For the past nine years I have worked in analytics across the Banking and FMCG industries.Over this time, I have helped very busy colleges acquire essential Excel skills by keeping demonstrations simple and to the point. With this experience, I have identified the most commonly used Excel functionality applied in Analytics and created this course.Excel Essential for Analytics (A Concise Introduction) is primarily geared towards graduates or busy professionals moving into an analytics role and needing to very quickly acquire relevant Excel skills.The course centres around six key learning areas being: Handy cell functions, analytical functions, macros, pivot tables and Excel for SQL. Sub topics are listed below.· Input data o CSV o Text Files o SQL databases· Handy cell functions o SUMIF / COUNTIF o VLOOKUP o HLOOKUP o LEFT / MID / RIGHT o Index & Match o IFERROR o IFNA o Sort o Transpose o Text to Columns o Unique records o Search & Replace o Conditional Formatting o Analytical Functions o Linear Regression o Multiple Linear Regression o Test & Control Studies (Hypothesis Testing)· Automation with Macros· Pivot Tables· Excel for SQL codingNo previous Excel experience is necessary.The only requirement is access to a computer with the Windows Excel program, preferably the 2016 version (or later).Who this course is for:This course was designed for the busy professional or graduate entering the analytics profession.The course includes demostrations on the most commonly used Excel features used in analytics.Demostrations are concise and effective in order to save time.

Course Content:

Sections are minimized for better readability, click the section title to view the course content

1 Lectures | 00:46
3 Lectures | 07:18
13 Lectures | 57:56
3 Lectures | 22:29
1 Lectures | 06:36
1 Lectures | 07:16
1 Lectures | 07:32
4.2
(9 course ratings)
1
0/9
2
0/9
3
2/9
4
4/9
5
3/9

JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED

JOIN WHATSAPP

JOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON

JOIN TELEGRAM

JOIN OUR FACEBOOK GROUP TO GET LATEST COUPON

JOIN FACEBOOK
Get The Course
If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.

Free Online Tools And Converters for your use

URL Encoder

Input a string of text or a URL and encode the entered string

Try it

URL Decoder

Input an encoded string of text or a URL and decode the entered string

Try it

Color Contrast Checker (WCAG)

Calculate the color contrast ration for your website (WCAG)

Try it

XML Formatter

Paste or upload an XML and have it formatted to a beautiful XML format

Try it

URL Slug Generator

Convert any title or sentence into a variety of slugs for your pages URL

Try it

E-Signature

Draw an e-signature or type a signature for your online signature

Try it

FAQ: Udemy Free course Most frequent questions and answers

Does Udemy offer Free Udemy coupons?

Yes, Udemy is the largest online education platform, with the broadest selection of video-on-demand courses and qualified instructors available to meet your needs. At theprogrammingbuddy.club we curate the latest udemy coupons, their expiry, and the number of uses left of these udemy coupons.

How to get free Udemy courses?

There are two ways to get free Udemy courses:

  1. Go to udemy.com and search for your desired course category. Then select free from the filter options.
  2. You can also get paid courses for free if you have a coupon. You can head to theprogrammingbuddy.club, where you can get a daily udemy paid course for free.

How to get Udemy Certificates for free?

Udemy offers certification on completion of each course. In order to receive a certificate of completion from Udemy, you need to complete your course 100%. There is a simple hack, you can open a video and jump on the timeline to complete a lecture.

To download the certificate from Udemy, you need to head over to your account on a desktop browser. Udemy certificates can't be accessed on the mobile app.

Do Udemy courses expire?

No, once you enroll, you will have lifetime access to the course. You can complete the course on your schedule.

Why are the Udemy instructors giving away free Udemy Coupons?

Every instructor has worked for hours on each of their courses. As new courses get launched, the instructors have no way to get their course in front of an audience to get some feedback. So, instructors share free coupons for their courses to get feedback from the students. We attheprogrammingbuddy.club work with these instructors to get their courses available to our buddies.

Is Udemy safe to use?

Yes, payments on Udemy are safe. It is no different than paying for other services on an application or website and inputting your payment information before receiving your goods. Just be sure to keep your account secure, do not share your udemy accounts.

Can Udemy courses get you a job?

Earning a skill is more valuable than earning a job these days. Skills are your most valuable asset. They can help you qualify for jobs you want and get promoted to more advanced positions within your organization. Unfortunately, it is difficult for many people to balance taking courses with work and family obligations. We have had many students, who have taken just Udemy courses, started a job as well as started freelancing with the skills they have learned.