Login Sign Up

Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python

Via Udemy

Udemy based on 6,906 ratings

Share

0

Overview

Begin data analytics by learning Excel, SQL, Python, Analytics & ML concepts from scratch. Must-know for a data analyst. What you'll learn: A Beginner's Guide to Microsoft Excel - Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, MacrosBecome proficient in Excel data tools like Sorting, Filtering, Data validations and Data importingMaster Excel's most popular lookup functions such as Vlookup, Hlookup, Index and MatchMake great presentations using Bar charts, Scatter Plots, Histograms etc.Knowledge of all the essential SQL commandsBecome proficient in...

Syllabus

  • Introduction
  • Excel Basics
  • Essential Formulas
  • XLookup - only for Excel 2021 and Office 365
  • Data Tools
  • Excel Charts
  • Pivot table and Pivot charts
  • NEW! Analyze Data option in Excel - only for Microsoft 365 users
  • Maps Chart - only for Excel 2019 and above
  • Macros


Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python
Go to Class

via Udemy

22 hours 55 minutes

Certificate Available

English

On-Demand

Beginner

Instructor

Start-Tech Academy

Reviews

No reviews yet. Be the first to review!