Leading Voices of Excel: Complete Intro to Excel for 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.
30 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Leading Voices of Excel: Complete Intro to Excel for 2016 to your Wishlist.

Add to Wishlist

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.
30 students enrolled
Last updated 4/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Article
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Install Excel 2016
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.

Who is the target audience?
  • Beginner Excel students
  • Students interested in adding another dimension of depth to their Excel knowledge
Students Who Viewed This Course Also Viewed
Curriculum For This Course
59 Lectures
07:03:16
+
Jennifer Bailey
14 Lectures 01:11:04





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
+
Jordan Hudgens
19 Lectures 01:36:37
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
+
Martin Kenny
15 Lectures 03:20:45
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
About the Instructor
Martin Kenny
4.3 Average rating
55 Reviews
5,590 Students
14 Courses
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.

John Bura
4.3 Average rating
5,650 Reviews
125,997 Students
125 Courses
Best Selling Instructor Web/App/Game Developer 300k 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.

Jennifer Bailey
4.5 Average rating
732 Reviews
29,118 Students
6 Courses
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.

Jordan Hudgens
4.5 Average rating
2,748 Reviews
30,656 Students
19 Courses
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.