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
$19
$30
37% off
Take This Course
  • Lectures 29
  • Length 1 hour
  • Skill Level All Levels
  • 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 3/2016 English

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

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

What am I going to get from this course?

  • Apply Excel to any discipline, business or school seting whether you are new to computers, a student or business owner.

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

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: Start Here
03:01

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

03:15

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

02:40

How to fire up Excel in Windows 8.1.

03:28

Learn the limitations of Excel

04:04

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

Section 2: Fundamental Concepts
01:48

Learn what are Relative, Absolute and Hybrid Cell References.

00:33

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

00:20

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

03:34

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

05:25

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

03:59

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

02:44

Learn what are data types and their use.

04:13

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

Fundamentals
5 questions
Section 3: The Super Cellular Project
00:36

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

02:02

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

01:29

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

03:23

Learn how to enter the built-in sum function.

01:17

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

01:57

Making it all look nice with cell styles 

01:10

Go beyond cosmetics by formatting cell values with datatypes.

01:59

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

01:01

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

02:17

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

03:00

Use "Chart Tools" Format to change the chart settings

02:01

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

5 questions

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


Section 4: The Dollar Premiere Project
01:24

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

01:53

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

02:41

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

03:25

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Professor Humberto Gil, 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.

Ready to start learning?
Take This Course