Cademy logoCademy Marketplace
  • Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced

Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced

By Course Gate

5.0(1)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 11 hours 20 minutes

  • All levels

Description

Become an Excel expert with our comprehensive course bundle that covers Beginners, Intermediate, and Advanced levels – all CPD Accredited. This exclusive package offers you a unique learning experience at an unbeatable price.

Microsoft Excel is one of the most widely used programs for data visualisation and analysis in the world. It is essential for many tasks in households, businesses, and various industries. Whether you need to track hours, manage finances, create statements, or perform complex data analysis and visualisation, Excel can help you achieve your goals.

Our Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced will help you master Excel from scratch or refresh your existing skills. You will learn how to use Excel efficiently and effectively for various purposes.

Our tutorials are designed to make learning easy and enjoyable. You can learn at your own pace, whenever you want. Don't miss this chance to boost your Excel skills and your career prospects.

Learning Outcome of Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced

  • Understand spreadsheet concepts and navigate the Excel environment.

  • Efficiently enter and edit data for accuracy.

  • Adjust worksheets and workbooks to meet specific needs.

  • Utilise mathematical, statistical, logical, and text functions for enhanced analysis.

  • Enhance proficiency for faster and more effective Excel use.

  • Learn essential functions and formulas for streamlined tasks.

  • Capture your first job as a Microsoft Excel expert.

  • Create and edit charts for impactful data visualisation.

  • Gain tips for a successful career launch leveraging Excel expertise.

Key Features of the Course

  • A CPD certificate that is recognised worldwide.

  • A great online learning experience.

  • Interesting and unique online materials and activities.

  • Expert guidance and support from the field leaders.

  • Access to the study resources anytime you want.

  • Friendly and helpful customer service and admin support by email, phone, and chat from Monday through Friday.

  • Get a year-long access to the course.

Who is this course for

This Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced Course is suitable for -

  • Students

  • Recent graduates

  • Job seekers

  • Administrator

  • Accounts Administrator

  • HR Administrator

  • Accountant/Bookkeeper

  • Office Administrator

  • Warehouse Operatives

  • Anyone interested in Microsoft Excel

  • Individuals seeking Microsoft Office Specialist Excel Certification

  • Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise.

Requirements

  • Open to all interested in Microsoft Excel.

  • No prerequisites; suitable for individuals from any academic background.

  • Accessible course materials from any internet-enabled device.

CPD Certificate from Course Gate

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.

Career path

  • Data Analyst

  • Financial Analyst

  • Business Intelligence Analyst

  • Project Manager

  • Administrative Assistant

  • Accountant

  • Entrepreneur/Small Business Owner

  • Research Analyst

  • Educator/Trainer

course Content

19 sections•72 lessons
Microsoft Excel 2019 New Features12 lessons
  1. 1Introduction to Microsoft Excel 2019 New Features
  2. 2CONCAT
  3. 3IFS
  4. 4MAXIFS
  5. 5MINIFS
  6. 6SWITCH
  7. 7TEXTJOIN
  8. 8Map Chart
  9. 9Funnel Chart
  10. 10Better Visuals
  11. 11Pivot Table Enhancements
  12. 12Power Pivot Updates
Getting Started with Microsoft Office Excel 20165 lessons
  1. 1Navigate the Excel User Interface
  2. 2Use Excel Commands
  3. 3Create and Save a Basic Workbook
  4. 4Enter Cell Data
  5. 5Use Excel Help
Performing Calculations3 lessons
  1. 1Create Worksheet Formulas
  2. 2Insert Functions
  3. 3Reuse Formulas and Functions
Modifying a Worksheet3 lessons
  1. 1Insert, Delete, and Adjust Cells, Columns, and Rows
  2. 2Search for and Replace Data
  3. 3Use Proofing and Research Tools
Formatting a Worksheet6 lessons
  1. 1Apply Text Formats
  2. 2Apply Number Format
  3. 3Align Cell Contents
  4. 4Apply Styles and Themes
  5. 5Apply Basic Conditional Formatting
  6. 6Create and Use Templates
Printing Workbooks3 lessons
  1. 1Preview and Print a Workbook
  2. 2Set Up the Page Layout
  3. 3Configure Headers and Footers
Managing Workbooks3 lessons
  1. 1Manage Worksheets
  2. 2Manage Workbook and Worksheet Views
  3. 3Manage Workbook Properties
Working with Functions5 lessons
  1. 1Work with Ranges
  2. 2Use Specialized Functions
  3. 3Work with Logical Functions
  4. 4Work with Date & Time Functions
  5. 5Work with Text Functions
Working with Lists4 lessons
  1. 1Sort Data
  2. 2Filter Data
  3. 3Query Data with Database Functions
  4. 4Outline and Subtotal Data
Analyzing Data3 lessons
  1. 1Create and Modify Tables
  2. 2Apply Intermediate Conditional Formatting
  3. 3Apply Advanced Conditional Formatting
Visualizing Data with Charts3 lessons
  1. 1Create Charts
  2. 2Modify and Format Charts
  3. 3Use Advanced Chart Features
Using PivotTables and PivotCharts4 lessons
  1. 1Create a PivotTable
  2. 2Analyze PivotTable Data
  3. 3Present Data with PivotCharts
  4. 4Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks3 lessons
  1. 1Use Links and External References
  2. 2Use 3-D References
  3. 3Consolidate Data
Using Lookup Functions and Formula Auditing3 lessons
  1. 1Use Lookup Functions
  2. 2Trace Cells
  3. 3Watch and Evaluate Formulas
Sharing and Protecting Workbooks2 lessons
  1. 1Collaborate on a Workbook
  2. 2Protect Worksheets and Workbooks
Automating Workbook Functionality3 lessons
  1. 1Apply Data Validation
  2. 2Search for Invalid Data and Formulas with Errors
  3. 3Work with Macros
Creating Sparklines and Mapping Data2 lessons
  1. 1Create Sparklines
  2. 2MapData
Forecasting Data4 lessons
  1. 1Determine Potential Outcomes Using Data Tables
  2. 2Determine Potential Outcomes Using Scenarios
  3. 3Use the Goal Seek Feature
  4. 4Forecasting Data Trends
Resources1 lessons
  1. 1Resources - Microsoft Excel Complete Course - Beginner, Intermediate & Advanced

About The Provider

Course Gate
Course Gate
London
5.0(1)

Welcome to Course Gate, your gateway to a world of knowledge and oppo...

Read more about Course Gate

Tags

Reviews

+ Add Review