Microsoft Excel (Office 365 & 2021) Online Training

Focused View

Simona Millham

13:59:29

123 View

1. Get Started with Microsoft Excel.mp4

02:42

2. Find Your Way Around.mp4

05:57

3. Get Help.mp4

05:15

4. Spreadsheet Quick Start!.mp4

10:09

5. Save, AutoSave, and AutoRecover.mp4

11:27

6. Page Layout Options for Printing.mp4

12:37

7. Introduction.mp4

01:28

8. Work with Text.mp4

10:41

9. Use Borders, Fill Shading, and Cell Styles.mp4

09:29

10. Apply Number Formats.mp4

06:02

11. Create a Custom Number Format.mp4

11:18

12. Manage Rows and Columns.mp4

06:06

13. Set Up Multiple Sheets.mp4

08:19

14. Introduction.mp4

01:50

15. Basic Principles.mp4

10:45

16. Use the Mathematical Operators.mp4

10:42

17. Percentages.mp4

05:29

18. Absolute Cell References.mp4

07:18

19. Use Formulas Across Sheets.mp4

09:07

20. Introducing Functions.mp4

07:55

21. Introduction.mp4

01:00

22. Insert and Modify a Chart.mp4

11:03

23. Column, Bar, Line, and Area Charts.mp4

10:42

24. Pie, Pie of Pie, Bar of Pie, and Doughnut Charts.mp4

07:44

25. Treemap and Sunburst Charts.mp4

04:22

26. Histogram, Pareto, and Box-and-Whisker Charts.mp4

09:35

27. Scatter and Bubble Charts.mp4

04:19

28. Waterfall, Funnel, and Stock Charts.mp4

05:12

29. Surface and Radar Charts.mp4

03:54

30. Map Charts.mp4

03:12

31. Introduction.mp4

01:38

32. Navigate and Clean Up Your List.mp4

14:19

33. Sorting, Filtering, and Custom Views.mp4

08:33

34. Format as a Table.mp4

07:43

35. Grouping and Subtotals.mp4

06:48

36. Data Validation.mp4

12:58

37. Introduction.mp4

01:27

38. Insert and Format a PivotTable.mp4

12:19

39. Slicers, Timelines, and PivotCharts.mp4

10:28

40. Do More with PivotTables.mp4

12:21

41. Your PivotTable Challenge!.mp4

10:43

42. Introduction.mp4

02:08

43. Conditional Formatting.mp4

09:45

44. Sparklines.mp4

10:13

45. People Graph.mp4

03:22

46. Filled Map Charts or the Bing Maps Add-in.mp4

07:19

47. 3D Maps.mp4

10:29

48. Create a Dashboard.mp4

09:42

49. Introduction.mp4

01:29

50. Ensure Privacy, Accessibility, and Compatibility.mp4

08:54

51. Protect the File.mp4

08:05

52. Protect Parts of the Spreadsheet.mp4

07:06

53. Set Cloud Sharing Permissions.mp4

07:09

54. Edit Simultaneously with Co-Workers.mp4

11:16

55. Legacy Collaboration Tools.mp4

06:39

56. Introduction.mp4

02:57

57. Rounding.mp4

09:08

58. IF Functions.mp4

11:56

59. Lookups.mp4

16:13

60. Hiding Errors.mp4

04:16

61. Date Formulas.mp4

08:06

62. Text Functions.mp4

08:08

63. Introduction.mp4

01:13

64. Linear Forecasts.mp4

10:30

65. Forecasts with Seasonal Variation.mp4

11:16

66. Create a Forecast Sheet.mp4

07:42

67. Scenario Manager.mp4

09:02

68. Goal Seek and Solver.mp4

07:18

69. Data Tables.mp4

05:28

70. Introduction.mp4

03:32

71. Pictures and Graphics.mp4

09:04

72. Display a Picture Based on Cell Value.mp4

05:04

73. Shapes and Diagrams.mp4

14:27

74. Digital Ink.mp4

07:50

75. Themes.mp4

08:18

76. Introduction.mp4

01:14

77. Explore the Built-in Templates.mp4

11:23

78. Create Your Own Template.mp4

11:10

79. Share Templates.mp4

08:47

80. Set Defaults.mp4

08:00

81. Default Chart and Chart Templates.mp4

04:16

82. Customise the Excel Environment.mp4

06:52

83. Introduction.mp4

01:10

84. Use Excel Data in Other Office Applications.mp4

11:22

85. Manage Links.mp4

09:28

86. Basic Export Options.mp4

06:14

87. Connect to Data Sources with Power Query.mp4

11:31

88. Get Started with Power Pivot.mp4

14:09

89. Introduction.mp4

01:07

90. Worksheet Forms.mp4

13:49

91. Add a Macro Button.mp4

08:25

92. A First Look at Excel VBA.mp4

11:46

93. Create Your Own Function.mp4

09:23

94. Introducing Office Scripts.mp4

05:27

95. Introduction.mp4

00:51

96. Speed Up Data Entry.mp4

10:16

97. Navigation and Selection Shortcuts.mp4

07:57

98. Quick Tips for Formatting.mp4

09:42

99. Workarounds for Bulleted Lists.mp4

07:00

100. Options for Inserting Check Boxes.mp4

07:20

101. Charting Tips.mp4

04:37

102. Get Started.mp4

07:56

103. Enter Data and Apply Basic Formatting.mp4

10:17

104. Work with Formulas.mp4

08:07

105. Insert Charts and Graphs.mp4

04:46

106. Use Lists and PivotTables.mp4

13:18

107. Share and Collaborate.mp4

11:49

get_started_w_mic_excel.zip

Description

This intermediate Microsoft Excel (Office 365 & 2021) training teaches technical and non-technical professionals how to create spreadsheets in Excel that let you store data, manipulate data with formulas, and display data with graphs.

It's easy to see how useful a good spreadsheet can be. But it’s even easier to see how frustrating an ugly and confusing spreadsheet can be. When Microsoft Excel is in the hands of someone who knows what they're doing, it can be used as a powerful tool for productivity, collaboration, and storytelling.

More details

Be the Excel guru on your team â€” someone who can create work schedules. Plan out complex projects. Track the income and expenses for entire companies. Take raw numbers and tell a compelling story.

Once you're done with this Microsoft Excel skills training, you'll know how to create spreadsheets in Excel that let you store data, manipulate data with formulas, and display data with graphs.

For supervisors, this Microsoft Excel training can be used to onboard new technical and non-technical professionals, curated into individual or team training plans, or as a Microsoft Excel reference resource.

Microsoft Excel (Office 365 & 2021): What You Need to Know

This Microsoft Excel (Office 365 & 2021) training covers Excel topics including:

Opening, navigating, and using spreadsheets
Formatting cells to hold different types of information
Writing formulas that process your data for you
Using multiple sheets within the same spreadsheet
Graphing and visualizing your data

Who Should Take Microsoft Excel (Office 365 & 2021) Training?

This Microsoft Excel (Office 365 & 2021) training is considered foundational-level Excel training, which means it was designed for technical and non-technical professionals. This Excel skills course is designed for technical and non-technical professionals with three to five years of experience with Microsoft.

New or aspiring technical and non-technical professionals. A word to the wise: learn Excel early in your career. Nearly every organization relies on spreadsheets. The difference between those organizations is whether or not anyone knows what they're doing with them. Learn to format spreadsheets, store crucial information, and display interesting graphs with this Excel training.

Experienced technical and non-technical professionals. Thereâ€™s a difference between someone whoâ€™s been creating Excel spreadsheets for several years and someone whoâ€™s comfortable using all the bells and whistles Excel has to offer. Itâ€™s the difference between â€œjust another'' spreadsheet and a sophisticated presentation that can guide decision makers. Microsoft Excel training from CBT Nuggets allows you to level up your data analysis, visualization, and presentation skills.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Microsoft Office 365

Simona Millham

Instructor's Courses

My favorite thing about being a trainer is showing people those little tips, tricks, and workarounds to make their day-to-day work easier.

Simona has shared her passion for everything Microsoft Office-related since 1998. Simona was first drawn to Office because she enjoyed discovering all the features within programs such as Word and Excel. When she found herself spending more and more time training people how to use Office programs, she decided to pursue a career as a trainer. She was previously a Microsoft Certified Trainer. When she’s out of the office, Simona enjoys walking her dogs, playing the harp, yoga, and learning French and Spanish.

Certifications: Microsoft Office Master, Microsoft Certified Professional qualifications in Licensing and Software Asset Management, Office Specialist 2013, Office Specialist 2010

Areas of expertise: Microsoft Office

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.