# Microsoft Excel 2013 Advanced. Online Excel Training Course

4.5 (3195)
MOOC
Learning paid
English
10 hours course
Course by Udemy
\$ 31.99
\$ 31.99
What will you learn?
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

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.

Program
Getting Started
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
Requirements
• Microsoft Excel 2013, Windows 8, 7, Vista or XP
Lecturers
Infinite Skills
High Quality Training
Platform
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Rating
4.5
(1809)
(1084)
(270)
(30)
(22)