course-premium

Microsoft Excel 2016 - Advanced Level

Curso intensivo

Online

Preço Emagister

21 € 110 €

*Preço indicativo

Montante original em GBP:

£ 19 £ 99

Descrição

  • Tipologia

    Curso intensivo

  • Metodologia

    Online

  • Horário de aulas

    25h

  • Início

    Datas a escolher

Become an expert at using Microsoft Excel with this Microsoft Excel 2016 (Advanced Level) course, organized by 1 Training, that Emagister.co.uk has listed as part of its educational catalogue.

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

In this course, you’ll learn about financial reports, accounting formulas, functions, cell attributes, cell formatting, excel sheets, among other skills related with Microsoft Excel tools.

Besides, every 1 Training course offers you the opportunity to study 24/7 wherever you are in the world. These intensive online courses are open to everyone, as long as you have an interest in the topic! They provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

So, if you want more information about this programme contact 1 Training through Emagister.co.uk without hesitation. You won’t regret it!

Informação importante

Quais são os objetivos da formação?: "By enrolling to this course, you’ll learn how to manage cell contents in a worksheet.
In this course, you’ll learn how to create financial reports.
Having this course, you’ll learn accounting formulas, functions & specialized functions.
In this course, you’ll learn cell attributes & cell formatting.
This course will gain your knowledge of printing excel sheets.
Logging in to this course, you’ll learn how to insert & modify graphic objects.
On completion of this, course you’ll learn conditional formatting and data validations.
At the end of this course, you’ll learn how to export, import & integrate data with other sources."

Esta formação é para mim?: "Job hunters & School leavers
College or University students, graduates & Teachers
Personal assistant & Receptionist
Assistant for company director
New or Temporary staff
Office Administrators & Office managers
Office clerk, Marketing assistant & Administration Assistant
Secretary or Executive
Account assistance, Bookkeeper & Accountant
IT professionals & Businessman"

O que acontece após ter pedido informações?: On receiving your request, one of our staff members will call you or send you a message by explaining everything about the course you are requesting information, including how you can sign up, payment options, exam, and enrollment requirements, etc.

Preço para usuários Emagister: Special promotion price.

Requisitos: You’ll need a computer or tab with an internet connection and Microsoft Office software installed in it. Also, it’s better to have a notepad and a pen with you.

Instalações

Localização

Início

Online

Início

Datas a escolher Inscrições abertas

Matérias

  • Excel
  • Microsoft Excel
  • Financial
  • Financial Training
  • Microsoft excel training
  • MS Excel
  • Bookkeeper
  • Worksheet
  • Accountant
  • Modify Graphic Objects
  • Accounting Formulas
  • Excel Sheets
  • Data Validations
  • Microsoft Office software
  • Vlookup and Hlookup

Programa

"Description

COURSE CURRICULUM

MICROSOFT EXCEL 2016 - BEGINNER

  • Getting Started with Microsoft Excel
  • Data Entering
  • Creating Formulas and Functions
  • Formatting
  • Worksheet Views, Multiple Worksheets and Workbooks
  • IF, VLOOKUP, and Power Functions, Security & Sharing
  • Data Management, Data Analysis Tools
  • PivotTables & Macros
  • Exercise Files: Microsoft Excel 2016

MICROSOFT EXCEL 2016 - ADVANCE FORMULAS & FUNCTIONS

  • Introduction to Excel 2016 Advance Formula and Functions
  • Values and Formulas
  • Operations in Formulas
  • IF, AND, OR and NOT Functions
  • VLOOKUP and HLOOKUP
  • Tabulating Data and Multiple Criteria
  • Median, Mode and Ranking Data
  • Date, Time and Functions
  • Array Formulas and Frequency Functions
  • OFFSET and INDIRECT Function
  • Different TEXT & Information Functions

MICROSOFT EXCEL 2016 - ADVANCE FORMATING AND TECHNIQUES

  • Introduction to Excel Advance Formatting & Techniques
  • Adjust Fonts, Font Sizes & Font Colours
  • Adjust Cells and Tools
  • Work with Formulas & Tables
  • Adjust Row, Columns and Sheets
  • Different Formatting Styles and Set up Data for Outlines
  • Formatting Picture Styles
  • Formatting Techniques – Restore Missing Data in a Column

Course Duration: 

You will have 2 Months (60 days) access to your online study platform from the date you purchased (enrolled) the course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.

How will I be assessed?

  • At the end of the course you will have one Quiz test that will be marked automatically and you will be received an instant grade.
  • You will have a mock exam that you can prepare yourself for the final exam. After successfully passed your exam, you only need to pay £30 for your certificate.
"

Informação adicional

Career path

Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft Excel applications.
This Qualification is helpful for any Office job, such as PA, Secretary, and Administrator or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.

Microsoft Excel 2016 - Advanced Level

Preço Emagister

21 € 110 €

*Preço indicativo

Montante original em GBP:

£ 19 £ 99