Microsoft Office Specialist Excel 2019 / 365

Excel has many helpful features that can ease the stress of working; doing accounting; and creating reports, budgets and graphs. Learning how to use Excel 2016 to its full capacity allows you to work more efficiently, saving you a lot of time and frustration. Working on Excel also helps business owners keep track of what is happening in the business so that they are able to make better business decisions. Whether you are a business owner, employee, or just need to take care of your personal admin, our course will help you fully understand Excel and prepare you for your Microsoft Office Excel Expert exam. What's more, you can level up your skills by enrolling in other Microsoft Office courses we have on offer.

What will you learn in this Microsoft Office Specialist in Excel 2016: Core course?

If you are already proficient in Excel, the expert course will allow you to get the most out of Microsoft Excel. Learn to use:

• the advanced features to merge workbooks, 
• perform data analysis and audit formulas in spreadsheets, 
• create PivotTables and PivotCharts, and work with macros. 

By doing this course, you will gain an advanced understanding of the Excel programme, and gain the ability to guide others as to the proper use of the programme's features. You will learn to create, manage, and distribute professional spreadsheets for a variety of specialised purposes and situations. You will learn to customise your Excel documents to meet project needs and improve your productivity.

What is included in the course fees?

This Course Fee excludes your exam voucher. Unfortunately, the Certiport Assessment Centres do not allow tuition providers to pay for learners and request that a learner does so themselves. Due to the fluctuation of the exam costs (Rand-US Dollar exchange), we are unable to indicate accurate exam costs, so you will need to contact your closest Certiport Centre to determine this exam cost.  You can locate one closest to you here: http:// www. certiport.com/Locator# (http://www.certiport.com/Locator#). 

You will gain access to an online classroom where you'll be able to find the following course content:

• A digital textbook (PDF) focused on all the content you'll need to cover in order to pass the exam successfully
  
• The Learning objectives and MOS skills covered in each lesson
  
• A glossary of Key terms for each section
  
• A summary of what you will learn, as well as the important points on which to focus Practice files to accompany the step-by-step exercises in your textbook
  
• A summary of what you will learn, as well as the important points on which to focus Practice files to accompany the step-by-step exercises in your textbook
  
• A study guide and exercise files that will help you with your exam prep
  

PLEASE NOTE: For Microsoft Excel 2016, you will only receive a study guide and exercise files to help you with your exam prep

Hardware Required

• 1 gigahertz (GHz) or faster x86-bit or x64 -bit processor with SSE2 instruction set
  
• 2 GB RAM
• 3.0 GB available disk space
  
• 1280 x 800 screen resolution
  
• Graphics hardware acceleration requires a DirectX 10 graphics card
  

Software Required

You will need to have access to the following pieces of software depending on the pathway you're following:

• Windows 10, Windows 8.1, Windows 8, Windows 7 Service Pack 1, Windows 10 Server, Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2. For the best experience, use the latest version of any operating system
  
• The current or second most recent version of Internet Explorer, Safari, Chrome, Firefox, or Microsoft Edge
  
• .NET 3.5 required. Some features may require .NET 4.0 or 4.5 CLR also to be installed
  
• A PDF reader:
  
• PC/Mac - Adobe Reader or Foxit Reader are good examples
  
• iPhone - Reader or Adobe Reader
  
• Android - Xodo, Moon+ Reader, Adobe Reader, or Foxit
  
• An image viewer - most devices will come with a built-in image viewer
  
• Microsoft Excel 2016
  

OR

• Microsoft Office 365

(The programmes in this Suite are the same as Microsoft Office 2016, but they may be updated more regularly and, therefore, have some differences).

Course Starting Dates

With E-Square Education, you can start studying whenever you want: there are no specific course starting dates since we offer distance learning. Please speak to our Educational Planners about your enrolment and study options.

Prerequisites: None

Exam Requirements:

To pass this course, you must write and pass Exam 77-728: Excel Expert 2016 (https://www.microsoft.com/en-us/learning/exam-77-728.aspx).

Exam Dates:

You can start studying whenever you want - there are no specific course starting dates.

All of our assessments are computer-based and, therefore, done online. You are required to book an exam appointment via our Campus Assessment Centre at least 2 weeks prior to your exam date to prepare for your assessment.

Exam Fees:

The course examination fees are not included in your course. Unfortunately, the venues do not allow tuition providers to pay for learners and request that a learner does so themselves. Because of the fluctuation of the exam costs (Rand-US Dollar exchange), we are unable to indicate accurate exam costs, so you will need to contact the venue to determine the costs.

Assessments Information

You will be provided with the necessary study material so that you can prepare for your external exam. These exams are Computer-Based Assessments and are held at a registered Certiport Assessment Centres. You will need to contact any one of the Certiport Solutions Providers to purchase your exam voucher.

You can locate one closest to you here: http:// www. certiport.com/Locator# (http://www.certiport.com/Locator#).

Once you have located the Certiport Authorised Testing Centre (CATC) closest to you, you will need to contact them to purchase your exam voucher and schedule your exam.

Please ensure that your chosen centre is set up to administer your exam. Once you have successfully completed the exam, your Certiport Testing Centre will provide you with an exam score report, which will also be available to you on your Certiport profile. You will then receive your Microsoft Certification.

Please contact us on studyonline@ecubeonline.com for assistance.

Accreditation Info  

Status: Accredited course

Type & reward: Microsoft Technical Associate- Microsoft Certificate

Provided by: Microsoft Minimum credits: N/A

Edu City Campus is a registered provider of Microsoft training programmes. Microsoft is an industry leader in technological development and sets the de facto standard worldwide. They offer internationally recognised information technology certifications which provide valuable knowledge needed to begin or expand a career in information technology and development. They continuously update and develop their study programmes to keep up with technological advances, and they ensure that the exams are relevant to the IT industry. Microsoft Office certifications are sought after, trusted by employers, and validate your knowledge of computer systems, security or software development.

Status: Accredited course

Type & reward: Microsoft Office Specialist - Microsoft Certificate

Provided by: Microsoft Minimum credits: N/A

Edu City Campus is a registered provider of Microsoft training programmes. Microsoft is an industry leader in technological development and sets the de facto standard worldwide. They offer internationally recognised information technology certifications which provide valuable knowledge needed to begin or expand a career in information technology and development. They continuously update and develop their study programmes to keep up with technological advances, and they ensure that the exams are relevant to the IT industry. Microsoft Office certifications are sought after, trusted by employers, and validate your knowledge of computer systems, security or software development.

Entry Requirements

• Grade 10
  
• Learners must be 16 years or older
  
• The ability to read and write in English
  
• Access to a computer (PC or Mac)
  
• Access to the internet
  
• Computer literate (familiar with operating a computer)
  

What subjects make up this course?:

What are subjects?

Subjects are the particular fields of study that are covered in a course. The subjects below make up this course and will need to be completed in order for you to complete this course.

• Advanced features to merge workbooks,
• Perform data analysis and audit formulas in spreadsheets,
• Create PivotTables and PivotCharts, and
• Work with macros
• Create, manage, and distribute professional spreadsheets for a variety of specialised purposes and situations.
• Customise your Excel documents to meet project needs and improve your productivity.
  

Microsoft Office Specialist Excel 2016 Proficient

At the end of this module you will be able to create professional looking presentations. You will learn how to format text, illustrations, charts, shapes, audio and video. You will also learn how to create self-running presentations, speaker notes and meeting notes..