How to Use Basic Functions in Excel
5.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.
234 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to Use Basic Functions in Excel to your Wishlist.

Add to Wishlist

How to Use Basic Functions in Excel

Functions for creating basic report stucture
5.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.
234 students enrolled
Created by Adam Holczer
Last updated 4/2016
Curiosity Sale
Current price: $10 Original price: $95 Discount: 89% off
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use basic functions in Excel
  • Learn some tips & ideas about automated structures
  • Get familiar with basic reporting functions in Excel 2013
  • Get acquainted with Excel structure
  • Learn how to customize your Excel sheet
View Curriculum
  • Basic computer skills
  • Excel 2013

The use of Excel nowadays is inevitable, especially at most of the white-collar-type workplaces. We are using it for many purposes, like calculating a company's performance i.e. sales data, production figures etc., creating reports for visualizing something or just to store huge dataset and use it as quick as possible. Excel is a very logical software and can be used without any specific knowledge. However, knowing even the fundamentals can imply huge time saving. Therefore being good at the program can make us much more efficient and can help in performing better. On the basis of my experience, having deep knowledge of excel capabilities and knowing the logic of the software result in outstanding efficiency improvement when it comes to solving reporting tasks or creating interactive charts. Therefore my aim in this course to give you the basic excel functions and giving some hints and ideas how do they work and what kind of tricks can be done in Excel 2013.

Who is the target audience?
  • This course is meant for newbies who are not familiar with the basic excel functions and its use. Moreover for those who would like to be quicker and more efficient in excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
2 Lectures 06:46

Intro about me and about the aim of the course.

Preview 04:39

About the used dataset, which can be found at the last section (example excel file).

Preview 02:07
Excel From the Beginning
5 Lectures 41:47

Introduction what is the aim and scope of the section.

Preview 01:07

This lecture shows the option menu item by item and give some hints what to look for.
Preview 12:17

This lecture gives important guide how to customize and personalize your excel ribbons, moreover shows you how to modify the ribbon and its tabs & groups within.

Customize the ribbon

This lecture goes through the ribbon and its content, meanwhile giving some basic guide where to look at.

Overview & basic use of the ribbon

This lecture shows what the statusbar contains and how to customize it.

Excel Functions - Fundamentals
6 Lectures 40:35

We are going to learn the following basic lookup functions: VLOOKUP, HLOOKUP and MATCH

Lookup functions

Learning how to make the following functions: YEAR, MONTH, DAY and TODAY.

Date & time functions

Learn about the basic useful math functions: MIN, MAX, SUM

Math basic functions - sum and others

Learn about the following functions: AVERAGE, MEAN

Math basic functions - average and others

We are going to learn about the IF function, and some examples and tips are presented.

If function

Learn about the following functions: LEN, LEFT, RIGHT. Moreover some extra hints are presented.

Text manipulation
8 Lectures 49:41

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

Basic copy/paste options

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

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

In this lecture we are going to see what the Hyperlink command in the ribbon does and what can it offer for support of reporting purposes.


This lecture shows how the Table command works and presents its advantages.


This lecture shows how to use grouping and un-grouping commands from the ribbon and how can it serve your riports.


This lecture presents how to freeze your dataset so that it will be easier to handle and search in the table.

Freezing panes

This lecture gives you insight how to protect your file, the worksheet, and how can you allow people to modify certain part of your document.

Protect a workbook & worksheet
Data set
2 Lectures 00:08

Download the example dataset that is being used in the tutorials and learn how to use basic functions. Enjoy!


About the Instructor
Adam Holczer
4.5 Average rating
29 Reviews
2,277 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.