Complete Excel 2019 for Beginners
This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets to bring your knowledge to an intermediate level. Exercises and sample files at every step along the journey.
New Course - Not Enough Reviews Yet
Course Goal
- Learn the basics of Excel 2019 up to an intermediate level
- Become more confident with your spreadsheets
- Start performing data analysis in Excel today
Audience
- End users
- IT/Business analysts
- Project Managers
- Project team members
Exam/Certificate
- Certificate of Completion (more certification info)
Lesson Plan
| # | Description | |
|---|---|---|
| Introduction to Excel 2019 | ||
| 1 | Introduction | Preview |
| 2 | What is new in Excel 2019 | |
| 3 | Course Overview | |
| 4 | Overview of the Excel Window | |
| 5 | Mouse Features | |
| 6 | Back Stage View | |
| Creating Workbooks | ||
| 7 | Entering Text and Numbers | |
| 8 | Creating Basic Formulas | |
| 9 | Relative References | |
| 10 | Order of Operations | |
| 11 | Working with Ranges | |
| 12 | EXERCISE - Practice Exercise | |
| 13 | Excercise Document | |
| 14 | EXERCISE - Practice Exercise Solution | |
| Saving Workbooks | ||
| 15 | Working with Save and Save As Commands | |
| 16 | File Extensions, Share, Export & Publish Files | |
| 17 | EXERCISE - Practice Exercise | |
| 18 | Exercise Document | |
| Navigating Workbooks | ||
| 19 | Opening a File | |
| 20 | Working with Larger Files | |
| 21 | Freeze Panes Option | |
| 22 | Split Screen Option | |
| 23 | EXERCISE - Practice Exercise | |
| 24 | EXERCISE - Practice Exercise files | |
| Page Setup & Print Options | ||
| 25 | Headers and Footers | |
| 26 | Working with Print Titles | |
| 27 | Working with Comments | |
| 28 | Page Setup Options | |
| 29 | Fit to Print on One Page | |
| 30 | Printing Workbooks | |
| 31 | EXERCISE - Practice Exercise | |
| 32 | Practice Exercise files | |
| Working with Rows, Columns and Cells | ||
| 33 | Adding and Deleting Rows / Columns | |
| 34 | Changing Column and Row Widths | |
| 35 | EXERCISE - Practice Exercise | |
| 36 | Practice Exercise files | |
| Moving Data | ||
| 37 | Cut, Copy and Paste | |
| 38 | Copying Formulas | |
| 39 | EXERCISE - Practice Exercise | |
| 40 | Practice Exercise files | |
| Formulas & Functions | ||
| 41 | Overview of Formulas | |
| 42 | Create Formulas Using Functions I | |
| 43 | Create Formulas Using Functions II | |
| 44 | Absolute Values | |
| 45 | EXERCISE - Practice Exercise | |
| 46 | Practice Exercise files | |
| Working with Sheets | ||
| 47 | Adding, Deleting and Renaming Sheets | |
| 48 | Additional Sheet Tab Options | |
| 49 | 3 Dimensional Formulas | |
| 50 | EXERCISE - Practice Exercise | |
| 51 | Practice Exercise files | |
| Formatting Worksheets | ||
| 52 | Formatting Cells I | |
| 53 | Formatting Cells II | |
| 54 | Formatting Numbers | |
| 55 | Borders and Shading | |
| 56 | Format as Table | |
| 57 | Using Styles | |
| 58 | Using Format Painter | |
| 59 | Protecting Sheets | |
| 60 | Using the Fill Handle and Custom Lists | |
| 61 | EXERCISE - Practice Exercise | |
| 62 | Practice Exercise files | |
| Charts | ||
| 63 | Creating Charts | |
| 64 | Types of Charts | |
| 65 | Editing Charts I | |
| 66 | Editing Charts II | |
| 67 | Using Graphics to Enhance Charts | |
| 68 | Linking Chart Titles | |
| 69 | EXERCISE - Practice Exercise | |
| 70 | Practice Exercise files | |
| Working with Names | ||
| 71 | Creating Range Names | |
| 72 | Managing Names | |
| 73 | Using Names in Formulas | |
| 74 | EXERCISE - Practice Exercise | |
| 75 | Practice Exercise files | |
| Sorting and Filtering | ||
| 76 | Removing Duplicates | |
| 77 | Sorting Data | |
| 78 | Filtering Data | |
| 79 | Advanced Filters | |
| 80 | EXERCISE - Practice Exercise | |
| 81 | Practice Exercise files | |
| Outlining and Subtotaling | ||
| 82 | Creating an Outline | |
| 83 | Subtotals | |
| 84 | EXERCISE - Practice Exercise | |
| 85 | Practice Exercise files | |
| Working with Views | ||
| 86 | Arranging Files | |
| 87 | New Window Option | |
| 88 | Custom Views | |
| 89 | EXERCISE - Practice Exercise | |
| 90 | Practice Exercise files | |
| Linking Files | ||
| 91 | Creating Formulas between files | |
| 92 | Working with Links | |
| 93 | Consolidating Data | |
| 94 | EXERCISE - Practice Exercise | |
| 95 | Practice Exercise files | |
| Advanced Formula Creation | ||
| 96 | Creating IF Statements | |
| 97 | VLookups | |
| 98 | Data Validation | |
| 99 | Formula Auditing | |
| 100 | EXERCISE - Practice Exercise | |
| 101 | Practice Exercise files | |
| Pivot Tables | ||
| 102 | Pivot Tables | |
| 103 | Pivot Charts | |
| 104 | EXERCISE - Practice Exercise | |
| 105 | Practice Exercise files | |
| Additional Excel Features | ||
| 106 | Slicers | |
| 107 | Goal Seeker | |
| 108 | Text to Columns | |
| 109 | Watch Window | |
| 110 | Customizing Ribbons and Tabs | |
| 111 | EXERCISE - Practice Exercise | |
| 112 | Practice Exercise files | |
| Shortcuts | ||
| 113 | Excel Shortcuts Every User should know | |
| Summary | ||
| 114 | Course Summary | |
Instructor
No Reviews Yet
2 Reviews
8 Students
2 Courses
President
Simon Sez IT makes business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks. We've been teaching online for over ten years.
It all started when the owner, Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.
More Courses by Simon Calder:
Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video tra...
Student Feedback
New Course - Not Enough Reviews Yet
Training 5 or more people?
Unlimited access for your entire SAP team including admin platform and premium reporting.SAP Training for Businesses
| Language: | English |
| Level: | Beginner |
| Duration: | 7.00 hours |
| Type: | Instructor-led |
| Release: | Enterprise Software |
| Category: | Business Productivity |
