
Working Files, Office Hours and Course Guidelines
Intro to the Green to Guru curriculum, Skill level hierarchy and subjects covered in this course - from start to finish.
Explore Excel window views, including normal, page layout, and page break preview, with headers and footers, and master zoom controls to fit your selection.
Learn how to Navigate in Excel using the Arrow Keys, Mouse Pointer and Name Box.
Quickly navigate any worksheet by just using this great Keyboard Shortcut!
Master Excel copy, cut, and paste values, data, and formulas using the clipboard, shortcuts (Ctrl+C, Ctrl+V, Ctrl+X), and drag-and-drop to move across cells.
Learn to sort and filter data in Excel using A to Z and Z to A, custom sort, and header options to view by department and sales.
Learn how to Format Cells based upon conditions you set on the data within them!
Learn how to construct and use formulas in Microsoft Excel, starting with the equal sign and basic operators, and using cell references to perform addition, subtraction, multiplication, and division.
The most helpful resource for those new to Functions, explained!
What is a Function?
Explore how the IF function in Excel evaluates a condition and returns a value if true or false, with examples like flagging customers over 100 dollars.
Complete list of required exercises to submit in order to complete course towards the Guru Certificate
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!
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:
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!