Leading Voices of Excel: Complete Intro to Excel for 2016

A Beginner's Guide to Mastering Excel 2016
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.
29 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 59
  • Length 7 hours
  • 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 4/2016 English

Course Description

Welcome to Leading Voices of Excel: Complete Intro to Excel 2016.

In this course you'll be introduced to a group of top Udemy instructors who are experts with Excel.

John Bura will be covering how to use VBA in Excel.

Jennifer Bailey will be sharing Excel tables, simple formatting and formula. 

Jordan Hudgens, will be teaching how pivot tables work in Excel 2016.

Martin Kenny will be going over using custom Excel templates to increase productivity.

Having a range of different perspectives on Excel helps students to expand their own understanding and see things from a fresh angle.

Keeping up to date with cutting edge technology, especially Excel 2016, is helpful for discovering new features, maximizing efficiency and being able implement at a higher level.

What are the requirements?

  • Install Excel 2016

What am I going to get from this course?

  • Understand and implement VBA in Excel
  • Know how to use Excel tables
  • Have an understanding of simple formatting and formula
  • Have the ability to use pivot tables in Excel
  • Use custom Excel templates to increase their productivity
  • Have a deeper understanding of Excel from a broad range of instructors
  • Use some of the most popular Excel templates
  • Create and customize their own Excel templates

What is the target audience?

  • Beginner Excel students
  • Students interested in adding another dimension of depth to their Excel knowledge

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: Jennifer Bailey
Introduction
Preview
03:06
01. Naming and Saving a Workbook
Preview
04:12
02. Inserting and Naming Tables
Preview
04:48
03. Correcting case of names without capital letters (PROPER)
Preview
05:12
04. Creating a Display Name Using CONCATENATE and UPPER Functions
Preview
04:13
05. Extracting An Initial From A Name (LEFT Function)
02:40
06. How To Create a Drop Down List For Members Titles
03:26
07. How To Remove Duplicate Data From a Table
02:33
08. How To Calculate Age From Date of Birth
04:57
09. Separating Addresses Out Into Multiple Fields (Text to Column)
08:47
10. Creating a Summary Sheet (VLOOKUP)
10:50
11. Removing VLOOKUP Error Messages (IFERROR)
06:03
12. How To Duplicate An Existing Worksheet
03:35
13. Updating Payment Information (Percentage Increase)
06:42
Section 2: Jordan Hudgens
01. Conditional Formatting Overview
04:12
02. Conditional Formatting Default Rules
05:44
03. Data Bars
05:16
04. Color Scales
04:55
05. Icon Sets
13:09
06 Custom Data Bars
06:05
07. Custom Color Scales
04:04
08. Custom Icons
05:15
09. Custom Format Based on Values
05:57
10. Formatting Cells that Contain A Specific Value
03:14
11. Formatting Top and Bottom Ranked Values
03:30
12. Formatting Values that are Above Or Below Average
02:17
13. Formatting Unique Or Duplicate Values
02:06
14. Compound Conditional Formatting
04:06
15. Editing Specific Rules
02:53
16. Manual Scenario Manager
05:28
17. Using the Scenario Manager
07:28
18. Merging Scenarios
06:06
19. Scenario Pivot Table
04:52
Section 3: Martin Kenny
01. Excel Templates Basics
16:52
02. Popular Excel Templates Intro Part 1
11:35
03. Popular Excel Templates Intro Part 2
10:13
04. Monthly College Budget and Credit Tracker
11:32
05. Grocery List
09:42
06. Recipe Book, Wine Connoisseur, and Meal Plan
15:57
07. Movie List, Fitness Plan, Inventory List and Party Planner
15:38
08. Gantt, Buy vs. Lease Car, and Sales Funnel
10:10
09. Custom Excel Templates Intro Part 1
11:51
10. Custom Excel Templates Intro Part 2
12:59
11. Deliverables
19:55
12. Marketing Onsite, Offsite and with Partners
12:03
13. Master Form and Link Generator
17:18
14. Reviews and Improvements
07:48
15. New Ideas, Upload Video (w/Fixes), and Gmail Filter Generator
17:12
Section 4: John Bura
01. Introduction and course requirements
Preview
04:42
02. Setting up developermode and talking about VBA
Preview
06:32
03. Running Macro Code
Preview
04:04
04. Talking about how VBA works with Excel
Preview
05:29
05. Integer - Boolean - Double and String Variables
Preview
05:58
06. If Statements
Preview
04:10
07. Else if Statements
Preview
03:26
08. Printing multiple items on one line
Preview
06:36
09. For Loops and nested for loops
07:32
10. Arrays
Preview
06:20
Downloadable Custom Templates
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Martin Kenny, Author of "Malibu Code: Learn HTML, CSS and JavaScript"

Martin Kenny is the author of "Malibu Code: Learn HTML, CSS and JavaScript," a book that teaches the fundamentals of web design and interactive website programming through the metaphor of surfing. The original phrase, "surfing the web" comes from surfing, and yet no other web design or programming courses explore the power of the surfing metaphor beyond this common phrase.

In Martin's courses you will learn coding skills faster by building on top of ideas you already understand, instead of learning things from scratch. Much like surfing, many people give up on trying to learn how to code after their first few experiences with failure. Martin's courses are different because they explain everything in simple English and don't assume that you know anything about computers or programming or have any prior experience.

Instructor Biography

John Bura, Best Selling Instructor Web/App/Game Developer 250k Students

John Bura is has been a successful Udemy instructor since 2011. John Bura has been programming games since 1997 and teaching since 2002. John is the owner of the game development studio Mammoth Interactive. This company produces XBOX 360, iPhone, iPad, android, HTML 5, ad-games and more. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to the top 10 in the Apple's app store. In his spare time John likes to play ultimate Frisbee, cycle and work out.

Instructor Biography

Jennifer Bailey, Experienced off-line and on-line tutor

I have been creating websites for several years now and have been using WordPress as well as Serif software. I enjoy building websites for other people as well as myself.

I achieved my BSc(Hons) in 1996, and then my Post Graduate Certificate In Education in 2001. I am also a member of the Institute for Learning.

Since qualifying I have worked in education with a spectrum of ages and abilities in colleges, the workplace and though private work.

I am a specialist in teaching English, Maths, ICT and Food Studies, both off and on-line. I also have experience in curriculum design, e-Learning and assessing.

I use technology wherever possible in my courses and I try and cater for all learning styles.I have tailored my on-line courses to promote learning using small bite-sized steps so that the learner can work at their own pace and not to be baffled by terminology, nor bored by waffle!

When selecting FREE video tutorials within each course

1. Select video

2. Hit play button

3. Go to bottom right corner of each video player and change resolution from 320 to 720HD for best viewing.

Instructor Biography

Jordan Hudgens, CTO at devCamp

Jordan Hudgens is the CTO and Founder of DevCamp where he leads instruction and curriculum development for all of the DevCamp and Bottega code schools around the US.

As a developer for over the past decade, Jordan has traveled the world building applications and training individuals on a wide variety of topics, including: Ruby development, big data analysis, and software engineering.

Jordan focuses on project driven education, as opposed to theory based development. This style of teaching is conducive to learning how to build real world products that adhere to industry best practices.

Additionally Jordan has published multiple books on programming and computer science, along with developing training curriculum for Learn.co, devCamp, and AppDev on the topics of Ruby on Rails, Java, AngularJS, NoSQL, API development, and algorithms.

Ready to start learning?
Take This Course