PLU | Excel 2019 Power Users (2019 EN)

Company: Pluralsight
Author: Bill Kulterman
Full Title: Excel 2019 Power Users
Year: 2019
Language: English
Genre: Educational: Spreadsheets
Skill Level: Intermediate
Price: -
-
Files: MP4
Time: 03:26:43
Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 450 kbps
Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



In Excel 2019 Power Users you’ll learn more advanced aspects of working with Excel 2019. Through this course you’ll learn how to format your data, work with workbooks and worksheets, print, begin work with tables, and use a few advanced functions.

Learn more advanced aspects of Excel 2019. In this course, Excel 2019 Power Users, you will take your knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes, and more. Next, you’ll discover how to work with workbooks, worksheets, and data. Then you’ll see more about printing workbooks (in whole or parts). Finally, you’ll explore a few advanced functions. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams.)


Lessons:
1. Formatting Data
01. Format Cells and Ranges
02. Adding a Fill Color
03. Adding Borders to Cells and Ranges
04. Merge Cells
05. Wrap Text within Cells
06. Modify Cell Alignment
07. Changing the Orientation
08. Format Cells by Using the Format Painter
09. Apply Cell Styles
10. Create and Modify Cell Styles
11. Change Workbook Themes
12. Create Custom Color Formats
13. Create and Modify Custom Themes
14. Insert Text Boxes
15. Insert Objects and Shapes
16. Insert Images
17. Modify Object Properties
18. Add Alternative Text to Objects
2. Working with Workbooks and Worksheets
19. Hide or Unhide Worksheets
20. Copy and Move a Worksheet
21. Change Worksheet Tab Color
22. Navigation Shortcuts
23. Change Magnification by Using Zoom Tools
24. Change Workbook Views
25. Change Window Views
26. Insert and Remove Hyperlinks
27. Save a Workbook as a Template
3. Working with Data
28. Import Data from a Delimited Text File
29. Using the Text to Columns Tool
4. Printing a Workbook
30. Working with Print Preview
31. Adjusting Margins
32. Changing Page Orientation
33. Insert Headers and Footers
34. Set a Print Area
35. Set Print Scaling
36. Display Repeating Row and Column Titles on Multipage Worksheets
37. Adding Page Breaks
38. Print All or Part of a Workbook
5. Working with Tables
39. Filter Records
40. Change Sort Order
41. Sort Data by Multiple Columns
42. Remove Duplicate Records
43. Create a Table from a Cell Range
44. Add or Remove Table Rows and Columns
45. Insert Total Rows
46. Apply Styles to Tables
47. Configure Table Style Options
48. Convert a Table To a Cell Range
49. Name Cells
50. Name Data Ranges
51. Name Tables
52. Manage Named Ranges and Objects
6. Working with Advanced Function
53. Look up Data by Using the VLOOKUP Function
54. Look up Data by Using the HLOOKUP Function
55. Look up Data by Using the MATCH Function
56. Look up Data by Using the INDEX Function

Our members see more. Join us!
-------------
Our members see more. Join us!