Microsoft Excel-Green to Guru (Novice-Intermediate course)
4.5 (9 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.
2,337 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel-Green to Guru (Novice-Intermediate course) to your Wishlist.

Add to Wishlist

Microsoft Excel-Green to Guru (Novice-Intermediate course)

Become an Excel Guru from any Skill level overnight! Easy-to-learn curriculum will make you an Expert in 7hrs or less!
4.5 (9 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.
2,337 students enrolled
Created by Pat Excel
Last updated 11/2015
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 4 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Drastically Increase your value as an employee or prospect by taking your Excel wizardry to the next level
  • Create comprehensive Excel solutions to Solve any problem
  • Generate graphs and make sense of any data
View Curriculum
  • Excel 2010, 2013 and 2016
  • Desire to become an Excel power-user

Are you one of the many – afraid to start learning about Excel because you think it is ‘too technical’? So many people I meet in training think that there will always be someone at their company who is better than they are in Excel. What if I told you that you could become that expert within your company in only 8 hours or less?

Your computer or tech proficiency doesn’t matter, the Green to Guru course has been tried and tested across many different industries and skill levels – you WILL become the Guru for your company if you follow this curriculum.

This interactive learningexperience encourages student participation and engagement every step of the way, with examples of each technique in action.

Course Features:

  • Learn the three fastest ways to Navigate Excel like a pro
  • Learn how to Input, Sort & Filter and manipulate data of all kinds in Excel
  • Master the methods of Formatting, creating Charts and designing beautiful spreadsheets
  • Learn to Maneuver through Excel's Menus with ease to locate any command quickly and efficiently
  • Grasp the knowledge of Excel’s many Functions and how to employ them to do your bidding at will
  • Acquire the skills of Spellcheck, Verifying data, Translation, Protecting worksheets and more.
  • Master the many Keyboard shortcuts of Excel through practical application to become a Guru of efficiency
  • Become a Wizard with any spreadsheet quickly by learning the Fundamentals and Advanced techniques of Excel in a logical fashion
  • Harness the power to create functional resources in Excel to skyrocket productivity at any company
  • Change your life for the better by becoming one of Excel’s Elite – a true GURU!

As a Certified Excel Instructor, I understand the importance of being available for all my students 7 days a week, responding to questions and emails quickly and with detail. There will even be an FAQ section at the end of course 2 where I will answer each months most frequently answered question with Video and Tutorial explaining the solutions.

Upon completion of the course, ALL students who complete and submit the required exercises (in this and the Intermediate to Advanced course) will receive a signed, verified Excel Guru certificate to let the world know- you are one of Excel’s Elite!

Who is the target audience?
  • Beginner to Intemediate Excel users looking to hone their skills to the highest level
Students Who Viewed This Course Also Viewed
Curriculum For This Course
35 Lectures
The Basics
7 Lectures 27:24

Working Files, Office Hours and Course Guidelines

Preview 01:45

Intro to the Green to Guru curriculum, Skill level hierarchy and subjects covered in this course - from start to finish.

Introduction to the Green to Guru Curriculum

What are Workbooks and Worksheets?

  • What is a Row & a Column?
  • Introduction to the Cell Pointer & Active Cell

Rows and Columns

Excel Window 101: Zoom & Page View Options

  • Title Bar
  • Intro to the Quick Access Toolbar
  • Explanations of the Tabs of the Ribbon

Intro to Excel Ribbon & Menus
2 Lectures 12:04

Learn how to Navigate in Excel using the Arrow Keys, Mouse Pointer and Name Box.

  • Intro to named Cell Ranges
  • Intro to Excel Cursors
  • Keyboard shortcuts & more..
Basic Navigation Techniques

Quickly navigate any worksheet by just using this great Keyboard Shortcut!

Ninja ShortCutz: Keyboard Navigation

Easy quiz to re-cap the Basic Navigation techniques learned so far.

Basic Navigation Quiz
4 questions
Basic Formatting
3 Lectures 22:29
  • Text Alignment
  • Cell Fill Colors
  • Bold, Italics, and Underlining
Basic Formatting

  • The Format Painter
  • Number Group (Formatting Dropdown menu)
  • The Wrap Text and Merge & Center buttons
Basic Formatting Pt. 2

Formatting Dates
Entering & Editing Data in Excel
6 Lectures 56:05
Entering Data in Excel

Editing in Excel: Cut, Copy & Paste pt. 1

Cut, Copy & Paste: Paste Options Explained

Learn how to Format Cells based upon conditions you set on the data within them!

Conditional Formatting

  • Intro to the Formula Bar
  • Re-sizing Columns and Rows (shortcut)
  • Re-cap of all Excel Terms used to this point
Entering & Editing Data & Text (Basics Review)

Quiz to determine how much of the Excel basics you've learned so far have been retained for upcoming lessons.

Basics Level Test-Out
7 questions
Level 2 - Basic to Intermediate
4 Lectures 31:45
  • Saving & Printing Documents
  • Using (free) pre-made Templates
  • Sharing documents
Managing Workbooks 1: The Backstage View

Backstage Menu Recap

Worksheet Management

  • How to Find Text & Numbers within your Worksheets
  • Find & Replace Dialog Box
  • Keyboard Shortcuts
Searching your Spreadsheets: The Find & Select Feature
Intro to Formulas and Functions
8 Lectures 01:06:30
Intro to Formulas: Part 1

Intro to Formulas: Part 2 (Order of Operations)

The most helpful resource for those new to Functions, explained!

Function AutoComplete (why its awesome)

The Fill Handle

What is a Function?

  • Constructing a Function
  • Arguements
  • The Sum Function
  • Auto Sum
  • Auto Sum Keyboard Shortcut
Intro to Functions (& The SUM Function)

COUNT & COUNTA Functions

MAX, MIN and AVERAGE Functions

Essential Functions: Intro to IF

Assess your knowledge of Formulas and Functions learned thus far and improve your grasp on concepts.

Formulas & Functions Quiz
8 questions
Visualizing Data: Charts, Tables & more
3 Lectures 36:19
  • How to Insert Charts into a Worksheet
  • Basic chart elements
  • Both Excel 2013 & 2010
Charts 101

  • Formatting & Editing Chart Elements
  • Charting Non-neighboring Data Sets
  • Inserting a New Chart Worksheet (F11 Shortcut)
Charts 201: Chart Formatting & Options

Creating a Table
Final Exam and Exercises Re-cap
2 Lectures 00:22

Complete list of required exercises to submit in order to complete course towards the Guru Certificate

Required Exercise Recap

Novice to Intermediate Course Final Exam

Required for Certificate

Final Exam
11 questions

Put all of your Knowledge to the test and complete this Final Exercise of the Novice to Intermediate course!

(Required for Guru Certificate)

Download the attached Worksheet and complete to Test your Excel wits and see your new found knowledge in action!

Final Exercises
About the Instructor
Pat Excel
4.5 Average rating
9 Reviews
2,337 Students
1 Course
Certified MS Excel Specialist / Reporting Guru

As a Worksource coordinator in Los Angeles county, I took the initiative to begin teaching Microsoft Office to underprivileged youth and low-income homeless populations at New Image Shelter in Los Angeles. It brought me great joy being able to help those with little hope find confidence in their abilities and cultivate employment opportunities. As the coordinator of the Worksource program at a shelter serving about 1,000 per night, I was able to implement a new course curriculum which resulted in over 100 homeless receiving employment in various fields over the course of just 1 year.

From there, I went on to take more courses and hone my skills with the Microsoft Office suite which is where I better realized my propensity and aptitude with Microsoft Excel. Now working for the world's second largest Music Publishing company, I have been able to create useful forms and solutions to decades old problems simply by using MS Excel. In 2 short years, I have been twice promoted and am now Supervisor of Customer Support and corporate reporting for the company.