Author
Dennis Taylor
Released
9/25/2018- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros
Skill Level Beginner
Duration
Views
- [Dennis] Being efficient at Excel is considered one of the most incredibly beneficial and indispensable skills that you can offer your team. Excel, being as widely used as it is, is vital to the functioning of most workplace environments. It provides an extensive set of features for managing and analyzing data. In my LinkedIn course I'll cover Excel's menu system, how to create formulas and use simple functions, how to format your data, how to use printing and charting capabilities of Excel and a lot more.
So join me, Dennis Taylor, as we get started with Excel 2019 Essential Training.
-
Introduction
-
1. Getting Started with Excel
-
What is Excel used for?1m 46s
-
Using Excel Help2m 10s
-
-
2. Entering Data
-
Using Undo and Redo4m 18s
-
Using Save or Save As3m 3s
-
3. Creating Formulas and Functions
-
Using simple formulas4m 24s
-
Using SUM and AVERAGE4m 42s
-
-
4. Formatting
-
5. Adjusting Worksheet Layout and Data
-
Rows and Columns5m 15s
-
-
6. Printing
-
7. Charts
-
Creating charts5m 7s
-
Exploring chart types5m 10s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. Data Management Features
-
Sorting data4m 38s
-
Using filters4m 39s
-
Creating PivotTables5m 13s
-
-
11. Security and Sharing
-
Sharing workbooks2m 57s
-
Tracking changes3m 54s
-
Conclusion
-
Next steps34s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Getting started with Excel