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

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