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.
230 students enrolled
Instructed by Adam Holczer IT & Software / Other
$19
$95
80% off
Take This Course
  • Lectures 23
  • Length 2.5 hours
  • Skill Level Beginner Level
  • 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 12/2015 English

Course Description

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.

What are the requirements?

  • Basic computer skills
  • Excel 2013

What am I going to get from this course?

  • 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

What 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.

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

Intro about me and about the aim of the course.

02:07

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

Section 2: Excel From the Beginning
01:07

Introduction what is the aim and scope of the section.

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

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.

17:15

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

03:57

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

Section 3: Excel Functions - Fundamentals
11:59

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

03:39

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

02:58

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

02:27

Learn about the following functions: AVERAGE, MEAN

11:08

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

08:24

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

Section 4: 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.

04:42

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.

07:06

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

02:23

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

03:28

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

07:44

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.

Section 5: Data set
Article

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

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