Excel 2019 Power Users

Focused View

Bill Kulterman

3:26:43

156 View

1 - Formatting Data

01 - Format Cells and Ranges.mp4

03:49

02 - Adding a Fill Color.mp4

01:44

03 - Adding Borders to Cells and Ranges.mp4

03:05

04 - Merge Cells.mp4

01:18

05 - Wrap Text within Cells.mp4

01:40

06 - Modify Cell Alignment .mp4

03:06

07 - Changing the Orientation.mp4

01:36

08 - Format Cells by Using the Format Painter.mp4

04:28

09 - Apply Cell Styles.mp4

04:23

10 - Create and Modify Cell Styles.mp4

05:14

11 - Change Workbook Themes.mp4

04:01

12 - Create Custom Color Formats.mp4

05:16

13 - Create and Modify Custom Themes.mp4

02:37

14 - Insert Text Boxes.mp4

02:37

15 - Insert Objects and Shapes.mp4

04:33

16 - Insert Images.mp4

02:34

17 - Modify Object Properties.mp4

03:46

18 - Add Alternative Text to Objects.mp4

04:56

2 - Working with Workbooks and Worksheets

19 - Hide or Unhide Worksheets.mp4

01:20

20 - Copy and Move a Worksheet.mp4

04:44

21 - Change Worksheet Tab Color.mp4

01:37

22 - Navigation Shortcuts.mp4

02:48

23 - Change Magnification by Using Zoom Tools.mp4

03:13

24 - Change Workbook Views.mp4

04:19

25 - Change Window Views.mp4

05:31

26 - Insert and Remove Hyperlinks.mp4

06:28

27 - Save a Workbook as a Template.mp4

03:30

3 - Working with Data

28 - Import Data from a Delimited Text File.mp4

04:58

29 - Using the Text to Columns Tool.mp4

03:15

4 - Printing a Workbook

30 - Working with Print Preview.mp4

02:28

31 - Adjusting Margins.mp4

02:55

32 - Changing Page Orientation.mp4

01:25

33 - Insert Headers and Footers.mp4

03:09

34 - Set a Print Area.mp4

02:04

35 - Set Print Scaling.mp4

02:59

36 - Display Repeating Row and Column Titles on Multipage Worksheets.mp4

01:54

37 - Adding Page Breaks.mp4

05:57

38 - Print All or Part of a Workbook.mp4

04:45

5 - Working with Tables

39 - Filter Records.mp4

05:18

40 - Change Sort Order.mp4

03:55

41 - Sort Data by Multiple Columns.mp4

04:32

42 - Remove Duplicate Records.mp4

04:16

43 - Create a Table from a Cell Range.mp4

03:28

44 - Add or Remove Table Rows and Columns.mp4

03:42

45 - Insert Total Rows.mp4

01:48

46 - Apply Styles to Tables.mp4

02:04

47 - Configure Table Style Options.mp4

02:10

48 - Convert a Table To a Cell Range.mp4

02:12

49 - Name Cells.mp4

04:00

50 - Name Data Ranges.mp4

03:01

51 - Name Tables.mp4

02:22

52 - Manage Named Ranges and Objects.mp4

06:15

6 - Working with Advanced Function

53 - Look up Data by Using the VLOOKUP Function.mp4

09:20

54 - Look up Data by Using the HLOOKUP Function.mp4

05:30

55 - Look up Data by Using the MATCH Function.mp4

05:27

56 - Look up Data by Using the INDEX Function.mp4

07:21

Description

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.

What You'll Learn?

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.)

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Excel Analytics

Excel Dashboard

Excel Modeling

Excel Formulas and Functions

Excel Macros

Excel Charts

Excel Shortcuts and Tips

Bill Kulterman

Instructor's Courses

I am an E-Learning Author. With over 15 years’ experience as a trainer, coupled with a lifelong enthusiasm of technology and software applications, I have a unique perspective in creating courseware that is intuitive and retainable. The last several years I have focused solely on SharePoint creating over two dozen courses on the subject. From my home in Chicago, I collaborate with experts from around the globe to author courseware solutions.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.