Dive Into Excel 2013
0.0 (0 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.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Dive Into Excel 2013 to your Wishlist.

Add to Wishlist

Dive Into Excel 2013

Master Excel Like a Professional and get hired, promoted, and a salary raise.
0.0 (0 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.
0 students enrolled
Last updated 5/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Apply Excel to any discipline, business or school seting whether you are new to computers, a student or business owner.
View Curriculum
Requirements
  • Having been exposed to computers will help you. A copy of Microsoft Excel is recommended. We will instruct you to download a 60 day trial copy of Microsoft Office which includes Excel.
Description

Master Excel Like a Professional and get hired, promoted, and a salary raise. Learn basic to intermediate concepts by doing 3 targeted exercises which will allow you to see excel in action in a realistic context. No isolated concept learning which you can't remember anymore but learning in context. Like stories you never forget, these exercises will stay with you forever and they will be your reference as you start applying your knowledge. You will be able to apply the concepts you learn here in any situation even if you have never used excel before. 

Who is the target audience?
  • This Excel course takes you from ground zero to hero. Anyone regardless of their background can learn from this course since we start with basic concepts yet we take you all the way up to intermediate higher concepts.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 29 Lectures Collapse All 29 Lectures 01:10:39
+
Start Here
5 Lectures 16:28

Get a glance of what excel is and can do by diving right into.

Preview 03:01

You can get a trial copy of Excel that last 60 days so you  can follow along.

Get a 60 day trial copy of Excel
03:15

How to fire up Excel in Windows 8.1.

How to fire-Up Excel
02:40


We survey the Excel interface so you get familiar with the landscape.

Preview 04:04
+
Fundamental Concepts
8 Lectures 22:36

Learn what are Relative, Absolute and Hybrid Cell References.

Cell Refereneces
01:48

Learn what a range is, how to represent a range and what is for.

What is a Range
00:33

Learn to identify the fill handle in a cell or a range.

The Fill Handle
00:20

Shorten your learning curve by learning when the mouse pointer changes in the excel context.

Preview 03:34

See how the fill-handle saves you time with its magic.

Some magic with the fill handle
05:25

Just a reminder of math rules when it comes to operation order.

Order of Precedence
03:59

Learn what are data types and their use.

Data Types
02:44

What is the difference between a formula and a function? and why it matters.

Formulas and Functions
04:13

Fundamentals
5 questions
+
The Super Cellular Project
12 Lectures 22:12

We take a look at the project so you can look ahead to what we are to accomplish.

Surveying the project
00:36

Watch and learn 2 techniques of entering data into a sheet.

Entering data into a sheet.
02:02

Speed up data entry by using a range and freeing up from using the mouse.

Preview 01:29

Learn how to enter the built-in sum function.

Using the sum function.
03:23

Learn to merge a range of cells with 1 or more content.

Merging Cells
01:17

Making it all look nice with cell styles 

Cell Styling
01:57

Go beyond cosmetics by formatting cell values with datatypes.

Formatting with value format and data types
01:10

Create a column chart using the "Recommended Charts" button.

Preview 01:59

Change look and feel of a worksheet quickly by changing themes.

Applying Themes
01:01

Use "Chart Tools" settings to change the chart design.

Chart Tools Design
02:17

Use "Chart Tools" Format to change the chart settings

Chart Tools Format
03:00

Learn how to use the "What If" ",Goal Seek" function.  

Goal seek
02:01

Let's see if you can remember what you've learned in the Super Cellular Project.


Super Cellular
5 questions
+
The Dollar Premiere Project
4 Lectures 09:23

We survey the "Dollar Premiere" project to explore what we will do with this project.

The Dollar Premier Project
01:24

Learn to use the "Quick Analysis" tool to calculate totals

Quick Analysis Tool
01:53

Use the Average, Max, Min, and CountIf functions.

The Average, Max, Min and CountIf functions
02:41

Learn to convert a range into a table, and to apply conditional formatting.

Formatting with Tables, and Conditional Formatting.
03:25
About the Instructor
Professor Humberto Gil
0.0 Average rating
0 Reviews
0 Students
1 Course
Engineer, and Masters in IT

I have been teaching computer courses for the last 14 years in various institutions of higher education. After a start in corporate America, I was invited to teach and fell in love with the experience. I really believe I have a talent for simplifying complex subjects and I actually enjoy making these subjects accessible even to those with little exposure to technology.

My professional career started as a Civil Engineer and a few years later took a Master’s Degree in Information technology, some of the jobs I have held include Resident Engineer and a 2 years freelance experience in networking and web development.

My teaching style is to sprinkle my lectures with a little humor, it refreshes the atmosphere, and to point out mistakes I see of more common occurrence to those new to the topics.

Why do we have to fail to learn? if all those errors are foreseeable by the instructor and proper warnings are in order so we can abbreviate your learning experience.