Microsoft Excel 2013: How to Use Advanced Functions

Learn reporting techniques and how to use basic and advanced functions in Excel
4.8 (3 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
489 students enrolled
Instructed by Adam Holczer IT & Software / Other
$19
$195
90% off
Take This Course
  • Lectures 39
  • Length 5.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course Description

The aim of this course is to show you basic and advanced functions, their use, and some real-life example how to use it in your daily work/life. When I started learning Excel, I realized that it is very important to know Excel functions, but knowing them is not enough. You have to build it into your daily work and start thinking the way Excel "thinks". With this course I will focus on some real-life examples I had to face during my work and try to shed light on what Excel is capable of. The structure of the course includes some basics as well, so that if you do not have a strong basis, it still gives you guidance and a firm fund to continues and handle more complex problems. My aim is to show you how the functions work and then give you some tips how to use them. Moreover the videos are approaching from a point of view that can be useful at your workplace, e.g. automatization in handling structures, giving solutions for report generations. If you would like to save some time and spend less on sitting in front of a computer and handling data in Excel, then I recommend this course for you.


What are the requirements?

  • Installed Microsoft Excel 2013 is necessary

What am I going to get from this course?

  • understand Excel logic
  • use basic functions
  • use advanced functions for automation and reporting purposes
  • handle large data set and make basic report structure out of it
  • get insight into real life examples and their solution
  • have a strong overview of the most important excel functionalities

What is the target audience?

  • This course is for all computer-literate persons, who has alredy worked in Excel and would like to know more about the built-in function and solutions. Moreover for those who would like to see what kind of structure can be created.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
04:39

In this lecture, I am going to talk a bit aboutu myself and about the aim of my course.

02:07

In this lecture, I show what kind of data set I will use to present the Excel functions and what is the background of it.

Section 2: Date and Time
03:47

Simply go through some basic date and time-related functions that will be useful for automation and reporting purposes (YEAR, MONTH, DAY, DAYS, TODAY).

13:03

Learn about using number coding for weeks, days, moreover, how to handle dates in excel (holidays included/excluded etc). Functions: WEEKDAY, WEEKNUM, WORKDAY (2).

Section 3: Math-related Functions
03:17

Learn about basic Math functions in Excel (MIN, MAX, AVERAGE, MEDIAN).

11:45

Learn about advanced math functions for reporting and automation purposes (SUM, ROUND-functions, SUMPRODUCT, RAND).

Section 4: Logical Functions
05:04

Learn about logical functions e.g. IF, AND, OR, NOT.

07:45

This lecture will show you how to use some if-type functions for reporting purposes. Functions: ISBLANK, ISERR, ISERROR, plus an extra tip.

13:09

This lecture is about learning how to use functions, like SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS.

Section 5: Lookup Functions
04:40

In this video the basic lookup functions are presented e.g. LOOKUP, HLOOKUP and the VLOOKUP.

09:35

This lecture shows how some advanced lookup functions work for automatizing processes. Functions: MATCH, INDEX, INDIRECT plus a hint.

Section 6: Text Manipulation Functions
04:43

This video is about some text manipulation essential functions, e.g. & and the CONCATENATE.

06:51

This video is about some advanced text manipulation functions like LEN, LEFT, RIGHT and MID.

03:50

This lecture shows how to make alphabet the easiest way in Excel.

Section 7: Charts & Graphs in Excel
11:44

In this lecture, the basic types of built-in charts are presented and some advices regarding their use.

12:49

In this lecture, I am going to show you what is the best way to change the data content of a graph, how can you modify its outlook, and how to handle changes in general.

17:00

This video shows how to create dynamic graphs in Excel and what kind of techniques exist to automatize plotting a chart.

07:22

This video presents how to make sparklines in Excel for an easy visualisation of trends.

Section 8: Miscellaneous
08:16

This lecture gives you some basics on paste options i.e. paste values, formats etc.

06:26

In this lecture you can learn about some basic and semi-advanced paste options, what is useful during your work. Moreover some shortcuts are presented as well.

09:36

This lecture gives you the full insight into the variety of paste options Excel can offer. All the special paste options are being explained.

09:55

This lecture is about how to make hyperlinks within a document and outside of it, moreover shows how to link more excel files to each other and how to update it.

20:22

This lecture gives you detailed explanation on how to use conditional formatting, and what is the best way to use it in reports.

09:01

This lecture presents the Data Validation functionality of Excel, that helps you secure and control each of the cells' content.

06:42

In this video I am going to talk about the ControlX and the Form Control type buttons and will give you some insights about the aim of their use in general.

08:52

In this video, the Combo Box, Check Box, List Box and the Spin Button are presented with description and some guidance how to use them and what for.

09:26

This video shows you how to create a Table in Excel and what is it good for, moreover, some tips for interactivity is shown.

11:04

This video lecture gives you an insight on how to connect a randomly chosen button with a macro that you recorded. With this example I would like to give you an idea how to turn some basic long and monotone activity into a quick solution.

Section 9: Tips and Examples with Functions
06:00

This lecture shows an example with the above described functions and gives an example how the functions can serve reporting purposes.

15:07

This video gives an example how some functions (SUMIF, INDIRECT, VLOOKUP etc) can be used with the aim of showing you a real life tip how you can create such structures.

04:21

This lecture shows an example how to use the advanced text manipulation function and give you a real life example for your further use.

09:01

This lecture gives you an example of how to refer to other datasets in other Excel files, while giving you some ideas, how to make reporting structures with having references to different files.

08:32

This lecture shows you a real-life example of how to use conditonal formatting for reporting purposes and in a more advanced way.

05:55

This lecture gives you an overview of how to use Data Validation built-in functionality and gives you a tip how to use it in real life.

08:30

This lecture shows you an example of how to use control boxes and buttons, and gives you an example of combining such built-in tools in Excel 2013.

15:05

This lecture presents you a more complex example of how to use list button in Excel and what kind of structures is it good for.

Section 10: Data Files
Data file
Article
Link data files - example
Article
Coupons
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Adam Holczer, Senior Optimization Analyst

I'm Adam, working for an oil company in sales optimization, aiming the potential sales volumes and allocation throughout the company's market. I have a strong interest in the Oil Industry, therefore I always wanted to work in the industry. after finishing Business Administration (BSc) I studied International Economics and Business in Budapest and in the Netherlands. My interest drove me back to University to study Optimization in Oil Industry in the framework of a post-graduate course. Now I am working for the biggest Oil & Gas Corporation in Central Eastern Europe as an optimization expert, supporting decision-making and analyzing the regional markets.

Ready to start learning?
Take This Course