Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 2 Minute(s)
Language
English
Taught by
Bigger Brains
Rating
Course Overview
There are two kinds of people: Those who are masters at Excel, and those who wish they were
Become proficient in using the world’s most popular software tool for organizing and analyzing data.
When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to efficiently manage data using charts and tables, and how to use powerful reporting tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.
This is our most requested training course!
As you learn to use Excel effectively, you will start to see how powerful it is in managing small or large datasets. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Kathy Jones walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.
Topics covered include:
Working with named ranges
Inserting functions
Using advanced sorting and filtering techniques
Inserting Tables
Applying advanced Conditional Formatting
Inserting charts and graphics
Applying advanced charting tools
Working with Pivot Tables, Pivot Charts, Slicers, and Timelines
Over five hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Course Content
- 6 section(s)
- 53 lecture(s)
- Section 1 Working with Functions
- Section 2 Working with Lists
- Section 3 Analyzing Data
- Section 4 Visualizing Data with Charts
- Section 5 Inserting Graphics
- Section 6 Using PivotTables and PivotCharts
What You’ll Learn
- Create and use named ranges
- Insert functions into spreadsheets including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, and more!
- Sort and filter columns of data
- Create and modify Tables, and apply advanced Conditional Formatting
- Create and modify charts and graphics
- Apply advanced charting tools
- Create a PivotTable to group and summarize data
- Apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines
Skills covered in this course
Reviews
-
CClaire McH
Content was helpful but may have required a more advanced course
-
JJo A Davis, Ph.D.
Not a good match. Too much assumptions that I have prior knowledge of what is being spoken about. If I had had the Instructor for beginner's excel, perhaps I could be more on board. There aren't enough practice exercises to go along with what is being taught. I am not happy.
-
BBrandee Timko
I am learning new stuff which is great.
-
MMijken McCurry
The lady speaking has an annoying voice.
