Master Microsoft Excel Table Design in Under 30 Minutes
4.2 (354 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.
9,259 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Microsoft Excel Table Design in Under 30 Minutes to your Wishlist.

Add to Wishlist

Master Microsoft Excel Table Design in Under 30 Minutes

Master the DESIGN and CONSTRUCTION PRINCIPLES of using Excel Formula's and Functions with SHORT 2 MINUTE VIDEO'S!
4.2 (354 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.
9,259 students enrolled
Created by Jed Guinto
Last updated 9/2015
English
Price: Free
Includes:
  • 36 mins on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Data Inputting
  • Random Number Function
  • Basic Arithmetic
  • Cell Deletion
  • Fill Handle
  • Copying and Pasting
  • Font Type and Size Selection
  • Border Design
  • Cell Alignment and Justification
  • Bold, Italic and Underline Formatting
  • Cell Colouring
  • Text Colouring
  • Cell Merging
  • Text Wrapping
  • Row and Column Control
View Curriculum
Requirements
  • Paper and pen to take notes
  • Microsoft Excel 2007 or later
  • Access to a computer
  • Access to the internet
Description

JOIN MY COMMUNITY OF OVER 11,000 STUDENTS AND LEARN AMAZING TECHNIQUES, TIPS, TRICKS AND SECRETS THAT I'VE ACCUMULATED OVER 15 YEARS OF ACADEMIC AND PROFESSIONAL TRAINING!

+++++++++++++++++++++++++++

Created: 30 November 2014

Last Updated: 17 April 2015

+++++++++++++++++++++++++++

Course Achievements

  1. Over 1,500 Students in first month of release!
  2. Over 17 Positive Reviews
  3. Over 5,000 minutes consumed

+++++++++++++++++++++++++++

Course Description: Building Your First Table

Now that you know how to open Excel and move about, it's time to learn how to input information and perform some basic formatting.

I'll teach you how to create a table with your own generated information and then we'll go ahead and perform basic formatting such as borders, text justification, bold/italic/underline formatting, cell colouring, text colouring, merged cells and much more.

++++++++++++++++++++++++++

Course Details

  1. This course has the shortest and simplest tutorial video's you will ever see! Clear, concise and to the point!
  2. It is designed for the beginner/intermediate but if you're looking to freshen up on your skills, come on in!
  3. I've intentionally made the video's around 2 minutes or less so that you get your information instantly. NO MORE USELESS CHATTER!!
  4. FULL AND FREE LIFETIME ACCESS
  5. All future lectures, videos, documents and upgrades included FREE

+++++++++++++++++++++++++++

Instructor Achievements

  1. Member of the Udemy Council
  2. +19,000 students (totalling ~40,000 enrolments)
  3. Average of 300-500 enrolments per day (Highest enrolment rate in one day was 1400 students)
  4. +500 Positive Reviews (5 Star Average Rating across all courses)
  5. +18 Live courses (+20 courses in production)
  6. Incorporated my Udemy courses into RMIT University Laboratory Tutorials for Undergraduate Aerospace Engineers

+++++++++++++++++++++++++++

What Udemy has said about the Instructor

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'

+++++++++++++++++++++++++++

What students have already said about this course

  1. Karendipasquale14 Easy and informative! This is 30 minutes well spent! I feel more proficient using Excel after viewing these lectures! You make it so easy!
  2. Lucy Pabst Excellent course. Jed explained things very well and broke it down into small manageable sections. Even though the course is short, we are such an ADD society and this really helps keep your interest. I learned what I needed to and will be taking what I learned to track my attendance at school. I am a new teacher who feels extremely disorganized. Thanks Jed!
  3. Imtiaz Ahmed Short yet Effective. This course is very short yet very effective. If you want to revise your excel skills, its the best pick.
  4. Rick McCoy Short and to the Point. This Excel training was very well presented and went right to the point demonstrating exactly what you need to know to learn the basics of Excel. Thanks!
  5. Gary N Carr Great Course! Jed does a great job breaking it down to the basics.

+++++++++++++++++++++++++++

Enrol Now and Experience the Benefits

  1. I'll show you step-by-step, I'll explain and highlight every single button I press, I'll draw around important area's and icons with on-screen drawing tools, I'll zoom into small and hard to see area's so you don't miss a single thing!
  2. With over 15 years of experience using Microsoft Excel, I'll let you look over my shoulder as I teach you the fundamentals.
  3. I'll show you exactly how to master this technique in a fraction of the time it takes the average person to learn on their own from books, YouTube videos, blogs and forums!
  4. By mastering this technique you'll become the most productive and most efficient person at your job and at home!
  5. New doors and opportunities will begin opening up for you personally and professional with each new technique you acquire!

Click the “TAKE THIS COURSE" button, top right, NOW!!...every hour you delay you're missing out on huge opportunities!!

Who is the target audience?
  • This course has been designed for the absolute beginner. Never touched Microsoft Excel before? Then you’ve found the right place.
  • If you’re intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!
  • People from any country
  • People of all ages
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
2 Lectures 03:24

Here's a quick demonstration of what Microsoft Excel can do. Now again this is a very basic demonstration as the things you can do with Excel are basically limitless! This is simply to get your feet wet!

Microsoft Excel - Demonstration and Case Study Explained
02:21

I designed this course to be EXTREMELY to the point. Each video tutorial teaches one thing at a time and does it in 2 minutes or less. No more lengthy explanations or unnecessary chatter!!

Course Structure Introduction
01:03
+
Building your first table - Jed's Hotdog Business
6 Lectures 11:52
Data Input
01:34

Random Number Creation - Randbetween()
02:39

Your First Arithmetic Formula (Introduction)
01:55

Deleting Cell Contents
01:02

Fill Handle
02:36

Copying and Pasting Values
02:06
+
Formatting Basics
8 Lectures 13:20
Font Type and Size
01:56

Borders
01:15

Centre Alignment
01:17

Applying Bold, Italic and Underline Formatting
01:55

Applying a Cell Colour
01:42

Applying a Text Colour
01:10

Merged Cells
02:00

Wrap Text
02:05
+
Cell/Row/Column Control
3 Lectures 05:43
Cut, Copy and Paste (In detail)
02:18

Inserting Rows and Columns
02:05

Deleting Rows and Columns
01:20
+
Section 5 - Congratulations
4 Lectures 03:47
All My Courses!
02:21

Help Me Inspire More People!
00:11

Congratulations
01:11

Check us out on Facebook!
00:03
About the Instructor
Jed Guinto
4.4 Average rating
5,189 Reviews
62,316 Students
21 Courses
Aerospace Engineer, Business Analyst and Programmer

WHAT UDEMY HAS SAID ABOUT MY COURSES:

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'


PC MAG:

'Jed Guinto is something of an Udemy wunderkind!'

'There are all-stars, such as Mr. Guinto, who do well by any metric!'


ACHIEVEMENTS:

  1. Member of the Udemy Council
  2. Over 60,000 students
  3. Over 130,000 enrollments
  4. Over 5,000 Positive Reviews


WHAT MY STUDENTS SAY ABOUT ME:

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! 

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.


BIOGRAPHY:

Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world.

In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills. 

In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics.

From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online. 

In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. 

In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. 

In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology.