Excel 2019 Pro
Focused View
Bill Kulterman
5:20:36
48 View
01 - Create Custom Number Formats.mp4
05:18
02 - Apply International Currency Formats.mp4
02:34
03 - Display Data in Multiple International Formats.mp4
02:34
04 - Outline Data.mp4
03:57
05 - Insert Subtotals.mp4
02:51
06 - Insert References.mp4
04:24
07 - Reference Data in Another Workbook.mp4
03:12
08 - Reference Data by Using Structured References.mp4
03:19
09 - Consolidate Data.mp4
04:11
10 - Configure Data Validation.mp4
05:54
11 - Import, Transform, and Connect to Data.mp4
08:49
12 - Combine and Display Data.mp4
06:20
13 - Format Text by Using RIGHT, LEFT, and MID Functions.mp4
03:14
14 - Format Text by Using UPPER, LOWER, and PROPER Functions.mp4
02:27
15 - Format Text by Using the CONCAT Function.mp4
02:23
16 - Perform Logical Operations by Using the IF Function.mp4
02:35
17 - Perform Logical Operations by Using the SUMIF Function.mp4
04:11
18 - Perform Logical Operations by Using the AVERAGEIF Function.mp4
03:58
19 - Perform Statistical Operations by Using the COUNTIF Function.mp4
01:27
20 - Perform Statistical Operations by Using the SUMIFS Function.mp4
04:12
21 - Perform Statistical Operations by Using the AVERAGEIFS Function.mp4
03:01
22 - Perform Statistical Operations by Using the COUNTIFS Function.mp4
02:38
23 - Perform Logical Operations by Using AND, OR, and NOT Functions.mp4
04:02
24 - Perform Logical Operations by Using Nested Functions.mp4
07:14
25 - Reference the Date and Time by Using the NOW and TODAY Functions.mp4
06:16
26 - Serialize Numbers by Using DATE and TIME Functions.mp4
07:00
27 - Perform What-if Analysis by Using Goal Seek.mp4
03:59
28 - Perform What-if Analysis by Using Scenario Manager.mp4
06:46
29 - Calculate Data by Using Financial Functions - PMT.mp4
03:35
30 - Calculate Data by Using Financial Functions - PPMT & IPMT.mp4
08:53
31 - Calculate Data by Using Financial Functions - FV.mp4
04:21
32 - Display Formulas.mp4
02:05
33 - Trace Precedence and Dependence.mp4
04:35
34 - Evaluate Formulas.mp4
02:17
35 - Validate Formulas by Using Error Checking Rules.mp4
04:18
36 - Monitor Cells and Formulas by Using the Watch Window.mp4
03:19
37 - Apply Conditional Formatting.mp4
05:58
38 - Create Custom Conditional Formatting Rules.mp4
04:59
39 - Create Conditional Formatting Rules That Use Formulas.mp4
06:01
40 - Manage Conditional Formatting Rules.mp4
03:47
41 - Insert Sparklines.mp4
05:24
42 - Create a New Chart.mp4
03:27
43 - Add Additional Data Series.mp4
04:21
44 - Switch Between Rows and Columns in Source Data.mp4
01:23
45 - Analyze Data by Using Quick Analysis.mp4
03:29
46 - Resize Charts.mp4
02:04
47 - Move Charts to a Chart Sheet.mp4
02:13
48 - Add and Modify Chart Elements.mp4
05:39
49 - Apply Chart Layouts.mp4
02:26
50 - Apply Chart Styles.mp4
03:34
51 - Add Trendlines to Charts.mp4
04:12
52 - Create Dual-axis Charts.mp4
03:46
53 - Save a Chart as a Template.mp4
02:40
54 - Create Pivot Tables.mp4
06:03
55 - Modify Field Selections and Options.mp4
05:03
56 - Create Slicers.mp4
03:29
57 - Group Pivot Table Data.mp4
03:27
58 - Format Pivot Table Data.mp4
03:10
59 - Add Additional Fields.mp4
04:00
60 - Add Calculated Fields.mp4
04:35
61 - Drill down into PivotTable Details.mp4
02:20
62 - Use Cube Functions to Get Data out of the Excel Data Model.mp4
06:33
63 - Create Pivot Charts.mp4
03:22
64 - Manipulate Options in Existing Pivot Charts.mp4
03:33
65 - Apply Styles to Pivot Charts.mp4
02:14
66 - Drill down into Pivot Chart Details.mp4
02:39
67 - Display Hidden Ribbon Tabs.mp4
05:04
68 - Configure Formula Calculation Options.mp4
04:18
69 - Inspect a Workbook for Hidden Properties or Personal Information.mp4
03:48
70 - Inspect a Workbook for Accessibility Issues.mp4
03:16
71 - Inspect a Workbook for Compatibility Issues.mp4
03:06
72 - Restrict Editing.mp4
04:41
73 - Protect Workbook Structure.mp4
02:13
74 - Encrypt a Workbook with a Password.mp4
01:43
75 - Manage Workbook Versions.mp4
02:50
76 - Create a Simple Macro.mp4
05:50
77 - Modify a Simple Macro.mp4
02:23
78 - Save and Enable Macros in a Workbook.mp4
02:19
79 - Copy Macros Between Workbooks.mp4
02:43
80 - Create a Macro Button.mp4
01:50
81 - Insert and Configure Form Controls.mp4
06:32
Description
In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019.
What You'll Learn?
Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll learn how to format and work with data. Then, you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros, and form controls. When you’re finished with this course, you'll 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
Focused display
Bill Kulterman
Instructor's CoursesI 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 PluralsightPluralsight, 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.
- language english
- Training sessions 81
- duration 5:20:36
- level advanced
- Release Date 2023/10/11
