Microsoft Excel 2013 Advanced. Online Excel Training Course

4.5
3 195 комментариев
Payment
Обучение платное
Certificate
Сертификация бесплатная
Duration
10 часов курса
О курсе

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite

Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including:

  • IF statements
  • VLOOKUP and HLOOKUP
  • Sparklines
  • Pivot Tables and Charts
  • Macro Operations

The Ability to Master Excel

By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Content and Overview

Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course.

Программа
Getting Started
Working Files - Download These First
0101 Will I Be Able To Keep Up?
0102 Using The Included Files
0103 New For 2013: Its All In The Cloud
0104 The Very Clever Flash Fill
Using Mathematical Functions
0201 The Basic SUM, COUNT, MIN, And MAX
0202 AVERAGE, MODE, MEAN, And MEDIAN
0203 SUMIF For Selective Adding Up
0204 COUNTIF For Selective Counting
0205 AVERAGEIF For The Mean Of Selected Cells
Требования
  • Microsoft Excel 2013, Windows 8, 7, Vista or XP
Что Вы изучите?
  • To take your basic Excel skills to the next level
  • To gain a solid understanding of the more powerful features and functions in Excel
  • To be able to use Microsoft Excel in a commercial environment
Лекторы
Infinite Skills
Infinite Skills
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Платформа
Udemy
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Microsoft Excel 2013  Advanced. Online Excel Training Course
Рейтинг
4.5
1 809
1 084
270
30
22