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!
5.0 (4 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,307 students enrolled
$30
Take This Course
  • Lectures 35
  • Contents Video: 4 hours
    Other: 1 min
  • 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 11/2015 English

Course Description

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!

What are the requirements?

  • Excel 2010 or 2013
  • Desire to become an Excel power-user

What am I going to get from this course?

  • 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

What is the target audience?

  • Beginner to Intemediate Excel users looking to hone their skills to the highest level

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: The Basics
01:45

Working Files, Office Hours and Course Guidelines

04:57

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

What are Workbooks and Worksheets?
02:00
02:05
  • What is a Row & a Column?
  • Introduction to the Cell Pointer & Active Cell


Selecting Rows & Columns
Preview
02:42
Excel Window 101: Zoom & Page View Options
05:35
08:20
  • Title Bar
  • Intro to the Quick Access Toolbar
  • Explanations of the Tabs of the Ribbon

Section 2: Navigation
09:05

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..
02:59

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

4 questions

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

Section 3: Basic Formatting
07:52
  • Text Alignment
  • Cell Fill Colors
  • Bold, Italics, and Underlining
09:31
  • The Format Painter
  • Number Group (Formatting Dropdown menu)
  • The Wrap Text and Merge & Center buttons
Formatting Dates
05:06
Section 4: Entering & Editing Data in Excel
Entering Data in Excel
07:01
Editing in Excel: Cut, Copy & Paste pt. 1
06:00
Cut, Copy & Paste: Paste Options Explained
17:24
Sort & Filter
Preview
10:33
06:25

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

08:42
  • Intro to the Formula Bar
  • Re-sizing Columns and Rows (shortcut)
  • Re-cap of all Excel Terms used to this point
7 questions

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

Section 5: Level 2 - Basic to Intermediate
11:50
  • Saving & Printing Documents
  • Using (free) pre-made Office.com Templates
  • Sharing documents
Backstage Menu Recap
Article
Worksheet Management
07:47
11:38
  • How to Find Text & Numbers within your Worksheets
  • Find & Replace Dialog Box
  • Keyboard Shortcuts
Section 6: Intro to Formulas and Functions
Intro to Formulas: Part 1
10:26
Intro to Formulas: Part 2 (Order of Operations)
08:34
08:49

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

The Fill Handle
09:03
10:39

What is a Function?

  • Constructing a Function
  • Arguements
  • The Sum Function
  • Auto Sum
  • Auto Sum Keyboard Shortcut
COUNT & COUNTA Functions
05:09
MAX, MIN and AVERAGE Functions
05:58
Essential Functions: Intro to IF
07:52
8 questions

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

Section 7: Visualizing Data: Charts, Tables & more
09:11
  • How to Insert Charts into a Worksheet
  • Basic chart elements
  • Both Excel 2013 & 2010
15:39
  • Formatting & Editing Chart Elements
  • Charting Non-neighboring Data Sets
  • Inserting a New Chart Worksheet (F11 Shortcut)
Creating a Table
11:29
Section 8: Final Exam and Exercises Re-cap
Article

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

11 questions

Novice to Intermediate Course Final Exam

Required for Certificate

Article

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!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Pat Excel, 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.

Ready to start learning?
Take This Course