Mastering Excel 2019 - Intermediate
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, Subtotals, and nested functions
- 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
Requirements
- Students should have a basic knowledge of Microsoft Excel prior to taking this course
Description
There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were
When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru 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 manage data, charts, and tables, and how to use powerful tools such as PivotTables, PivotCharts, Slicers, Timelines, and more.
This is our most requested training course!
If you learn to use Excel 2019 or Excel 365, you will start to see how useful it is in your life—from formatting your grocery list to calculating complex ROI values. 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.
Who this course is for:
- People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data
Course content
- Preview01:47
- 05:00Using Named Ranges, Part 1
- 05:25Using Named Ranges, Part 2
- 05:08Using Named Ranges, Part 3
- 08:55Working with Date Functions, Part 1
- 04:17Working with Date Functions, Part 2
- 03:37Working with Date Functions, Part 3
- 05:29Working with Time Functions
- 08:36Working with Logical Functions
- 07:34Working with Conditional Functions
- 05:03Multiple Criteria Functions
- 05:13Using Nested Functions
- 05:56Using IFS and SWITCH Functions
- 04:13Working with Text Functions, Part 1
- 04:27Working with Text Functions, Part 2
- 03:42Working with Text Functions, Part 3
- 08:14Working with Text Functions, Part 4
- 06:59Working with Math Functions
- 4 questionsKnowledge Check
Instructor
Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.
Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.
Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.