|
|
001 Introduction - What Youll Learn.mp4
|
MP4
|
19.2 MB
|
|
|
001 Test Your Knowledge.html
|
HTML
|
3.5 KB
|
|
|
002 How to Get the Most Out of This Course.mp4
|
MP4
|
14.4 MB
|
|
|
002 Test Your Knowledge.html
|
HTML
|
4.5 KB
|
|
|
003 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.mp4
|
MP4
|
31.9 MB
|
|
|
003 Test Your Knowledge.html
|
HTML
|
5.4 KB
|
|
|
004 Test Your Knowledge.html
|
HTML
|
5.2 KB
|
|
|
004 Using Excel Templates to Save Time and Effort.mp4
|
MP4
|
36.3 MB
|
|
|
005 Saving Your Document Where You Can Find It.mp4
|
MP4
|
7.1 MB
|
|
|
006 Entering Data and Navagating Around the Cells.mp4
|
MP4
|
7.6 MB
|
|
|
007 Creating Simple Formulas to Do Powerful Calculations.mp4
|
MP4
|
18.5 MB
|
|
|
008 Working with Workbooks and Worksheets.mp4
|
MP4
|
24.1 MB
|
|
|
009 Put Your Knowledge to Work - Create Your First Excel Document.html
|
HTML
|
921.6 B
|
|
|
010 Introduction - Creating and Formatting Your Heading.mp4
|
MP4
|
9 MB
|
|
|
011 Formatting Subheadings and Columns and Alphabetizings Lists.mp4
|
MP4
|
9.5 MB
|
|
|
012 Entering and Formatting Numbers.mp4
|
MP4
|
8 MB
|
|
|
013 Create Formulas to Quickly Calculate Your Costs.mp4
|
MP4
|
16.8 MB
|
|
|
014 Formatting - Grids and Spacing.mp4
|
MP4
|
10.7 MB
|
|
|
015 Introduction to Excel Formulas and Functions.mp4
|
MP4
|
11.2 MB
|
|
|
016 What is a Formula and What Can It DO for You.mp4
|
MP4
|
4.1 MB
|
|
|
017 What is a Function and What Does IT Do.mp4
|
MP4
|
23.3 MB
|
|
|
018 The Anatomy of a Formula.mp4
|
MP4
|
15.9 MB
|
|
|
019 Quickly Select Cells to Use in Your Formula.mp4
|
MP4
|
11.6 MB
|
|
|
020 Absolute vs. Relative Cell References.mp4
|
MP4
|
15.2 MB
|
|
|
021 How to Use the Downloads to Learn Functions Faster.mp4
|
MP4
|
13.8 MB
|
|
|
022 AVERAGE and AVERAGEA Functions.mp4
|
MP4
|
6.3 MB
|
|
|
023 COUNT COUNTA and COUNTBLANK Functions.mp4
|
MP4
|
10.7 MB
|
|
|
024 IF Functions.mp4
|
MP4
|
24.8 MB
|
|
|
025 SUMIF and SUMIFS Functions.mp4
|
MP4
|
17.7 MB
|
|
|
026 COUNTIF and COUNTIFS Functions.mp4
|
MP4
|
12.3 MB
|
|
|
027 VLOOKUP Function.mp4
|
MP4
|
39.2 MB
|
|
|
028 LEFT RIGHT and MID Functions.mp4
|
MP4
|
22.6 MB
|
|
|
029 CONCATENATE - Combining Text.mp4
|
MP4
|
11.5 MB
|
|
|
030 LEN - Length of Text.mp4
|
MP4
|
6.9 MB
|
|
|
031 FIND and SEARCH.mp4
|
MP4
|
8.5 MB
|
|
|
032 MIN and MAX.mp4
|
MP4
|
11.7 MB
|
|
|
033 AND and OR.mp4
|
MP4
|
15.9 MB
|
|
|
034 ROUND CEILING and FLOOR.mp4
|
MP4
|
29.9 MB
|
|
|
035 Conditional Formatting.mp4
|
MP4
|
30.7 MB
|
|
|
036 Charts Download.html
|
HTML
|
614.4 B
|
|
|
037 Introduction - How to Create a Chart.mp4
|
MP4
|
21.7 MB
|
|
|
038 Format Your Chart.mp4
|
MP4
|
19.2 MB
|
|
|
039 Create a Bar Chart.mp4
|
MP4
|
19.8 MB
|
|
|
040 Create a Pie Chart.mp4
|
MP4
|
31.1 MB
|
|
|
041 Create a Line Chart.mp4
|
MP4
|
18.6 MB
|
|
|
042 Pivot Tables Download.html
|
HTML
|
409.6 B
|
|
|
043 Introduction to Pivot Tables - Preparing Your Data.mp4
|
MP4
|
35.6 MB
|
|
|
044 How to Create a Pivot Table.mp4
|
MP4
|
47 MB
|
|
|
045 Put Your Pivot Table to Work.mp4
|
MP4
|
50.2 MB
|
|
|
046 Pivot Charts Download.html
|
HTML
|
512 B
|
|
|
047 Pivot Charts.mp4
|
MP4
|
27.5 MB
|
|
|
048 Whats New in Excel 2016.mp4
|
MP4
|
20.7 MB
|
|
|
049 6 New Chart Types for 2016.mp4
|
MP4
|
27 MB
|
|
|
050 Tell Me What You Want To Do - The New Help Feature.mp4
|
MP4
|
9.6 MB
|
|
|
051 1-Click Forecasting.mp4
|
MP4
|
22.3 MB
|
|
|
052 3D Maps.mp4
|
MP4
|
53.3 MB
|
|
|
053 Saving as CSV Text and PDF.mp4
|
MP4
|
43.2 MB
|
|
|
054 Saving Backups of Your Excel Files.mp4
|
MP4
|
9.1 MB
|
|
|
055 Using the AutoRecover Feature.mp4
|
MP4
|
20.1 MB
|
|
|
056 Import from Web CopyPaste and Cleaning Up Data.mp4
|
MP4
|
21.9 MB
|
|
|
057 Import from CSV file and Excel Workbook.mp4
|
MP4
|
24 MB
|
|
|
058 Import from Access Database.mp4
|
MP4
|
21.8 MB
|
|
|
059 Print Your Excel Document.mp4
|
MP4
|
14.3 MB
|
|
|
060 Excel Keyboard Shortcuts.mp4
|
MP4
|
25.7 MB
|
|
|
061 ALT Key Shortcuts.mp4
|
MP4
|
11.5 MB
|
|
|
062 TEXT.mp4
|
MP4
|
14.7 MB
|
|
|
063 REPT - Repeat.mp4
|
MP4
|
14.1 MB
|
|
|
064 UPPER LOWER and PROPER.mp4
|
MP4
|
6.7 MB
|
|
|
065 TRIM - Remove Extra Spaces.mp4
|
MP4
|
14.6 MB
|
|
|
066 Combining LEFT MID FIND and TRIM.mp4
|
MP4
|
23.3 MB
|
|
|
067 HYPERLINK - Create a Table of Contents for Your Worksheets.mp4
|
MP4
|
18.6 MB
|
|
|
068 RAND and RANDBETWEEN - Random Numbers.mp4
|
MP4
|
3.9 MB
|
|
|
069 ROUND.mp4
|
MP4
|
6.9 MB
|
|
|
070 INT - Integer.mp4
|
MP4
|
5.5 MB
|
|
|
071 MOD - Remainder.mp4
|
MP4
|
4.4 MB
|
|
|
072 DATE and DATEVALUE.mp4
|
MP4
|
14.8 MB
|
|
|
073 TIME.mp4
|
MP4
|
7.4 MB
|
|
|
074 TODAY and NOW.mp4
|
MP4
|
4.7 MB
|
|
|
075 YEAR MONTH DAY HOUR MINUTE and SECOND.mp4
|
MP4
|
7.2 MB
|
|
|
076 WEEKDAY and WEEKNUM.mp4
|
MP4
|
6 MB
|
|
|
077 IFERROR.mp4
|
MP4
|
7.6 MB
|
|
|
078 LARGE and SMALL.mp4
|
MP4
|
12.6 MB
|
|
|
079 INDEX and MATCH.mp4
|
MP4
|
24 MB
|
|
|
080 Nested INDEX MATCH IF and IFERROR.mp4
|
MP4
|
9.1 MB
|
|
|
081 Nested IF AND and OR Functions.mp4
|
MP4
|
14.1 MB
|
|
|
082 Record Your First Macro.mp4
|
MP4
|
28.6 MB
|
|
|
083 Saving Your Macro and Security.mp4
|
MP4
|
12.4 MB
|
|
|
084 Use a Macro to Create a Template.mp4
|
MP4
|
13 MB
|
|
|
085 How to Use Relative Cell References.mp4
|
MP4
|
47.1 MB
|
|
|
086 Easy Cell-Formatting Macro.mp4
|
MP4
|
15.4 MB
|
|
|
087 Intro - The Complete Walk-Through.mp4
|
MP4
|
12.4 MB
|
|
|
088 File Menu - The Complete Walk-Through.mp4
|
MP4
|
48.3 MB
|
|
|
089 Home Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
59.5 MB
|
|
|
090 Home Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
49.1 MB
|
|
|
091 Insert Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
51.3 MB
|
|
|
092 Insert Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
67.5 MB
|
|
|
093 Insert Tab part 3 - The Complete Walk-Through.mp4
|
MP4
|
69 MB
|
|
|
094 Page Layout Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
63.3 MB
|
|
|
095 Page Layout Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
14.1 MB
|
|
|
096 Formulas Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
38 MB
|
|
|
097 Formulas Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
32.8 MB
|
|
|
098 Data Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
51.4 MB
|
|
|
099 Data Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
26.2 MB
|
|
|
100 Data Tab part 3 - The Complete Walk-Through.mp4
|
MP4
|
60.9 MB
|
|
|
101 Review Tab - The Complete Walk-Through.mp4
|
MP4
|
54.6 MB
|
|
|
102 View Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
36.2 MB
|
|
|
103 View Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
71.9 MB
|
|
|
104 Developer Tab part 1 - The Complete Walk-Through.mp4
|
MP4
|
32.6 MB
|
|
|
105 Developer Tab part 2 - The Complete Walk-Through.mp4
|
MP4
|
24.5 MB
|
|
|
106 Conclusion.mp4
|
MP4
|
12.6 MB
|
|
|
DATE-and-DATEVALUE-Download.xlsx
|
XLSX
|
10.7 KB
|
|
|
Excel-2016-AND-OR-Download.xlsx
|
XLSX
|
12.2 KB
|
|
|
Excel-2016-CONDITIONAL-FORMATTING-Download.xlsx
|
XLSX
|
13.1 KB
|
|
|
Excel-2016-Charts-Download.xlsx
|
XLSX
|
35.7 KB
|
|
|
Excel-2016-Concatenate-Download.xlsx
|
XLSX
|
9.7 KB
|
|
|
Excel-2016-Find-and-Search-Download.xlsx
|
XLSX
|
9.6 KB
|
|
|
Excel-2016-IF-Function-Download.xlsx
|
XLSX
|
10 KB
|
|
|
Excel-2016-LEN-Download.xlsx
|
XLSX
|
9.3 KB
|
|
|
Excel-2016-Min-Max-Download.xlsx
|
XLSX
|
11.9 KB
|
|
|
Excel-2016-Pivot-CHARTS-Download.xlsx
|
XLSX
|
21.4 KB
|
|
|
Excel-2016-Pivot-Tables-Download-REVISED.xlsx
|
XLSX
|
20.8 KB
|
|
|
Excel-2016-ROUND-download.xlsx
|
XLSX
|
10.9 KB
|
|
|
Excel-2016-VLOOKUP-Download.xlsx
|
XLSX
|
12.7 KB
|
|
|
Excel-Shortcut-Keys-List.pdf
|
PDF
|
288.4 KB
|
|
|
INDEX-MATCH-Download.xlsx
|
XLSX
|
10.3 KB
|
|
|
INT-Function-Download.xlsx
|
XLSX
|
8.1 KB
|
|
|
LEFT-and-MID-Function-Download.xlsx
|
XLSX
|
9.6 KB
|
|
|
MOD-Function-Download.xlsx
|
XLSX
|
8.5 KB
|
|
|
Nested-IF-AND-and-OR-Download.xlsx
|
XLSX
|
8.8 KB
|
|
|
Nested-INDEX-MATCH-IF-and-IFERROR-Download.xlsx
|
XLSX
|
11.4 KB
|
|
|
Read Me.txt
|
TXT
|
102.4 B
|
|
|
TIME-Download.xlsx
|
XLSX
|
10.6 KB
|
|
|
TRIM-Function-Download.xlsx
|
XLSX
|
9.6 KB
|
|
|
Torrent_downloaded_from_Demonoid_-_www.demonoid.pw_.txt
|
TXT
|
102.4 B
|
|
|
TutsGalaxy.com.txt
|
TXT
|
0 B
|
|
|
WEEKDAY-WEEKNUM-Download.xlsx
|
XLSX
|
8.6 KB
|
