Complete Microsoft Excel Course: Beginner to Advanced!

49 QR 1467 QR
Full Price
1467 QR
You Save
1418 QR
No longer
available
The deal ended at:
15/10/23
11:59PM
14 bought
limited quantity available

Fine Print

  • Valid from 26 Sep – 26 Nov 2023
  • Redemption period: 2 months from the deal’s start date
  • Refunds/cancellations are NOT permitted once the voucher has been redeemed
  • One voucher per person
  • May buy multiple vouchers as gifts
  • From the moment you start your course, you’ll have 60 days to complete it; you can get an extension if you need more time
  • After you have successfully passed the final assessment, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy.
  • For information/inquiries, visit: Complete Microsoft Excel Course: Beginner to Advanced or write to [email protected]
  • Internet access and audio required
  • Not valid with other offers
  • No cash value/No cash back/No refunds

 

How to Redeem: 

To activate your voucher and assign your course:

  1. Visit Alpha Academy’s Redeem Voucher Page
  2. Fill in the required information
  3. Enter voucher code
  4. Click on SUBMIT
  5. The course will be assigned to you within 48 hours and you can then begin your course after receiving an email from Alpha Academy

 

Please see the terms for all deals here

Highlights

 

Complete Microsoft Excel Course: Beginner to Advanced
Pay QR49 instead of QR1467

 

  • Microsoft Excel is the world’s leading spreadsheet, used for carrying out a vast range of office administrative duties! This program allows you to automate tasks, manage and present data, make calculations, and much more
  • To stand out to prospective employers, aspiring professionals must have excellent proficiency in Excel and this course makes it easy to get a solid understanding of MS Excel from Beginner to Advanced level!
  • Designed for learners of all levels, it covers key topics such as how to create worksheet formulas, modify tables, and use macros – with step-by-step guidance
  • You will learn how to navigate the Excel user interface and use Excel commands with confidence, sort and filter data and automate everyday work tasks.
  • The course is suitable for both part-time and full-time students! Learn with the freedom to study at your own pace, from any device with an internet connection

 

See full course outline below!

 

 

Excel in Microsoft Excel!

 

Microsoft Excel 2019 New Features

  • Introduction to Microsoft Excel 2019 New Features
  • CONCAT
  • IFS
  • MAXIFS
  • MINIFS
  • SWITCH
  • TEXTJOIN
  • Map Chart
  • Funnel Chart
  • Better Visuals
  • Pivot Table Enhancements
  • Power Pivot Updates

Beginner Level

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Intermediate Level

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Advanced Level

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
  • Create Sparklines
  • MapData
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Mock – Exam

Final – Exam

Order your Certificate

Give us your Feedback

 

Company Profile

Alpha Academy is an online learning platform that provides one of the best e-learning experiences. With a large variety of training courses to choose from, you are bound to find something to suit you. Whether it be to improve your current expertise or develop new skills, we can facilitate your goal.

 

Microsoft Excel Formulas & Functions Course

Microsoft Excel Formulas & Functions Course

 

‘Like’ Alpha Academy on Facebook!