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.
233 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.
233 students enrolled
Created by Adam Holczer
Last updated 4/2016
English
Current price: $10 Original price: $95 Discount: 89% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Basic computer skills
  • Excel 2013
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.

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
02:18:57
+
Introduction
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
07:11

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

Overview & basic use of the ribbon
17:15

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

Statusbar
03:57
+
Excel Functions - Fundamentals
6 Lectures 40:35

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

Lookup functions
11:59

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

Date & time functions
03:39

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

Math basic functions - sum and others
02:58

Learn about the following functions: AVERAGE, MEAN

Math basic functions - average and others
02:27

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

If function
11:08

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

Text manipulation
08:24
+
Miscellaneous
8 Lectures 49:41

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

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.

Hyperlink
04:42

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

Table
07:06

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

Group/Ungroup
02:23

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

Freezing panes
03:28

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
07:44
+
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!

Dataset
00:06

Coupons
00:01
About the Instructor
Adam Holczer
4.5 Average rating
27 Reviews
2,265 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.