Linkedin - Excel 2019 Essential Training
Course details
Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more
1. Introduction/1. Getting started with Excel.mp4 4.11 MiB 10. Multiple Worksheets and Workbooks/1. Renaming inserting and deleting sheets.mp4 7.94 MiB 10. Multiple Worksheets and Workbooks/2. Moving copying and grouping sheets.mp4 9.93 MiB 11. Data Management Features/1. Sorting data.mp4 17.33 MiB 11. Data Management Features/2. Using filters.mp4 15.11 MiB 11. Data Management Features/3. Creating PivotTables.mp4 14.35 MiB 12. Security and Sharing/1. Protecting worksheets and workbooks.mp4 10.10 MiB 12. Security and Sharing/2. Sharing workbooks.mp4 8.79 MiB 12. Security and Sharing/3. Tracking changes.mp4 11.66 MiB 13. Conclusion/1. Next steps.mp4 1.48 MiB 2. Getting Started with Excel/1. What is Excel used for.mp4 4.60 MiB 2. Getting Started with Excel/2. Using the Quick Access Toolbar and Ribbon menu.mp4 7.81 MiB 2. Getting Started with Excel/3. Using shortcut menus and the mini toolbar.mp4 5.69 MiB 2. Getting Started with Excel/4. Understanding workbooks and worksheets.mp4 4.01 MiB 2. Getting Started with Excel/5. Using Excel Help.mp4 4.43 MiB 3. Entering Data/1. Exploring data entry editing and AutoFill.mp4 9.50 MiB 3. Entering Data/2. Working with dates and times.mp4 5.22 MiB 3. Entering Data/3. Using Undo and Redo.mp4 7.43 MiB 3. Entering Data/4. Using Save or Save As.mp4 5.73 MiB 4. Creating Formulas and Functions/1. Using simple formulas.mp4 7.62 MiB 4. Creating Formulas and Functions/2. Copying a formula into adjacent cells.mp4 4.58 MiB 4. Creating Formulas and Functions/3. Using SUM and AVERAGE.mp4 9.42 MiB 5. Formatting/1. Exploring font styles and effects.mp4 7.68 MiB 5. Formatting/2. Applying borders and color backgrounds.mp4 9.14 MiB 5. Formatting/3. Adjusting row heights and column widths.mp4 13.39 MiB 6. Adjusting Worksheet Layout and Data/1. Rows and Columns.mp4 21.41 MiB 6. Adjusting Worksheet Layout and Data/2. Moving copying and inserting data.mp4 11.83 MiB 6. Adjusting Worksheet Layout and Data/3. Finding and replacing data.mp4 11.48 MiB 7. Printing/1. Using the Page Layout view and commands.mp4 15.79 MiB 7. Printing/2. Using Page Break Preview and Print Setup Options.mp4 15.60 MiB 8. Charts/1. Creating charts.mp4 11.78 MiB 8. Charts/2. Exploring chart types.mp4 12.25 MiB 9. Adjusting Worksheet Views/1. Freezing and unfreezing panes.mp4 78.86 MiB 9. Adjusting Worksheet Views/2. Splitting screens horizontally and vertically.mp4 20.77 MiB Ex_Files_Excel_2019_EssT.zip 1.59 MiB Glossary_Excel2019EssentialTraining.zip 86.13 KiB