Data Analyst: Data Analyst (Data Analytics) Diploma 10 in 1

Academy of Skills

Certificate of completion

Digital certificate - Included

Reed courses certificate of completion

Digital certificate - Included

• Excel Basics 1:30:05

  • 1: Excel Basics - 1 - Tour of the Excel screen 09:30
  • 2: Excel Basics - 2 - Entering Data 13:22
  • 3: Excel Basics - 3 - Autofill Speedfill 09:16
  • 4: Excel Basics - 4 - Saving the file 01:48
  • 5: Excel Basics - 5 - Autosum 04:29
  • 6: Excel Basics - 6 - formula basics 10:31
  • 7: Excel Basics - 7 - Copying formulas - Relative Formulas 04:29
  • 8: Excel Basics - 8 - Totals and Averages 03:52
  • 9: Excel Basics - 9 - Formatting the Spreadsheet 07:23
  • 10: Excel Basics - 10 - Managing the Sheets 06:17
  • 11: Excel Basics - 11 - Copying formulas - absolute formulas 07:37
  • 12: Excel Basics - 12 - Linking the Sheets together 06:05
  • 13: Excel Basics - 13 - Introduction to Functions 05:26

• Data Analysis 1:10:55

  • 14: excel data analysis - 1 03:49
  • 15: excel data analysis - 2 06:36
  • 16: excel data analysis - 3 03:24
  • 17: excel data analysis - 4 03:14
  • 18: excel data analysis - 5 10:53
  • 19: excel data analysis - 6 15:51
  • 20: excel data analysis - 7 02:00
  • 21: excel data analysis - 8 09:15
  • 22: excel data analysis - 9 15:53

• Important Excel Formulas and Functions 1:54:54

  • 23: Excel Must-Know Formulas and Functions - 1 - Building basic math formulas 08:19
  • 24: Excel Must-Know Formulas and Functions - 2 - Autosum and Relative references 09:21
  • 25: Excel Must-Know Formulas and Functions - 3 - Absolute references 06:20
  • 26: Excel Must-Know Formulas and Functions - 4 - Named Ranges 06:23
  • 27: Excel Must-Know Formulas and Functions - 5 - Linking sheets and workbooks 05:36
  • 28: Excel Must-Know Formulas and Functions - 6 - If, And, Or, and the nested If func 15:53
  • 29: Excel Must-Know Formulas and Functions - 7 - Countif, Sumif, Averageif, Sumifs, 09:15
  • 30: Excel Must-Know Formulas and Functions - 8 - Vlookup and Hlookup functions 15:19
  • 31: Excel Must-Know Formulas and Functions - 9 - Match and Index functions 07:27
  • 32: Excel Must-Know Formulas and Functions - 10 - Date and time formulas and functio 12:26
  • 33: Excel Must-Know Formulas and Functions - 11 - Text functions 10:55
  • 34: Excel Must-Know Formulas and Functions - 12 - Tracing formulas 07:40

• PowerQuery PowerPivot in detail 1:49:54

  • 35: pivot table power query power pivot - 1 09:05
  • 36: pivot table power query power pivot - 2 00:59
  • 37: pivot table power query power pivot - 3 02:10
  • 38: pivot table power query power pivot - 4 02:40
  • 39: pivot table power query power pivot - 5 01:03
  • 40: pivot table power query power pivot - 6 03:48
  • 41: pivot table power query power pivot - 7 08:05
  • 42: pivot table power query power pivot - 8 04:49
  • 43: pivot table power query power pivot - 9 02:31
  • 44: pivot table power query power pivot - 10 04:18
  • 45: pivot table power query power pivot - 11 03:52
  • 46: pivot table power query power pivot - 12 01:48
  • 47: pivot table power query power pivot - 13 03:29
  • 48: pivot table power query power pivot - 14 05:01
  • 49: pivot table power query power pivot - 15 01:56
  • 50: pivot table power query power pivot - 16 03:16
  • 51: pivot table power query power pivot - 17 03:17
  • 52: pivot table power query power pivot - 18 08:13
  • 53: pivot table power query power pivot - 19 02:02
  • 54: pivot table power query power pivot - 20 03:41
  • 55: pivot table power query power pivot - 21 04:47
  • 56: pivot table power query power pivot - 22 08:50
  • 57: pivot table power query power pivot - 23 04:04
  • 58: pivot table power query power pivot - 24 03:16
  • 59: pivot table power query power pivot - 25 03:45
  • 60: pivot table power query power pivot - 26 09:09

• Excel Vlookup in detail 46:47

  • 61: Excel vlookup 1.1 08:21
  • 62: Excel vlookup 1.3 08:12
  • 63: Excel vlookup 1.4 02:59
  • 64: Excel vlookup 1.5 10:56
  • 65: Excel vlookup 1.6 04:44
  • 66: Excel vlookup 1.7 05:26
  • 67: Excel xlookup 1.2 06:09

• Outlook Tips and Tricks 49:01

  • 68: outlook inbox tips - 1 - Basic sort 02:29
  • 69: outlook inbox tips - 2 - Handling Attachments 05:52
  • 70: outlook inbox tips - 3 - Advanced Sort 04:34
  • 71: outlook inbox tips - 4 - Conditonal Formatting 03:59
  • 72: outlook inbox tips - 5 - Filter and Advanced Filter 05:25
  • 73: outlook inbox tips - 6 - Categories 02:36
  • 74: outlook inbox tips - 7 - Flags and Reminders 04:58
  • 75: outlook inbox tips - 8 - Rules 08:09
  • 76: outlook inbox tips - 9 - Managing Junk Email 03:24
  • 77: outlook inbox tips - 10 - Managing Folders 03:10
  • 78: outlook inbox tips - 11 - Inbox Maintenance 04:25

• Access Databases - Tables and Queries 3:32:29

  • 79: Access Tables and Queries - 1 - Tour of the screen 10:56
  • 80: Access Tables and Queries - 2 - Using Design view to create and edit tables 45:16
  • 81: Access Tables and Queries - 3 - Using the lookup wizard 08:36
  • 82: Access Tables and Queries - 4 - Importing data from Other Data Sources into Acce 17:52
  • 83: Access Tables and Queries - 5 - Linking Tables from Other data Sources into Acce 10:15
  • 84: Access Tables and Queries - 6 - Exporting data from Access to other data types 02:44
  • 85: Access Tables and Queries - 7 - Creating and Managing Table Relationships 10:29
  • 86: Access Tables and Queries - 8 - Database Tools 04:33
  • 87: Access Tables and Queries - 9 - Sort and Filter a Table 05:32
  • 88: Access Tables and Queries - 10 - Basic Queries 22:29
  • 89: Access Tables and Queries - 11 - Prompting the user for the criteria 04:32
  • 90: Access Tables and Queries - 12 - Creating Calculated Fields in a Query 10:20
  • 91: Access Tables and Queries - 13 -Creating Totals Queries 07:43
  • 92: Access Tables and Queries - 14 - Multiple table Queries 11:59
  • 93: Access Tables and Queries - 15 - Viewing the SQL code for an Access Query 05:52
  • 94: Access Tables and Queries - 16 - Using the Query Wizards 09:00
  • 95: Access Tables and Queries - 17 - Creating Subqueries 03:24
  • 96: Access Tables and Queries - 18 - Creating Make Table, Append, Update and Delete 19:28
  • 97: Access Tables and Queries - 19 - Displaying a certain number of records 01:29

• Access Databases - Forms and Reports 2:50:36

  • 98: Access Forms and Reports - 1 - Autoforms 14:01
  • 99: Access Forms and Reports - 2 - Form Wizard 08:52
  • 100: Access Forms and Reports - 3 - Changing a form with design view 26:10
  • 101: Access Forms and Reports - 4 - Adding controls to your form 21:02
  • 102: Access Forms and Reports - 5 - Subforms 14:51
  • 103: Access Forms and Reports - 6 - Using Autoreport to create a report 03:20
  • 104: Access Forms and Reports - 7 - Using the Report Wizard to create a report 07:15
  • 105: Access Forms and Reports - 8 - Changing a report in design view 11:20
  • 106: Access Forms and Reports - 9 - Adding Calculations to your report 09:13
  • 107: Access Forms and Reports - 10 - Adding Groups, Sorts and Totals to reports 16:10
  • 108: Access Forms and Reports - 11 - Making labels with the Label Wizard 04:26
  • 109: Access Forms and Reports - 12 - Form and Report Properties 05:39
  • 110: Access Forms and Reports - 13 - Exporting a report to Excel 03:15
  • 111: Access Forms and Reports - 14 - Creating a menu with the Switchboard Manager 17:14
  • 112: Access Forms and Reports -15 - Finalizing the Application 07:48

• PowerBI Introduction 1:13:23

  • 113: PowerBi - 1 - Tour of the screen 03:50
  • 114: PowerBi - 2 - Pulling in your data from different sources 11:59
  • 115: PowerBi - 3 - Creating your first Visual 08:53
  • 116: PowerBi - 4 - Building a visual from 2 tables 07:46
  • 117: PowerBi - 5 - Slicers 07:00
  • 118: PowerBi - 6 - Making a Combo Chart Visual 05:47
  • 119: PowerBi - 7 - Using PowerQuery to restructure the data 03:38
  • 120: PowerBi - 8 - Creating Map Visuals 03:09
  • 121: PowerBi - 9 - Creating a report by Year, Qtr, or Month 03:41
  • 122: PowerBi - 10 - calculating % of total 01:48
  • 123: PowerBi - 11 - Creating your own Calculation 04:30
  • 124: PowerBi - 12 - Decomposition Tree Visual 02:11
  • 125: PowerBi - 13 - Pulling it all together 09:11

• PowerBI Formulas 1:25:42

  • 126: power pivot power query - 1 01:18
  • 127: power pivot power query - 2 02:10
  • 128: power pivot power query - 3 06:21
  • 129: power pivot power query - 4 07:11
  • 130: power pivot power query - 5 02:21
  • 131: power pivot power query - 6 05:18
  • 132: power pivot power query - 7 04:40
  • 133: power pivot power query - 8 03:44
  • 134: power pivot power query - 9 02:54
  • 135: power pivot power query - 10 01:48
  • 136: power pivot power query - 11 03:41
  • 137: power pivot power query - 12 07:48
  • 138: power pivot power query - 13 03:58
  • 139: power pivot power query - 14 02:44
  • 140: power pivot power query - 15 13:23
  • 141: power pivot power query - 16 03:27
  • 142: power pivot power query - 17 12:56

With the help and knowledge of industry specialists, this novel Data Analyst - Data Analyst Diploma course has been put together. Data Analyst - Data Analyst Diploma has been meticulously created to fulfill the learning needs that will enable you to make a significant contribution to the area and carve out a successful career path.

Data Analyst - Data Analyst Diploma course was created to help motivated students become the best in their personal and professional lives. Many students have already completed and enjoyed this Data Analyst - Data Analyst Diploma course. This Data Analyst - Data Analyst Diploma education gave them the tools they needed to advance to more gratifying and rewarding jobs. This one-of-a-kind Data Analyst - Data Analyst Diploma course is suitable for devoted and ambitious learners who want to be the best at their career or profession.

With the help and knowledge of industry leaders, the original Data Analyst - Data Analyst Diploma was created. This Data Analyst - Data Analyst Diploma has been meticulously created to suit all of the learning criteria for making a significant contribution to the associated subject and subsequent career path. By participating in this Data Analyst - Data Analyst Diploma course, the student will receive valuable knowledge and skills that will help them land their ideal career and establish a strong personal and professional reputation.

After enrolling in this Data Analyst - Data Analyst Diploma course, you may use our tutor's assistance to help you with any questions you may have, which you can send to our learner support staff through email. This Data Analyst - Data Analyst Diploma is one of our most popular online courses, created by professionals for the future-focused professional and designed to provide learners with the tools and frameworks they need to lead successfully in a fast changing environment.

Enroll in the Data Analyst - Data Analyst Diploma right now to advance your abilities.

Curriculum

Course Curriculum: Data Analyst - Data Analyst Diploma

Here is a curriculum breakdown of the Data Analyst - Data Analyst Diploma course:

Courses in this Data Analyst - Data Analyst Diploma Bundle are:

1. Excel Basics
2. Data Analysis
3. Important Excel Formulas and Functions
4. PowerQuery PowerPivot in detail
5. Excel Vlookup in detail
6. Outlook Tips and Tricks
7. Access Databases - Tables and Queries
8. Access Databases - Forms and Reports
9. PowerBI Introduction
10. PowerBI Formulas

Certificate

Learners can request a free PDF certificate of completion after successfully completing the Data Analyst - Data Analyst Diploma course. An additional fee may be charged for Data Analyst - Data Analyst Diploma Hardcopy Certificate and includes Free Shipping in the UK.

The Data Analyst - Data Analyst Diploma training course is ideal for highly driven students who wish to improve your personal and professional abilities while also preparing for the career of their dreams! This Data Analyst - Data Analyst Diploma is also great for persons who want to learn more about this topic in depth and appreciate being up to speed on the newest facts and expertise.

• There are no official requirements for Data Analyst - Data Analyst Diploma
• Data Analyst - Data Analyst Diploma requires basic Internet connection
• Data Analyst - Data Analyst Diploma requires you to have access to a computer, tablet, or a mobile device
• Knowledge of basic English

The Data Analyst - Data Analyst Diploma course is meant to prepare you for the job of your dreams, a promotion at work, or being self-employed and starting your own business. Courses from the Academy of Skills will help you enhance your profession and keep your skills current.

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