Is it possible to learn Excel in under two hours?
Welcome to New Tricks: Easy Excel! This course is an introduction to Microsoft Excel. While Excel is a program commonly found on most computers, it can be a little intimidating to learn. In just under 2-hours, I will help you become more comfortable and confident using Excel.
Who is this for?
New Tricks: Easy Excel is for absolute beginners. It is for the person who has seen Excel, heard of it, but has no idea how to get started using it. No prior experience with Excel is necessary for this course. Familiarity with other Microsoft programs, such as Word or PowerPoint, is a plus but not a requirement at all.
What are the course requirements?
There is only one requirement for this course: you must have access to Microsoft Excel. Technically, you could watch this course without Excel, but the tutorials are designed to be practiced. I encourage you to have Excel open as you watch the lessons and practice along with me. I am working on Excel for Mac, which means that your version of Excel may look a little bit different than mine if you are on a PC. However, all of the concepts are the same.
How is the course organized?
New Tricks: Easy Excel is composed primarily of video tutorials. In each lesson, I introduce new concepts and walk you through applying them. I take things slowly and repeat each process several times to show you how each is done. As an added bonus, the last lesson is a quick guidebook I created for you to download as a pdf document. It contains how-to directions for most of the concepts we cover in the course. Download this and keep it on your computer desktop as a quick reference while you get more comfortable with Excel.
This course is organized into three sections. In “Working with Content", we will cover the basics of Excel. This includes adding content, editing content, and learning Excel terms (like spreadsheet). The next section, “Formatting and Functions", will introduce how to change the look of content. We will also explore the secret sauce of Excel, functions, and how these are used to execute math operations. Lastly, I will share with you my favorite Excel techniques in “Everyday Helpful Hints." By the end of this course, you will be able to incorporate Excel into your everyday workflow.
I look forward to seeing you in class!
Get used to your new home and learn the basics of the Excel environment.
Excel is only as good as the content you put in it. Learn the easiest ways to enter content into a spreadsheet.
Unless you are one-take Drake, chances are that you will need to make changes to your content. Here, I show you how to edit content easily.
After you have added and edited, let's get to moving! Learn how Excel makes moving content around your spreadsheet easy.
Sometimes you need to make big changes. In this section, I will show you how to add rows and columns.
When Excel looks good, you feel good. Learn some techniques to make your content appear the way you want it to.
Functions might just be the secret sauce in Excel. I will show you how to use basic functions using a grocery list.
New Tricks: Easy Excel is for you. What topics or techniques would you like to see me add to this course?
Great technique to use for long lists and lots of content. With this technique, you will never have to ask, "What does this number mean again?"
These techniques will help reduce visual clutter in Excel, making your spreadsheet a lot easier to read.
Printing can be tricky in Excel. Follow these tips to avoid some common mistakes.
Joseph received his MPH and BA both from UC Berkeley. He is currently the Manager for the Department of Education and Training at a large hospital. In this role, Joseph oversees programs to improve staff training and professional development. This includes addressing issues such as technical skills development, health literacy, and communication issues. Prior to this role, Joseph taught undergraduate Public Health courses at UC Berkeley, including the Community Health Impact Program. Joseph also worked in violence prevention as the project manager for the National Network of Hospital-based Violence Intervention Programs. A Bay Area native, Joseph lives in Oakland with his fiancée where they enjoy Lake Merritt, Cal football, and 49ers.