English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 8 Hours | 4.12 GB
Quickly learn how use Excel 2016 the right way and make your life easier and more productive in our complete course!
In today’s workplace, knowing how to use Excel has got to be the NUMBER ONE skill that everyone needs to have. Excel is easy to get started with and most people are just self taught, but do they really KNOW Excel? Are they using it the right way? Usually the answer is no and there is a lot of time being wasted.
This course can change all of that.
By learning Excel from the ground up, and learning the BEST, quickest way to do any given task, this is your opportunity to jump ahead of most people and become not just good with Excel, but AWESOME!
If you are willing to take the time to go through this course and do the exercises, you could easily be more proficient than most in just a few days from now!
This course is “hands on” and has exercise files for every lecture. This is not a course you just watch – you learn new techniques by doing them.
There is a HUGE need in the marketplace for people who REALLY know how to use Excel. This is your opportunity to break away from the pack of people who struggle to get their work done using Excel. Stop being like everyone else and and learn how to use Excel MUCH more effectively than just about anyone else!
Table of Contents
Welcome To Our Microsoft Excel 2016 Master Class Course – Beginner To Adanved
1 Bruce’s Introduction
2 Getting Started – How To Use This Course To Gain
Functions
3 Intro to the Quick Analysis Tool
4 More Functions
5 Multiple Criteria in an If Statement
6 Proper, Round and Other Functions
7 SUM – The Most Popular Function
8 The IF Function
9 VLookup 1 – Simple Example
10 VLookup 2 – Match Within a Range
11 Vlookup 3 – Intro to Data Validation Lists
12 Vlookup 3 – Multiple VLookups Using the Validation List
Formatting Worksheet Contents
13 Aligning of Cell Contents
14 Background Fill, Patterns and Effects
15 Basic Formatting
16 Borders
17 Conditional Formatting 1
18 Conditional Formatting 2
19 Custom Number Format Exercise
20 Custom Number Formats
21 Date Formats
22 Formatting Numbers
23 Time Formats
Table Filters and KEYBOARD SHORTCUTS
24 Format a Table and Use Filters
25 Using Data Slicers
Bringing It All Together PRINT Exercise
26 Create 6 Month Totals and Adjust Column Widths
27 Create Combined Name Column and Change Margins
28 Final Adjustments and Print Preview
29 Looking at the Task and Getting Started
30 Modify Print Titles and add Header and Footer
31 Use Quick Analysis and Angle Alignment on Titles
Payment Function and What If Analysis
32 Using 1 and 2 Variable Data Tables
33 Using GOAL SEEK
34 Using the PMT Function
35 Using the SCENARIO MANAGER
Finding and Fixing Errors
36 Evaluate Formulas
37 Fixing Circular References
38 Tracing Formula Precedents and Dependents
39 Using Error Checking
More on Working With Tables
40 Adding Records to a Table
41 Creating SubTotals
42 Removing Duplicate Records from a Table
43 Sorting Tables
44 Using a Form to Add Records
Protecting Your Work
45 Allowing Specific Commands on a Protected Sheet
46 Highlight Unlocked Cells
47 Protect the Worksheet
48 Protect Workbook – Encrypt with Password
49 Protect Workbook – Mark as Final
50 Protecting Workbook Structure
Pivot Tables
51 Change Display of Totals
52 Changing Pivot Table Appearance
53 Create a Pivot Table
54 Displaying and Printing Pivot Tables
55 Filtering Pivot Tables with Timelines
56 Multiple Pivot Table Columns and Rows
57 Pivot Table Filters
58 Recommended Pivot Tables
Viewing Large Worksheets and Multiple Workbooks
59 Freezing Panes and Split
60 Using the Watch Window
61 Viewing Multiple Workbooks
Worksheet Basics
62 Multiple Worksheets
63 Navigating Worksheets with Ctrl+Arrow Keys
64 Saving and Opening Files
65 The Parts of the Excel Screen
66 The Ribbon – How Does It Work
67 The Worksheet – What Is It
Working With Charts
68 Formatting and Modifying Charts 1
69 Formatting and Modifying Charts 2
70 Prepping Chart Data and Creating a Chart
71 Using Get & Transform to Create Sunburst and Treemap Charts
Conclusion
72 Want More Watch Our Special Bonus Lecture Continue Learning With Us Today
73 Course Summary and Conclusion! What Have We Learned In This Course
Manipulating Columns and Rows
74 Inserting, Deleting, Hiding and Unhiding Columns and Rows
75 Resizing Columns and Rows
Entering Data
76 Editing Data
77 Entering Dates
78 Entering Numbers
79 Entering Symbols
80 Entering Text
81 Excel Data Entry Helps
82 Undoing Changes
Selecting Cells and Ranges
83 Basic Selecting With The Keyboard
84 Basic Selecting With The Mouse
85 The Extend Key
Formulas
86 Basic Formulas
87 Formulas on Dates
88 Formulas with Text
89 Multi-Sheet Formulas
90 Rule of Order
Copying and Moving
91 Copy Cells or Ranges
92 Copy or Move Columns and Rows
93 Copying Formulas and Absolute References
94 Move Cells or Ranges
95 Move or Copy Sheets
96 Using the Clipboard Task Pane
The Fill Handle
97 Custom Fill Series
98 Fill Handle Basics
99 How to Use Fill Series
Naming Ranges
100 Multi-Sheet Range Names
101 Overview of Naming Ranges
102 Using Range Names Like Bookmarks
Conclusion
103 Course Summary and Conclusion! What Have We Learned In This Course
Resolve the captcha to access the links!