Mastering Excel 2019 - Basics
What you'll learn
- Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
- Perform calculations using formulas and functions
- Insert and delete rows and columns
- Apply formatting to text, numbers, and cells including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
- Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
- Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
- Use multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
- Customize your instance of Excel including adding Groups to the Ribbon and modifying the Quick Access Toolbar.
Requirements
- A copy of Microsoft Excel 2019 is recommended.
Description
There are two kinds of people: Those who are masters at Excel, and those who wish they were
When you master Excel, 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 is your first step towards becoming an expert at using Excel 2019.
Who this course is for:
- People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 skills to create and modify spreadsheets.
Course content
- Preview02:09
- Preview08:34
- 09:15Selecting Data
- 07:14Using Commands
- 08:04Creating a New Workbook
- 05:59Entering Cell Data
- 07:27Using AutoFill
- 04:59Using Flash Fill
- 02:05using Excel Help
- 2 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.