Skill

Microsoft Excel 2019

April 2019 with Simona Millham

In this course, Simona Millham will teach you how to use Microsoft Excel 2019. You'll learn the fundamentals of functions, chart types, conditional formatting, pivot tables, and what-if analysis. You'll also gain an understanding of advanced topics, such as Power Query, Power Pivot, Power View, and more.

Learners who are new to using Microsoft Excel will benefit from working through this course from the beginning, while experienced learners may find it more advantageous to jump into the Nuggets they find most valuable.

Recommended Experience

Experience with previous versions of Microsoft Excel is recommended, but not required

Recommended Equipment

Microsoft Excel 2019

Related Certifications

None

Related Job Functions

Any

Simona Millham has been a CBT Nuggets trainer since 2015 and holds a variety of Microsoft certifications, including Microsoft Office Master, Microsoft Certified Professional qualifications in Licensing and Software Asset Management, Office Specialist 2013, and Office Specialist 2010.

Simona Millham — Simona Millham
Trainer

Videos in this skill

1. Course Introduction (3:08)
2. Finding Your Way Around (3:44)
3. Getting Help (3:54)
4. Spreadsheet Basics (10:14)
5. Working with Text (8:34)
6. Cell Formatting (6:51)
7. Applying Simple Number Formats (6:09)
8. Saving Files (5:04)
9. Creating Your First Excel Calculation (5:47)
10. Working with Formulas (11:26)
11. Page Layout Options for Printing (10:46)
12. Setting Up Multiple Sheets (7:29)
13. Using Formulas Across Sheets (8:18)
14. Introducing Functions (10:44)
15. Simona's Favourite Functions (13:32)
16. Text Functions and Flash Fill (11:32)
17. Simple Date and Time Calculations (8:13)
18. Forecasting (10:05)
19. Creating Your Own Function (6:09)
20. Entering Data with AutoFill (8:54)
21. Creating a Custom Number Format (10:04)
22. Getting Started with Charts (8:54)
23. Column, Bar, Line, and Area Charts (9:51)
24. Pie, Pie of Pie, Bar of Pie, and Doughnut Charts (7:24)
25. Treemap and Sunburst Charts (3:45)
26. Histogram, Pareto, and Box-and-Whisker Charts (8:34)
27. Scatter and Bubble Charts (5:01)
28. Waterfall, Funnel, and Stock Charts (4:46)
29. Surface and Radar Charts (4:55)
30. Map Charts (3:26)
31. Default Chart and Chart Templates (4:09)
32. Identifying Trends with Sparklines (7:59)
33. Data Visualisation with Conditional Formatting (6:22)
34. Creating Infographics with People Graph (3:22)
35. 3D Maps (11:56)
36. Reusing Excel Information (10:44)
37. Sharing Files (11:11)
38. Collaborating (10:38)
39. Protecting Excel Files (6:14)
40. Protecting Parts of Your Spreadsheet (7:09)
41. Lists and Tables (9:28)
42. Grouping and Subtotals (4:59)
43. Getting Started with PivotTables (10:56)
44. Doing More with PivotTables (12:05)
45. Data Validation (9:21)
46. Connecting to Data Sources (10:06)
47. Introducing Power Pivot (14:19)
48. Whatever Happened to Power View? (6:18)
49. Scenario Manager for What-If Analysis (5:59)
50. Goal Seek and Solver for What-If Analysis (4:32)
51. Data Tables for What-If Analysis (3:44)
52. Templates (7:47)
53. Setting Defaults (5:59)
54. Using Graphics on Your Spreadsheets (8:39)
55. Customising Your Workspace (8:57)
56. Worksheet Forms (9:44)
57. Automating Worksheet Tasks with Macros (7:27)
58. Introducing the Personal Macro Workbook and VBA (9:49)
59. Troubleshooting with Inquire (9:13)

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Get CBT Nuggets IT training news and resources

Email Address

I have read and understood the privacy policy and am able to consent to it.

Product

Solutions

Resources

Company

Support

Follow us

Let's chat!

Sales | Support | General

© 2023 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522