Microsoft Excel Beginner To Professional Course

Frontier Education

Reed courses certificate of completion

Digital certificate - Included

• Section 1 21:50

  • 1: Excel from A-Z Course Intro Preview 03:21
  • 2: What is Microsoft Excel 04:16
  • 3: Who is This Course For 03:30
  • 4: Microsoft Excel Marketplace 04:09
  • 5: Excel Job Opportunities 02:43
  • 6: Excel Job Types 03:51

• Section 2 21:16

  • 7: Finding and Opening Excel 01:04
  • 8: Excel_s Start Screen 03:15
  • 9: Explaining the Excel Interface 02:43
  • 10: Excel Interface Cont 01:26
  • 11: Excel Workbook vs. Excel Worksheet 02:13
  • 12: Saving an Excel Doc 03:33
  • 13: Customizing the Quick Access Toolbar 02:15
  • 14: Customizing the Excel Ribbon 03:04
  • 15: Excel Shortcut Keys 01:43

• Section 3 29:51

  • 16: Creating Excel Labels 02:32
  • 17: Entering Numeric Data in Excel 03:25
  • 18: Formatting Date Values in Excel 05:19
  • 19: Building Basic Formulas in Excel 04:44
  • 20: Order of Operation 06:28
  • 21: Relative vs Absolute Cell References 07:23

• Section 4 20:48

  • 22: Excel Functions Explained 02:35
  • 23: The SUM Function 07:31
  • 24: The MIN and MAX Function 03:44
  • 25: The AVERAGE Function 02:01
  • 26: COUNT Functions 04:57

• Section 5 35:03

  • 27: Moving and Copying Data 06:45
  • 28: Insert and Delete Rows and Columns 05:04
  • 29: Adjusting the Width and Height of Cells 04:34
  • 30: Hiding and Unhiding Excel Rows and Columns 04:28
  • 31: Renaming Moving and Deleting Excel Worksheets 05:27
  • 32: Adding Protection to Specific Cells 04:24
  • 33: Protecting the Structure of a Workbook 02:11
  • 34: Adding a Workbook Password to Open File 02:10

• Section 6 34:05

  • 35: Formatting Fonts and Cell Background Color 04:55
  • 36: Adding Cell Borders 04:47
  • 37: Formatting Data Appropriately 05:21
  • 38: The Magic Behind Excel_s Format Painter 03:30
  • 39: Creating Styles for Formatting Efficiency 05:56
  • 40: Merging Cells 03:27
  • 41: The Power of Conditional Formatting 06:09

• Section 7 18:56

  • 42: Grab Users Attention using Illustrations 08:39
  • 43: Customizing Icons 04:41
  • 44: Create Compelling Graphics with SmartArt 05:36

• Section 8 22:26

  • 45: The Commonly Used Column Chart 02:46
  • 46: Changing the Chart Design 01:58
  • 47: Formatting Elements of a Chart 06:24
  • 48: Modifying the Data Type and Location of a Chart 06:06
  • 49: Little Slice of Pie Charts 05:12

• Section 9 16:08

  • 50: Print Preview Options 04:26
  • 51: Excels Page Layout View 06:36
  • 52: Printing a Specific Range of Cells 02:38
  • 53: Converting Spreadsheets to PDF Files 02:28

• Section 10 06:45

  • 54: Why Create an Excel Template 01:23
  • 55: How to Create an Excel Template 05:22

• Section 11 35:27

  • 56: How to Prepare Data for Analysis 04:01
  • 57: How to Sort Data in Excel 02:38
  • 58: Multi Level Sorting 02:34
  • 59: Custom Sorting Datasets in Excel 02:27
  • 60: Applying Filters to Datasets 04:44
  • 61: Creating Subtotals within a Dataset 05:39
  • 62: Converting Datasets into Tables 05:55
  • 63: Finding and Removing Duplicate Values 07:29

• Section 12 30:04

  • 64: The SUMIF Function 08:42
  • 65: The DSUM Function 07:47
  • 66: The DSUM Function Cont 07:06
  • 67: The SUBTOTAL Function 06:29

• Section 13 33:25

  • 68: What is Excel Data Validation 01:56
  • 69: Creating a Drop Down List with Data Validation 07:09
  • 70: Different Types of Data Validation 05:39
  • 71: Adding Custom Alerts to Data Validation 06:53
  • 72: Creating a Dynamic Drop Down List 03:09
  • 73: Dependent Drop Down List 08:39

• Section 14 27:40

  • 74: Creating an Excel Pivot Table 05:31
  • 75: Modifying Excel Pivot Tables 05:39
  • 76: Grouping Filtering PivotTable Data 06:30
  • 77: Drilling Down into PivotTable Data 02:00
  • 78: Creating PivotCharts and Slicers 08:00

• Section 15 24:39

  • 79: What is PowerPivot 03:46
  • 80: Activating the Excel PowerPivot AddIn 01:34
  • 81: Creating Relationships between Data Tables 06:22
  • 82: Using Data Models to Create PivotTables 04:31
  • 83: How to Create PowerPivot KPIs 08:26

• Section 16 31:35

  • 84: Excels IF Function 05:17
  • 85: IF AND Function 05:23
  • 86: IF OR Function 05:14
  • 87: Nesting Multiple IF Functions 07:24
  • 88: The COUNTIF Function 04:06
  • 89: Key Benefits of Using Named Ranges 04:11

• Section 17 38:14

  • 90: The VLOOKUP Function 09:00
  • 91: The Beauty of Excels IFERROR Function 03:56
  • 92: The HLOOKUP Function 06:21
  • 93: The INDEX Function 04:43
  • 94: The MATCH Function 04:56
  • 95: INDEX and MATCH Combined 05:08
  • 96: Two Way Lookup with INDEX and MATCH 04:10

• Section 18 31:46

  • 97: LEFT RIGHT MID Function 07:08
  • 98: Extracting Specific Text using LEN and SEARCH 12:44
  • 99: Combining Text with CONCATENATE 06:05
  • 100: Quick Tips and Other Text Based Functions 05:49

• Section 19 19:47

  • 101: Tracing Precedents and Dependents in Formulas 04:28
  • 102: Showing Formulas 01:53
  • 103: Grouping Data 02:42
  • 104: 3D Referencing in Formulas 05:04
  • 105: Utilizing the Watch Window in Excel 02:44
  • 106: How to Freeze Panes in Excel 02:56

• Section 20 27:32

  • 107: Excels Scenario Manager Tool 05:55
  • 108: Goal Seek in Excel 06:15
  • 109: Compare Results with Excel Data Tables 04:23
  • 110: Solver Tool 10:59

• Section 21 17:57

  • 111: The Power Behind Excel VBA 02:35
  • 112: A Look Inside the Visual Basic Editor 03:57
  • 113: Recording a Macro 09:11
  • 114: Saving and Opening a Macro Enabled Workbook 02:14

• Section 22 17:12

  • 115: Modules and Procedures 06:34
  • 116: Object Methods and Properties 05:59
  • 117: Excel VBA Variables 04:39

• Section 23 56:58

  • 118: Referencing a Range 13:30
  • 119: InputBox and MsgBox 05:33
  • 120: Using Variables in VBA Code 04:32
  • 121: If Then Else Statement 10:23
  • 122: Worksheet Functions inside VBA 07:32
  • 123: Creating User Defined Functions 09:19
  • 124: User Defined Functions within VBA Scripts 06:09

• Section 24 27:10

  • 125: Find Last Row of Data 05:46
  • 126: Find Last Column of Data 03:12
  • 127: With Statement 04:51
  • 128: Debugging and Error Handling 06:36
  • 129: Debugging and Error Handling Cont 06:45

• Section 25 18:51

  • 130: For Next Loop 09:12
  • 131: Do Until Loop 06:03
  • 132: For Each Loop 03:36

• Section 26 24:56

  • 133: Assigning Macros to Shapes 03:33
  • 134: Form Controls vs Active X Controls 07:50
  • 135: Worksheet Events 03:44
  • 136: Workbook Events 02:54
  • 137: Fun with VBA Events 06:55

• Section 27 47:11

  • 138: Creating an Excel UserForm 03:15
  • 139: Adding Controls to UserForms 10:00
  • 140: How to Show an UserForm 03:01
  • 141: Passing TextBox Values to Desired Cells 06:37
  • 142: Passing Option Buttons Values to Desired Cells 06:50
  • 143: UserForm ComboBoxes 08:08
  • 144: Clearing Values from UserForm Controls 03:06
  • 145: How to Close an UserForm 01:34
  • 146: UserForms and Protected Sheets 04:40

• Section 28 44:49

  • 147: Creating an Excel Resume 04:51
  • 148: Getting Started with Freelancing1 06:16
  • 149: How to Become an Excel Freelancer 05:12
  • 150: Top Freelance Sites 05:12
  • 151: Getting Your First Client 07:45
  • 152: Personal Branding 1 06:47
  • 153: Networking Do’s and Don’ts 04:22
  • 154: Importance of Website 04:24

• Sales video 02:40

  • 155: Sales Video Excel course 02:40

With expert guidance and a combination of videos, PDFs, and worksheets, this course will enable you to develop your beginner to advanced excel skills, become a data analyst,excel expert and unlock your full potential.

This Microsoft Excel Beginner To Expert Course covers:

1. Excel functions : what you need to know
2. Large sets of data maintenance: tailoring your approach to maximise impact
3. Mastering Creating Effective Spreadsheets
4. Create Dynamic Report with Excel PivotTables
5. Auditing Excel Worksheet Formulas

The course covers following areas:

• Excel from A-Z Course Introduction

• Excel from A-Z Course Section Overview

• Excel: What is Microsoft Excel?

• Excel: Who This Course is For

• Excel: Microsoft Excel Marketplace

• Excel: Microsoft Excel Job Opportunities

• Excel: Microsoft Excel Job Types

• Excel: Getting Started with Excel

• Excel: Finding & Opening Microsoft Excel

• Excel: Excel's Start Screen

• Excel: Explaining the Excel Interface

• Excel: Excel Interface Continued

• Excel: Excel Workbook vs. Excel Worksheet

• Excel: Saving & Opening Excel Documents

• Excel: Customising the Excel Quick Access Toolbar

• Excel: Customising the Excel Ribbon

• Excel: Excel Shortcut Keys

• Excel: Values, Referencing and Formulas

• Excel: Creating Excel Labels

• Excel: Entering Numeric Values in Excel

• Excel: Formatting Date Values in Excel

• Excel: Building Basic Formulas in Excel

• Excel: Order of Operations

• Excel: Relative vs. Absolute Cell References

• Excel: Intro to Excel Functions

• Excel: Excel Functions Explained

• Excel: The SUM() Function

• Excel: The MIN() & MAX() Function

• Excel: The AVERAGE() Function

• Excel: COUNT() Functions

• Excel: Adjusting Excel Worksheets

• Excel: Moving & Copying Data

• Excel: Insert & Delete Rows/Columns

• Excel: Adjusting the Width & Height of Cells

• Excel: Hiding and Unhiding Excel Rows and Columns

• Excel: Renaming, Moving & Deleting Excel Worksheets

• Excel: Adding Protection to Specific Cells

• Excel: Protecting the Structure of a Workbook

• Excel: Adding a Workbook Password to Open File

• Excel: Visually Pleasing Cell Formatting

• Excel: Formatting Fonts and Cell Background Colour

• Excel: Adding Cell Borders

• Excel: Formatting Data Appropriately

• Excel: The Magic behind Excel's Format Painter

• Excel: Creating Styles for Formatting Efficiency

• Excel: Merging Cells for a Cleaner Look

• Excel: The Power of Conditional Formatting

• Excel: How to Insert Images and Shapes

• Excel: Grab User’s Attention using Illustrations

• Excel: Customising Icons

• Excel: Create Compelling Graphics with SmartArt

• Excel: Visualise Data with Charts

• Excel: The Commonly used Column Chart

• Excel: Changing the Chart Design

• Formatting Elements of a Chart

• Modifying the Data, Type & Location of a Chart

• Little Slice of Pie Charts

• Excel's Printing Options

• Print Preview Options

• Excel's Page Layout View

• Printing a Specific Range of Cells

• Converting Spreadsheets to PDF Files

• Benefits of Using Excel Templates

• Why Create an Excel Template

• How to Create an Excel Template

• Working with Excel Datasets

• How to Prepare Data for Analysis

• How to Sort Data in Excel

• Multi-Level Sorting

• Custom Sorting Datasets in Excel

• Applying Filters to Datasets

• Creating Subtotals within a Dataset

• Converting Datasets into Tables

• Finding & Removing Duplicate Values

• Excel Database Functions

• The SUMIF() Function

• The DSUM() Function

• DSUM() Function Cont.

• The SUBTOTAL() Function

• Excel Data Validation

• What is Excel Data Validation?

• Creating a Drop Down List with Data Validation

• Different Types of Excel Data Validation

• Adding Custom Alerts to Data Validation

• Creating a Dynamic Drop Down List

• Complex Validation: Dependent Drop Down List!

• Excel PivotTables

• Creating an Excel Pivot Table

• Modifying Excel PivotTables

• Grouping & Filtering PivotTable Data

• Drilling Down into PivotTable Data

• Creating Pivot Charts & Utilising Slicers

• Excel's PowerPivot Add-In

• What is PowerPivot?

• Activating the Excel PowerPivot Add-In

• Creating Relationships between Data Tables

• Using Data Models to Create PivotTables

• How to Create PowerPivot KPIs

• Excel's Conditional Functions

• Excel’s IF() Function

• IF() Function with AND() Criteria

• IF() Function with OR() Criteria

• Nesting Multiple IF() Functions

• The COUNTIF() Function

• Key Benefits of Named Ranges

• Excel's Lookup Functions

• VLOOKUP() Function

• The Beauty of Excel’s IFERROR() Function

• HLOOKUP() Function

• INDEX() Function

• MATCH() Function

• INDEX() and MATCH() Combined

• Two-Way Lookup with INDEX() and MATCH()

• Text Based Functions in Excel

• LEFT(), RIGHT() and MID() Function

• Extracting Specific Text using LEN() & SEARCH()

• Combining Text with CONCATENATE()

• Quick Tips & Other Text Based Functions

• Auditing Formulas & Custom Views in Excel

• Tracing Precedents & Dependents in Formulas

• Showing Formulas

• Grouping Data

• 3D Referencing in Formulas

• Utilising the Watch Window in Excel

• How to Freeze Panes in Excel

• Excel’s “What If?” Tools

• Excel’s Scenario Manager Tool

• Goal Seek in Excel

• Compare Results with Excel Data Tables

• Solver Tool

• Welcome to Excel VBA!

• The Power Behind Excel VBA

• A Look Inside the Visual Basic Editor (VBE)

• Recording a Macro

• Saving & Opening a Macro-Enabled Workbook

• The VBA Language

• Modules and Procedures

• Objects, Methods and Properties

• Excel VBA Variables

• Writing VBA Code

• Referencing a Range

• InputBox & MsgBox

• Using Variables in VBA Code

• If Then Else Statement

• Worksheet Functions inside VBA

• Creating User Defined Functions

• User Defined Functions within VBA Scripts

• Important VBA Tools and Logic

• Find Last Row of Data

• Find Last Column of Data

• With Statement

• Debugging & Error Handling

• Debugging & Error Handling Cont.

• Excel VBA Loops

• For Next Loop

• Do Until Loop

• For Each Loop

• Triggering Macros

• Assigning Macros to Shapes

• Form Controls vs. ActiveX Controls

• Worksheet Events

• Workbook Events

• Fun with VBA Events!

• Excel User Forms

• Creating an Excel UserForm

• Adding Controls to UserForms

• How to Show an UserForm

• Passing TextBox Values to Desired Cells

• Passing Option Buttons to Desired Cells

• UserForm ComboBoxes

• Clearing Values from UserForm Controls

• How to Close an UserForm

• UserForms and Protected Sheets

• Starting a Career in Excel

• Creating an Excel Resume

• Getting Started with Freelancing

• How to Become an Excel Freelancer

• Top Freelance Websites

• How to Get Your First Client

• Personal Branding

• Networking Do's and Don'ts

• Importance of Having a Website

By the end of the course you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.

Excel course enables you to undertake new and different tasks – this Excel course can lead to job enhancements, promotion and increased motivation and job satisfaction. Helps to gain confidence in their use of Microsoft and Excel related topics - this Excel course can increase their productivity and efficiency in Microsoft related fields.

This Excel course is for anyone looking to develop their skills and knowledge in Excel related fields, as well as people who want to progress their career into Excel related professions.

• Anyone wants to enhance Excel related skills and knowledge.
• Anyone wants to use Excel related knowledge in his career or profession.
• Anyone needs Excel related skills for new job applications and opportunities.
• Anyone who wants to learn Excel and apply in real life.
• Anyone who wants to demonstrate Excel to prospective employers or jobs.
• Anyone who wants to apply Excel related skills and dive into relevant career paths.

Excel course also is for those wants to-

• • Improved organisational agility using Excel related skills.
  • Better and faster decision making with knowledge of Excel.
  • Quicker problem-solving using Excel.
  • Excel course is ideal for people looking for development of an existing career in Excel sector by being more skilful.
  • For those who want to join Excel related job sector, as well as looking to further develop their skills and knowledge.
  • People who want to perform better in Excel related careers.
  • Those who are passionate about Excel related skills.

Excel - Course Benefits:

• This Excel course was designed to give you the tools and strategies you need to create a measurable impact in your career — whether your impact goal is to get a job, to enhance skills related to Excel course, or to make a positive difference in some other way. The following is included for online study this Excel course with Frontier Education.
• Excel - Excel related courses that best suit work experience, knowledge and skills.
• Excel - Self-paced courses to continue working while studying Excel course.
• Excel - Self-Paced Excel courses to get free from the deadlines.
• Excel - Excel course materials that include training manual regarding Excel course, mock quizzes related to Excel course and case studies that challenge you to apply your knowledge of Excel course can be in PDF, Microsoft Word, Excel, and PowerPoint format.
• Excel - Assessment resources about Excel course are accessible through our online learning platform 24/7.
• Excel - A professional one-to-one tutor to provide all-inclusive assistance throughout the Excel course online.
• Learner support via live chat after starting Excel course.
• Dedicated tutor support from Monday to Friday with your Excel course.
• After completion of Excel course you will receive a free certificate of completion.
• You can access this Excel course on your mobile, desktop or laptop from anywhere with internet access.
• Tailor-made: Excel course adapted to market needs and interests
• Flexible programs: study about Excel and work at your own pace on easy-to-use web platforms
• Online education: progressive teaching methods with video or easy to understand the medium to better understand Excel course.
• Multicultural: connect with classmates from all corners of the globe enrolled in Excel course.

Excel course does not require prior knowledge or experience, anyone with a PC, tablet or mobile phone can do the Excel course.

There are no prerequisites to start this Excel course but it would be beneficial for candidates to have the internet and basic knowledge of the English. Candidates with no prior Excel related knowledge or skills can start this Excel course and get ready for Excel related tasks and responsibilities.

Accountants and auditors-£30,000-£60,000

Administrative assistants, office clerks, information staff- £35,000

Business, management, and market analysts- £55,000

Educators, teaching assistants, and teachers- £45,000

Financial analysts, investment bankers- £75,000

Market research analysts and digital marketers - £50,000

Project managers, project coordinators, and construction managers- £80,000

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