Alpha Academy

After purchasing this deal, you'll need to visit the website listed on your voucher to complete redemption.

• What’s included: Microsoft Excel complete online course - beginner, intermediate, and advanced

The course syllabus:

• Introduction to Microsoft Excel 2019 new features:
  • CONCAT
  • IFS
  • MAXIFS
  • MINIFS
  • SWITCH
  • TEXTJOIN
  • Map chart
  • Funnel chart
  • 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
  • Use proofing and research tools
  • Preview and print a workbook
• Intermediate level:
  • Work with ranges
  • Use specialized functions
  • Work with logical functions
  • Sort data
  • Outline and subtotal data
  • 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
  • Determine potential outcomes using scenarios
  • Use the Goal Seek feature
  • Forecasting data trends

Features of the Course:

• E-learning course with an interactive learning portal
• Tutor support from industry experts
• Accredited PDF Certificate upon successful completion at a free of cost
• Exam system with instant results track progress within own personal learning portal
• Lifetime access to material
• 24/7 customer support

See the full course description.