Skip to content

CPD Accredited Microsoft Excel Beginner To Professional Course

12 CPD Points | Expert-Led Excel Training | Practical Skills for Career Growth | Lifetime Access | Easy Refund Policy

WriteWow Solutions

Summary

Price
£12.50 inc VAT
Study method
Online, On Demand What's this?
Duration
12.4 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
  • CPD Accredited Certificate - £10
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

Why Study This Microsoft Excel Beginner to Professional Course?

  • Master Microsoft Excel from the fundamentals to advanced techniques, essential for business tasks and data-driven decision-making.

  • Gain practical Microsoft Excel skills that increase productivity and accuracy in handling data.

  • Enhance your career prospects with expert-level Microsoft Excel knowledge, widely recognised across industries.

Learning Outcomes

  • Develop essential Microsoft Excel skills for everyday business and personal use.

  • Master complex functions and formulas in Microsoft Excel for efficient data analysis.

  • Learn to visualise data using dynamic charts and graphs in Microsoft Excel.

  • Create, organise, and manage large datasets with advanced Microsoft Excel tools.

  • Boost productivity by automating repetitive tasks with macros and pivot tables in Microsoft Excel.

Opportunities for the UK Job Market

  • Data Analyst: Use Microsoft Excel for in-depth data analysis and reporting; salary range £30,000–£45,000 per annum.

  • Business Analyst: Apply Microsoft Excel to interpret business data and support strategic decisions; salary range £35,000–£55,000 per annum.

  • Administrative Assistant: Perform data entry, reporting, and document management efficiently with Microsoft Excel; salary range £20,000–£30,000 per annum.

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

CPD Accredited Certificate

Digital certificate - £10

This course has 12 CPD points. The CPD Accredited Digital Certificate will be sent via email upon successful course completion and confirmation of the CPD certificate certificate order.

Curriculum

1
section
155
lectures
12h 23m
total

    • 1: Microsoft Excel _ 0._sales_video_excel_course (720p) 02:40
    • 2: Microsoft Excel _ 1.1_excel_from_a-z_course_intro (720p) 03:20
    • 3: Microsoft Excel _ 1.2_what_is_microsoft_excel (720p) 04:16
    • 4: Microsoft Excel _ 1.3_who_is_this_course_for (720p) 03:30
    • 5: Microsoft Excel _ 1.4_microsoft_excel_marketplace (720p) 04:08
    • 6: Microsoft Excel _ 1.5_excel_job_opportunities (720p) 02:43
    • 7: Microsoft Excel _ 1.6_excel_job_types (720p) 03:51
    • 8: Microsoft Excel _ 2.1_finding_and_opening_excel (720p) 01:04
    • 9: Microsoft Excel _ 2.2_excel_s_start_screen (720p) 03:15
    • 10: Microsoft Excel _ 2.3_explaining_the_excel_interface (720p) 02:43
    • 11: Microsoft Excel _ 2.4_excel_interface_cont (720p) 01:25
    • 12: Microsoft Excel _ 2.5_excel_workbook_vs._excel_worksheet (720p) 02:12
    • 13: Microsoft Excel _ 2.6_saving_an_excel_doc (720p) 03:33
    • 14: Microsoft Excel _ 2.7_customizing_the_quick_access_toolbar (720p) 02:15
    • 15: Microsoft Excel _ 2.8_customizing_the_excel_ribbon (720p) 02:51
    • 16: Microsoft Excel _ 2.9_excel_shortcut_keys (720p) 01:43
    • 17: Microsoft Excel _ 3.1_creating_excel_labels (720p) 02:32
    • 18: Microsoft Excel _ 3.2_entering_numeric_data_in_excel (720p) 03:25
    • 19: Microsoft Excel _ 3.3_formatting_date_values_in_excel (720p) 05:19
    • 20: Microsoft Excel _ 3.4_building_basic_formulas_in_excel (720p) 04:43
    • 21: Microsoft Excel _ 3.5_order_of_operation (720p) 06:27
    • 22: Microsoft Excel _ 3.6_relative_vs_absolute_cell_references (720p) 07:23
    • 23: Microsoft Excel _ 4.1_excel_functions_explained (720p) 02:34
    • 24: Microsoft Excel _ 4.2_the_sum_function (720p) 07:31
    • 25: Microsoft Excel _ 4.3_the_min_and_max_function (720p) 03:43
    • 26: Microsoft Excel _ 4.4_the_average_function (720p) 02:00
    • 27: Microsoft Excel _ 4.5_count_functions (720p) 04:57
    • 28: Microsoft Excel _ 5.1_moving_and_copying_data (720p) 06:45
    • 29: Microsoft Excel _ 5.2_insert_and_delete_rows_and_columns (720p) 05:04
    • 30: Microsoft Excel _ 5.3_adjusting_the_width_and_height_of_cells (720p) 03:00
    • 31: Microsoft Excel _ 5.4_hiding_and_unhiding_excel_rows_and_columns (720p) 04:28
    • 32: Microsoft Excel _ 5.5_renaming_moving_and_deleting_excel_worksheets (720p) 05:27
    • 33: Microsoft Excel _ 5.6_adding_protection_to_specific_cells (720p) 04:23
    • 34: Microsoft Excel _ 5.7_protecting_the_structure_of_a_workbook (720p) 02:11
    • 35: Microsoft Excel _ 5.8_Adding_a_Workbook_Password_to_Open_File 02:09
    • 36: Microsoft Excel _ 6.1_formatting_fonts_and_cell_background_color (720p) 04:54
    • 37: Microsoft Excel _ 6.2_adding_cell_borders (720p) 04:47
    • 38: Microsoft Excel _ 6.3_formatting_data_appropriately (720p) 05:20
    • 39: Microsoft Excel _ 6.4_the_magic_behind_excel_s_format_painter (720p) 03:29
    • 40: Microsoft Excel _ 6.5_creating_styles_for_formatting_efficiency (720p) 05:55
    • 41: Microsoft Excel _ 6.6_merging_cells (720p) 03:26
    • 42: Microsoft Excel _ 6.7_the_power_of_conditional_formatting (720p) 06:09
    • 43: Microsoft Excel _ 7.1_grab_users_attention_using_illustrations (720p) 08:38
    • 44: Microsoft Excel _ 7.2_customizing_icons (720p) 04:41
    • 45: Microsoft Excel _ 7.3_create_compelling_graphics_with_smartart (720p) 05:36
    • 46: Microsoft Excel _ 8.1_the_commonly_used_column_chart (720p) 02:45
    • 47: Microsoft Excel _ 8.2_changing_the_chart_design (720p) 01:58
    • 48: Microsoft Excel _ 8.3_formatting_elements_of_a_chart (720p) 06:23
    • 49: Microsoft Excel _ 8.4_modifying_the_data_type_and_location_of_a_chart (720p) 06:06
    • 50: Microsoft Excel _ 8.5_little_slice_of_pie_charts (720p) 05:11
    • 51: Microsoft Excel _ 9.1_print_preview_options (720p) 04:25
    • 52: Microsoft Excel _ 9.2_excels_page_layout_view (720p) 06:36
    • 53: Microsoft Excel _ 9.3_printing_a_specific_range_of_cells (720p) 02:38
    • 54: Microsoft Excel _ 9.4_converting_spreadsheets_to_pdf_files (720p) 02:28
    • 55: Microsoft Excel _ 10.1_why_create_an_excel_template (720p) 01:22
    • 56: Microsoft Excel _ 10.2_how_to_create_an_excel_template (720p) 05:22
    • 57: Microsoft Excel _ 11.1_how_to_prepare_data_for_analysis (720p) 04:00
    • 58: Microsoft Excel _ 11.2_how_to_sort_data_in_excel (720p) 02:37
    • 59: Microsoft Excel _ 11.3_multi_level_sorting (720p) 02:33
    • 60: Microsoft Excel _ 11.4_custom_sorting_datasets_in_excel (720p) 02:26
    • 61: Microsoft Excel _ 11.5_applying_filters_to_datasets (720p) 04:44
    • 62: Microsoft Excel _ 11.6_creating_subtotals_within_a_dataset (720p) 05:38
    • 63: Microsoft Excel _ 11.7_converting_datasets_into_tables (720p) 05:55
    • 64: Microsoft Excel _ 11.8_finding_and_removing_duplicate_values (720p) 07:29
    • 65: Microsoft Excel _ 12.1_the_sumif_function (720p) 08:41
    • 66: Microsoft Excel _ 12.2_the_dsum_function (720p) 07:47
    • 67: Microsoft Excel _ 12.3_the_dsum_function_cont (720p) 02:35
    • 68: Microsoft Excel _ 12.4_the_subtotal_function (720p) 02:48
    • 69: Microsoft Excel _ 13.1_what_is_excel_data_validation (720p) 01:55
    • 70: Microsoft Excel _ 13.2_creating_a_drop_down_list_with_data_validation (720p) 07:08
    • 71: Microsoft Excel _ 13.3_different_types_of_data_validation (720p) 05:39
    • 72: Microsoft Excel _ 13.4_adding_custom_alerts_to_data_validation (720p) 06:53
    • 73: Microsoft Excel _ 13.4_creating_a_dynamic_drop_down_list (720p) 03:09
    • 74: Microsoft Excel _ 13.5_dependent_drop_down_list (720p) 08:38
    • 75: Microsoft Excel _ 14.1_creating_an_excel_pivot_table (720p) 05:30
    • 76: Microsoft Excel _ 14.2_modifying_excel_pivot_tables (720p) 05:38
    • 77: Microsoft Excel _ 14.3_grouping_filtering_pivottable_data (720p) 06:29
    • 78: Microsoft Excel _ 14.4_drilling_down_into_pivottable_data (720p) 01:59
    • 79: Microsoft Excel _ 14.5_creating_pivot_charts_and_slicers (720p) 07:59
    • 80: Microsoft Excel _ 15.1_what_is_powerpivot (720p) 03:45
    • 81: Microsoft Excel _ 15.2_activating_the_excel_powerpivot_addin (720p) 01:33
    • 82: Microsoft Excel _ 15.3_creating_relationships_between_data_tables (720p) 06:22
    • 83: Microsoft Excel _ 15.4_using_data_models_to_create_pivottables (720p) 04:30
    • 84: Microsoft Excel _ 15.5_how_to_create_powerpivot_kpis (720p) 08:26
    • 85: Microsoft Excel _ 16.1_excels_if_function (720p) 05:16
    • 86: Microsoft Excel _ 16.2_if_and_function (720p) 05:23
    • 87: Microsoft Excel _ 16.3_if_or_function (720p) 05:13
    • 88: Microsoft Excel _ 16.4_nesting_multiple_if_functions (720p) 07:23
    • 89: Microsoft Excel _ 16.5_the_countif_function (720p) 04:06
    • 90: Microsoft Excel _ 16.6_key_benefits_of_using_named_ranges (720p) 04:10
    • 91: Microsoft Excel _ 17.1_the_vlookup_function (720p) 08:59
    • 92: Microsoft Excel _ 17.2_the_beauty_of_excels_iferror_function (720p) 03:55
    • 93: Microsoft Excel _ 17.3_the_hlookup_function (720p) 06:21
    • 94: Microsoft Excel _ 17.4_the_index_function (720p) 04:42
    • 95: Microsoft Excel _ 17.5_the_match_function (720p) 04:55
    • 96: Microsoft Excel _ 17.6_index_and_match_combined (720p) 03:03
    • 97: Microsoft Excel _ 17.7_two_way_lookup_with_index_and_match (720p) 04:09
    • 98: Microsoft Excel _ 18.1_left_right_mid_function (720p) 07:08
    • 99: Microsoft Excel _ 18.2_extracting_specific_text_using_len_and_search (720p) 03:06
    • 100: Microsoft Excel _ 18.3_combining_text_with_concatenate (720p) 06:05
    • 101: Microsoft Excel _ 18.4_quick_tips_and_other_text_based_functions (720p) 05:48
    • 102: Microsoft Excel _ 19.1_tracing_precedents_and_dependents_in_formulas (720p) 04:27
    • 103: Microsoft Excel _ 19.2_showing_formulas (720p) 01:53
    • 104: Microsoft Excel _ 19.3_grouping_data (720p) 02:42
    • 105: Microsoft Excel _ 19.4_3d_referencing_in_formulas (720p) 02:52
    • 106: Microsoft Excel _ 19.5_utilizing_the_watch_window_in_excel (720p) 02:44
    • 107: Microsoft Excel _ 19.6_how_to_freeze_panes_in_excel (720p) 01:30
    • 108: Microsoft Excel _ 20.1_excels_scenario_manager_tool (720p) 05:55
    • 109: Microsoft Excel _ 20.2_goal_seek_in_excel (720p) 06:15
    • 110: Microsoft Excel _ 20.3_compare_results_with_excel_data_tables (720p) 04:23
    • 111: Microsoft Excel _ 20.4_solver_tool (720p) 10:59
    • 112: Microsoft Excel _ 21.1_the_power_behind_excel_vba (720p) 02:35
    • 113: Microsoft Excel _ 21.2_a_look_inside_the_visual_basic_editor (720p) 03:56
    • 114: Microsoft Excel _ 21.3_recording_a_macro (720p) 09:11
    • 115: Microsoft Excel _ 21.4_saving_and_opening_a_macro_enabled_workbook (720p) 02:13
    • 116: Microsoft Excel _ 22.1_modules_and_procedures (720p) 03:57
    • 117: Microsoft Excel _ 22.2_object_methods_and_properties (720p) 05:58
    • 118: Microsoft Excel _ 22.3_excel_vba_variables (720p) 04:38
    • 119: Microsoft Excel _ 23.1_referencing_a_range (720p) 13:30
    • 120: Microsoft Excel _ 23.2_inputbox_and_msgbox (720p) 05:32
    • 121: Microsoft Excel _ 23.3_using_variables_in_vba_code (720p) 04:32
    • 122: Microsoft Excel _ 23.4_if_then_else_statement (720p) 10:22
    • 123: Microsoft Excel _ 23.5_worksheet_functions_inside_vba (720p) 07:32
    • 124: Microsoft Excel _ 23.6_creating_user_defined_functions (720p) 09:18
    • 125: Microsoft Excel _ 23.7_user_defined_functions_within_vba_scripts (720p) 02:36
    • 126: Microsoft Excel _ 24.1_find_last_row_of_data (720p) 02:47
    • 127: Microsoft Excel _ 24.2_find_last_column_of_data (720p) 03:12
    • 128: Microsoft Excel _ 24.3_with_statement (720p) 04:51
    • 129: Microsoft Excel _ 24.4_debugging_and_error_handling (720p) 06:36
    • 130: Microsoft Excel _ 24.5_debugging_and_error_handling_cont (720p) 06:44
    • 131: Microsoft Excel _ 25.1_for_next_loop (720p) 09:12
    • 132: Microsoft Excel _ 25.2_do_until_loop (720p) 06:03
    • 133: Microsoft Excel _ 25.3_for_each_loop (720p) 03:36
    • 134: Microsoft Excel _ 26.1_assigning_macros_to_shapes (720p) 03:32
    • 135: Microsoft Excel _ 26.2_form_controls_vs_active_x_controls (720p) 07:50
    • 136: Microsoft Excel _ 26.3_worksheet_events (720p) 03:43
    • 137: Microsoft Excel _ 26.4_workbook_events (720p) 02:52
    • 138: Microsoft Excel _ 26.5_fun_with_vba_events (720p) 06:54
    • 139: Microsoft Excel _ 27.1_creating_an_excel_userform (720p) 03:15
    • 140: Microsoft Excel _ 27.2_adding_controls_to_userforms (720p) 10:00
    • 141: Microsoft Excel _ 27.3_how_to_show_an_userform (720p) 03:01
    • 142: Microsoft Excel _ 27.4_passing_textbox_values_to_desired_cells (720p) 06:36
    • 143: Microsoft Excel _ 27.5_passing_option_buttons_values_to_desired_cells (720p) 06:50
    • 144: Microsoft Excel _ 27.6_userform_combo_boxes (720p) 08:08
    • 145: Microsoft Excel _ 27.7_clearing_values_from_userform_controls (720p) 03:06
    • 146: Microsoft Excel _ 27.8_how_to_close_an_userform (720p) 01:33
    • 147: Microsoft Excel _ 27.9_userforms_and_protected_sheets (720p) 04:40
    • 148: Microsoft Excel _ 28.1_creating_an_excel_resume (720p) 04:51
    • 149: Microsoft Excel _ 28.2_getting_started_with_freelancing (720p) 02:18
    • 150: Microsoft Excel _ 28.3_top_freelance_sites (720p) 05:12
    • 151: Microsoft Excel _ 28.4_personal_branding_1 (720p) 06:47
    • 152: Microsoft Excel _ 28.5_networking_do’s_and_don’ts (720p) 04:21
    • 153: Microsoft Excel _ 28.6_importance_of_website (720p) 04:24
    • 154: Microsoft Excel _ 28.7_how_to_become_an_excel_freelancer (720p) 02:09
    • 155: Microsoft Excel _ 28.8_getting_your_first_client (720p) 07:45

Course media

Description

The Microsoft Excel Beginner to Professional Course is an expertly designed, all-encompassing training programme that transforms you from a beginner into a confident, advanced user of Microsoft Excel. It equips you with essential skills to efficiently handle data manipulation, analysis, and visualisation tasks across a wide range of industries.

In today’s data-driven world, Microsoft Excel is an indispensable tool relied upon by professionals in finance, marketing, administration, and beyond. From simple data entry to complex data analysis and automated reporting, this course provides everything you need to become a proficient Microsoft Excel user.

Starting with the fundamentals, you’ll learn how to navigate the Microsoft Excel interface, input and format data, and perform essential calculations. As you advance, you'll master powerful features such as formulas, functions, pivot tables, and macros—tools that significantly streamline workflows and boost productivity.

With practical, hands-on exercises and real-world business scenarios, the course ensures you gain not just theoretical knowledge but also actionable Microsoft Excel experience.

Upon completion, you’ll be able to confidently use Microsoft Excel for diverse tasks such as data analysis, visual reporting, budgeting, and financial modelling. Whether you're aiming to accelerate your career or improve performance in your current role, the Microsoft Excel Beginner to Professional Course provides the skills you need to succeed in any modern workplace.

Who is this course for?

This course will pave the way for higher study in the field of Microsoft Excel. You can enrol on higher level Microsoft Excel courses, such as:

  • Level 2 Award in Microsoft Excel
  • Level 3 Award in Microsoft Excel
  • Level 3 Diploma in Microsoft Excel
  • ICDL Microsoft Excel 2019 (Basic)
  • ICDL Microsoft Excel 2019 (Standard)
  • ICDL Microsoft Excel 2019 (Expert)
  • CAVA Certificate in Microsoft Excel 2016 Fundamentals
  • CAVA Certificate in Microsoft Excel 2016 Intermediate
  • CAVA Certificate in Microsoft Excel 2016 Advanced

Career path

This Microsoft Excel Training will assist you to get your desired job in the relevant field.

  • Excel Cost Estimator
  • Excel Project Manager
  • Data Analyst
  • Business Analyst
  • Accountant
  • Office Administrator

Questions and answers

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

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.