Data Analyst Training: Data Analysis with SQL & Microsoft Excel For Business Analysis

Academy for Health & Fitness

Reed courses certificate of completion

Digital certificate - Included

CPD Accredited Digital Certificate

Digital certificate - £12.99

CPD Accredited Hard Copy Certificate

Hard copy certificate - £29

Diploma in Data Analysis at QLS Level 5

Hard copy certificate - £119

Assessment

Included in course price

• Course 01 - Data Analysis: Modifying a Worksheet 25:59

  • 1: Insert, Delete, and Adjust Cells, Columns, and Rows Preview 10:08
  • 2: Search for and Replace Data 08:38
  • 3: Use Proofing and Research Tools 07:13

• Module 02: Working with Lists 37:47

  • 4: Sort Data 10:03
  • 5: Filter Data 09:49
  • 6: Query Data with Database Functions 09:02
  • 7: Outline and Subtotal Data 08:53

• Module 03: Analyzing Data 12:33

  • 8: Apply Intermediate Conditional Formatting 06:50
  • 9: Apply Advanced Conditional Formatting 05:43

• Module 04: Visualizing Data with Charts 38:03

  • 10: Create Charts 13:18
  • 11: Modify and Format Charts 12:16
  • 12: Use Advanced Chart Features 12:29

• Module 05: Using PivotTables and PivotCharts 44:25

  • 13: Create a PivotTable 13:28
  • 14: Analyze PivotTable Data 12:00
  • 15: Present Data with PivotCharts 07:35
  • 16: Filter Data by Using Timelines and Slicers 11:22

• Module 06: Working with Multiple Worksheets and Workbooks 24:00

  • 17: Use Links and External References 12:24
  • 18: Use 3-D References 05:51
  • 19: Consolidate Data 05:45

• Module 07: Using Lookup Functions and Formula Auditing 30:28

  • 20: Use Lookup Functions 12:45
  • 21: Trace Cells 09:05
  • 22: Watch and Evaluate Formulas 08:38

• Module 08: Automating Workbook Functionality 35:27

  • 23: Apply Data Validation 13:28
  • 24: Search for Invalid Data and Formulas with Errors 04:06
  • 25: Work with Macros 17:53

• Module 09: Creating Sparklines and Mapping Data 07:19

  • 26: MapData 07:19

• Module 10: Forecasting Data 27:54

  • 27: Determine Potential Outcomes Using Data Tables 08:47
  • 28: Determine Potential Outcomes Using Scenarios 09:16
  • 29: Use the Goal Seek Feature 04:16
  • 30: Forecasting Data Trends 05:35

• Course 02 - Diploma in Retail and Data Analytics at QLS Level 5 32:03

  • 31: Introduction to Retail Analytics Preview 32:03

• Module 02: Retail Psychology 07:06

  • 32: Retail Psychology 07:06

• Module 03: Retail and Data Analytics 12:00

  • 33: Retail and Data Analytics 12:00

• Module 04: Benefits of Retail Analytics 16:26

  • 34: Benefits of Retail Analytics 16:26

• Module 05: Retail Strategy 09:44

  • 35: Retail Strategy 09:44

• Module 06: Retail Buying and Merchandising 11:27

  • 36: Retail Buying and Merchandising 11:27

• Module 07: Forecasting 23:27

  • 37: Forecasting 23:27

• Module 08: Retail Pricing 16:30

  • 38: Retail Pricing 16:30

• Module 09: Analytics Software 19:37

  • 39: Analytics Software 19:37

• Module 10: Supply Chain Management in Retailing 07:37

  • 40: Supply Chain Management in Retailing 07:37

• Module 11: The Sales Process and Dealing with Customers at the Checkout 04:57

  • 41: The Sales Process and Dealing with Customers at the Checkout 04:57

• Module 12: Selling in Multiple Channels 12:40

  • 42: Selling in Multiple Channels 12:40

• Module 13: Taking Trends and Targeting Customers Effectively 05:38

  • 43: Taking Trends and Targeting Customers Effectively 05:38

• Assessment (Optional) 12:00

  • 44: MCQ Question 12:00

• Order Your Certificate 02:00

  • 45: Order Your CPD Certificate 01:00
  • 46: Order Your QLS Endorsed Certificate 01:00

• Final Words 01:00

  • 47: Leave a Review 01:00

Start your learning journey straight away with this Data Analyst (Data Analytics) course and take a step toward a brighter future!

Why Prefer This Data Analyst (Data Analytics) Course?

• FREE certificate on Data Analyst (Data Analytics) accredited by CPDQS
• Get instant access to this Data Analyst (Data Analytics) course.
• Learn Data Analyst (Data Analytics) from anywhere in the world
• Data Analyst (Data Analytics) is affordable and simple to understand
• Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio
• Lifetime Access to the Data Analyst (Data Analytics) course materials
• Data Analyst (Data Analytics) comes with Data Analysis

Assessment Process of Data Analyst (Data Analytics) QLS Course:

• Assignment & MCQ Based
• 60% Marks to pass
• Instant Assessment

Certificate of Data Analyst

• QLS Endorsed Certificate (additional cost)
• CPD Approved Certificate

Data Analyst (Data Analytics) Training

This course is for people who want to quickly and easily learn about Data Analyst (Data Analytics).

Data Analyst (Data Analytics) Training

You will not need any prior background or expertise to enrol in this Data Analyst (Data Analytics) course.

• Data Analyst: £25,000 - £50,000
• Junior Data Scientist: £30,000 - £60,000
• Senior Data Analyst/Scientist: £50,000 - £100,000
• Data Analytics Manager: £60,000 - £120,000

Currently there are no Q&As for this course. Be the first to ask a question.