Excel Essentials for Analytics (A Concise Introduction) | Free Udemy Course
Excel for Analytics - Free Course | Free Udemy Course
new- 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
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
JOIN WHATSAPPJOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON
JOIN TELEGRAMJOIN OUR FACEBOOK GROUP TO GET LATEST COUPON
JOIN FACEBOOKFree Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
Try itURL Decoder
Input an encoded string of text or a URL and decode the entered string
Try itColor Contrast Checker (WCAG)
Calculate the color contrast ration for your website (WCAG)
Try itXML Formatter
Paste or upload an XML and have it formatted to a beautiful XML format
Try itURL Slug Generator
Convert any title or sentence into a variety of slugs for your pages URL
Try itE-Signature
Draw an e-signature or type a signature for your online signature
Try it