Microsoft Excel 2013: How to Use Advanced Functions
4.0 (1 rating)
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.
493 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013: How to Use Advanced Functions to your Wishlist.

Add to Wishlist

Microsoft Excel 2013: How to Use Advanced Functions

Learn reporting techniques and how to use basic and advanced functions in Excel
4.0 (1 rating)
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.
493 students enrolled
Created by Adam Holczer
Last updated 12/2016
English
Current price: $10 Original price: $55 Discount: 82% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 3 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Installed Microsoft Excel 2013 is necessary
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.


Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 39 Lectures Collapse All 39 Lectures 05:15:27
+
Introduction
2 Lectures 06:46

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

Preview 04:39

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.

About the data
02:07
+
Date and Time
2 Lectures 16:50

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

Preview 03:47

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

Advanced for automation
13:03
+
Math-related Functions
2 Lectures 15:02

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

Basics
03:17

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

Advanced for automation
11:45
+
Logical Functions
3 Lectures 25:58

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

Basics
05:04

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

IF-type functions for reporting
07:45

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

IF-type functions for calculation
13:09
+
Lookup Functions
2 Lectures 14:15

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

Basics
04:40

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

Advanced lookup manipulation
09:35
+
Text Manipulation Functions
3 Lectures 15:24

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

Basics
04:43

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

Advanced manipulation
06:51

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

Creating alphabet
03:50
+
Charts & Graphs in Excel
4 Lectures 48:55

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

Basic graph types
11:44

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.

Design and modify charts
12:49

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

Advanced chart manipulation - dynamic graph
17:00

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

Preview 07:22
+
Miscellaneous
10 Lectures 01:39:40

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

Basic copy/paste options
08:16

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.

Basic copy/paste options and shortcuts
06:26

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

Advanced copy/paste options
09:36

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.

Linking within and outside of the file
09:55

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

Conditional formatting
20:22

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

Data validation
09:01

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.

Buttons in Excel explained
06:42

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.

Buttons' use in Excel explained
08:52

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

Use 'Table' in Excel
09:26

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.

Buttons with assigned macro
11:04
+
Tips and Examples with Functions
8 Lectures 01:12:31

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

Lookup example 1
06:00

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.

Lookup example 2
15:07

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

Text manipulation example
04:21

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.

Link worksheets in separate files - example
09:01

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

Conditional formatting controlled by functions - example
08:32

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.

Creating drop-down lists in any cell - example
05:55

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.

Control box & button for reporting - example no. 1
08:30

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.

Creating list button to control a reporting structure - example no. 2.
15:05
+
Data Files
3 Lectures 00:05
Data file
00:01

Link data files - example
00:02

Coupons
00:01
About the Instructor
Adam Holczer
4.5 Average rating
23 Reviews
2,255 Students
6 Courses
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.