- Full Price
- 1467 QR
- You Save
- 1418 QR
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:
- Visit Alpha Academy’s Redeem Voucher Page
- Fill in the required information
- Enter voucher code
- Click on SUBMIT
- 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.