Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 50 Minute(s)
Language
English
Taught by
Francie Black
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn how to confidently create worksheets, use formatting, calculations, functions, analyze, filter, charts & tables.
This course is taught by a professional corporate trainer in a friendly, step by step method so that you can follow along and do the steps with the instructor. If you prefer to watch and listen, that works great too!
This course is designed to give you complete confidence in your knowledge of Excel. You will learn core features that you will use and build on throughout the course as we increase our knowledge of key features.
We start with a blank workbook and will build out multiple sheets from entering values to calculations and functions, all the way to building charts and updating data series.
This course is titled Beginning Excel but actually covers intermediate topics, too!
Can you answer these questions?
1. What is the difference between workbooks, spreadsheets, templates, sheets, file?
2. What is the difference between labels and values and why is that important?
3. Can you confidently use and modify calculations and average, sum, min and max formulas?
5. When should you convert your data to a table range and what are the pro's and con's?
6. How do I sort and filter my data by multiple criteria?
7. How do I add a series to a data range and have a chart automatically update?
If you answered "no" to any of these questions, then this course is for you!
We will answer all of these questions and much more!
Come on in and join us! We look forward to having you!
Course Content
- 13 section(s)
- 62 lecture(s)
- Section 1 Course Introduction
- Section 2 Excel Fundamentals
- Section 3 Getting Started with Worksheets
- Section 4 Getting Started with Formulas & Functions
- Section 5 Editing a Worksheet
- Section 6 Formatting a Worksheet
- Section 7 Working with Charts
- Section 8 Sorting Data
- Section 9 Filtering Data
- Section 10 Introduction to Tables
- Section 11 Working with Multiple Worksheets
- Section 12 Working with Images
- Section 13 Course Certificate
What You’ll Learn
- By the end of the course, you will be a confident Excel user.
- You will have the skills to say "I know how to use Excel" to any employer.
- Not only will you will be able to create and modify worksheets. You will be able to analyze and filter your data and create charts and graphs.
- Although this course is titled as a beginning level course, it really covers many intermediate level topics.
- This vs. That. We cover several features that are commonly confused because they have similar functionality (and names). We will distinguish the features and learn when you should use one feature instead of the other.
- This course will give a solid understanding of key concepts in Excel.
- Lean Tips & Tricks all Along the Way!
- Build Worksheets from Scratch
- Edit and Modify Worksheets
- Format worksheets
- Understand Print Options
- Work with Data Ranges
- Sort, Filter, Analyze Data
- Build & Edit Chart Data
Skills covered in this course
Reviews
-
KKatie Mooney
I'm a total beginner and so far this has been very easy to follow and the perfect course for beginners!
-
GGail Brown
Very pleasant voice! She spoke at a good speed, not too fast or slow. Very organized and it will be easy for me to go back to certain areas I want to review. I tried some other courses on this topic and asked for a refund but this one was great! Will take her next course too.
-
LLarissa Abrahamyan
This teacher is incredible and her voice is soothing so whole process is easy to understand! Will do more with her, no question.
-
TTroy Delbridge
I've learned a lot tnx so much
