Microsoft Excel 2019

Videos in this skill

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