|
/Week 4/
|
|
Practice Video- Protecting Workbooks and Worksheets - Macquarie University - Coursera.webm
|
41.3 MB
|
|
Practice Video- Error Checking - Macquarie University - Coursera.webm
|
39.4 MB
|
|
Practice Video- Evaluate Formula, Watch Window - Macquarie University - Coursera.webm
|
29.1 MB
|
|
Practice Video- Formula Calculation Options - Macquarie University - Coursera.webm
|
22.3 MB
|
|
Practice Video- Trace Precedents and Dependents - Macquarie University - Coursera.webm
|
29.2 MB
|
|
/Week 1/
|
|
Practice Video- Documentation - Macquarie University - Coursera.webm
|
34.8 MB
|
|
Practice Video- Formatting - Macquarie University - Coursera.webm
|
36.1 MB
|
|
Practice Video- Interface and Navigation - Macquarie University - Coursera.webm
|
40.4 MB
|
|
Practice Video- Spreadsheet Design Principles - Macquarie University - Coursera.webm
|
40.1 MB
|
|
Practice Video- Calculations - Macquarie University - Coursera.webm
|
39.9 MB
|
|
/Week 1/Advanced---Week-1/
|
|
house.gif
|
36.7 KB
|
|
unit.gif
|
47.1 KB
|
|
W1 Calculations Soln.xlsx
|
1.4 MB
|
|
W1 Calculations.xlsx
|
1.1 MB
|
|
W1 Design and Structure Soln.xlsx
|
1.1 MB
|
|
W1 Design and Structure.xlsx
|
1.1 MB
|
|
W1 Documenting Soln.xlsx
|
2.4 MB
|
|
W1 Documenting.xlsx
|
2.4 MB
|
|
W1 Formatting.xlsx
|
2.3 MB
|
|
W1 UI and Navigation Soln.xlsx
|
2.4 MB
|
|
W1 UI and Navigation.xlsx
|
2.4 MB
|
|
/Week 1/Advanced---Week-1/__MACOSX/
|
|
._W1 Design and Structure.xlsx
|
0.2 KB
|
|
._W1 Documenting.xlsx
|
0.2 KB
|
|
._W1 Formatting.xlsx
|
0.2 KB
|
|
._W1 UI and Navigation.xlsx
|
0.2 KB
|
|
/Week 1/Challenges/
|
|
C4-W1-Final-Assessment.xlsx
|
64.7 KB
|
|
instruction & ans.docx
|
73.8 KB
|
|
model pic.png
|
35.5 KB
|
|
/Week 2/
|
|
Practice Video- Introduction to Array Formulas - Macquarie University - Coursera.webm
|
15.3 MB
|
|
Practice Video- Solving Problems with Array Formulas - Macquarie University - Coursera.webm
|
14.0 MB
|
|
Practice Video- Tables and Structured Referencing - Macquarie University - Coursera.webm
|
29.8 MB
|
|
Practice Video- Using Functions to Sort Data - Macquarie University - Coursera.webm
|
17.9 MB
|
|
Practice Video- Working with an Array Function (TRANSPOSE) - Macquarie University - Coursera.webm
|
11.6 MB
|
|
/Week 2/Advanced---Week-2/
|
|
W2 Array Functions Intro.xlsx
|
587.6 KB
|
|
W2 Arrays for Solving Problems Soln.xlsx
|
590.0 KB
|
|
W2 Arrays for Solving Problems.xlsx
|
589.9 KB
|
|
W2 Sort using Functions.xlsx
|
588.3 KB
|
|
W2 Structured Referencing.xlsx
|
584.5 KB
|
|
W2 Transpose.xlsx
|
588.1 KB
|
|
/Week 2/Challenges/
|
|
C4-W2-Practice-Challenge-Soln.xlsx
|
82.6 KB
|
|
C4-W2-Practice-Challenge.xlsx
|
77.4 KB
|
|
/Week 3/
|
|
Practice Video- Diagnostic Tools (ISNUMBER, LEN, CODE) - Macquarie University - Coursera.webm
|
22.9 MB
|
|
Practice Video- Fix Dates (DATE, MONTH, YEAR, DAY, TEXT) - Macquarie University - Coursera.webm
|
18.5 MB
|
|
Practice Video- Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE) - Macquarie University - Coursera.webm
|
19.7 MB
|
|
Practice Video- Remove Unwanted Spaces (TRIM, CLEAN) - Macquarie University - Coursera.webm
|
16.9 MB
|
|
Practice Video- Replace blanks with repeating values - Macquarie University - Coursera.webm
|
26.9 MB
|
|
/Week 3/Advanced---Week-3/
|
|
W3 Diagnostic Tools Solution.xlsx
|
129.9 KB
|
|
W3 Diagnostic Tools.xlsx
|
121.3 KB
|
|
W3 Fix Dates Solution.xlsx
|
100.6 KB
|
|
W3 Fix Dates.xlsx
|
94.0 KB
|
|
W3 Remove Unwanted Characters Solution.xlsx
|
131.7 KB
|
|
W3 Remove Unwanted Characters.xlsx
|
114.6 KB
|
|
W3 Replacing Blanks Soln.xlsx
|
95.4 KB
|
|
W3 Replacing Blanks.xlsx
|
48.4 KB
|
|
W3 Trim and Clean.xlsx
|
100.8 KB
|
|
/Week 3/Advanced---Week-3/__MACOSX/
|
|
._W3 Remove Unwanted Characters.xlsx
|
0.2 KB
|
|
/Week 3/Challenges/
|
|
C4-W3-Practice-Challenge.xlsx
|
75.3 KB
|
|
C4.W3-Practice-Ch-Solution-Behnaz.xlsx
|
94.6 KB
|
|
/Week 4/
|
|
Practice Video- Depreciation Functions (SLN, SYD, DDB) - Macquarie University - Coursera.webm
|
17.7 MB
|
|
Practice Video- Financial Functions (FV, PV, PMT) - Macquarie University - Coursera.webm
|
19.0 MB
|
|
Practice Video- Loan Schedule (PMT, EDATE) - Macquarie University - Coursera.webm
|
22.8 MB
|
|
Practice Video- Net Present Value and Internal Rate of Return (NPV, IRR) - Macquarie University - Coursera.webm
|
16.3 MB
|
|
Practice Video- Working with Dates (EOMONTH, EDATE, WORKDAY.INTL) - Macquarie University - Coursera.webm
|
16.5 MB
|
|
/Week 4/Advanced---Week-4/
|
|
W4 Date Functions Soln.xlsx
|
13.8 KB
|
|
W4 Date Functions.xlsx
|
14.7 KB
|
|
W4 Depreciation Functions Soln.xlsx
|
19.6 KB
|
|
W4 Depreciation Functions.xlsx
|
18.7 KB
|
|
W4 Intro Financial Functions Soln.xlsx
|
22.7 KB
|
|
W4 Intro Financial Functions.xlsx
|
22.1 KB
|
|
W4 Loan Schedule Soln.xlsx
|
32.2 KB
|
|
W4 Loan Schedule.xlsx
|
18.1 KB
|
|
W4 NPV and IRR Soln.xlsx
|
12.1 KB
|
|
W4 NPV and IRR.xlsx
|
11.9 KB
|
|
/Week 4/Challenges/
|
|
C4-W4-Final-Assessment.xlsx
|
69.7 KB
|
|
Chalange question and Ans.docx
|
42.9 KB
|
|
/Week 5/
|
|
Practice Video- ADDRESS - Macquarie University - Coursera.webm
|
15.3 MB
|
|
Practice Video- INDIRECT - Macquarie University - Coursera.webm
|
22.7 MB
|
|
Practice Video- Introduction to OFFSET - Macquarie University - Coursera.webm
|
20.0 MB
|
|
Practice Video- Solving Problems with OFFSET - Macquarie University - Coursera.webm
|
37.6 MB
|
|
/Week 5/Advanced---Week-5/
|
|
W5 ADDRESS Solution.xlsx
|
314.5 KB
|
|
W5 ADDRESS.xlsx
|
314.3 KB
|
|
W5 INDIRECT Solution.xlsx
|
304.1 KB
|
|
W5 INDIRECT.xlsx
|
303.9 KB
|
|
W5 OFFSET Intro Solution.xlsx
|
315.6 KB
|
|
W5 OFFSET Intro.xlsx
|
315.5 KB
|
|
W5 OFFSET using Arrays Solution.xlsx
|
322.1 KB
|
|
W5 OFFSET using Arrays.xlsx
|
315.8 KB
|
|
/Week 5/Challenges/
|
|
C4-W5-Final-Assessment.xlsx
|
125.9 KB
|
|
Question & Ans.docx
|
26.8 KB
|
|
/Week 6/
|
|
C4-Final-Assignment-v2.xlsx
|
98.6 KB
|
|
Practice Video- Construct Dashboard - Macquarie University - Coursera.webm
|
25.0 MB
|
|
Practice Video- Creative Charting - Macquarie University - Coursera.webm
|
27.7 MB
|
|
Practice Video- Dashboard Design - Macquarie University - Coursera.webm
|
18.2 MB
|
|
Practice Video- Interactive Dashboard - Macquarie University - Coursera.webm
|
21.7 MB
|
|
Practice Video- Prepare Data - Macquarie University - Coursera.webm
|
28.0 MB
|
|
/Week 6/Advanced-Week-6/
|
|
W6 Construct Dashboard.xlsx
|
14.3 MB
|
|
W6 Creative Charting.xlsx
|
14.3 MB
|
|
W6 Dashboard Design.xlsx
|
13.6 MB
|
|
W6 Data Preparation.xlsx
|
13.6 MB
|
|
W6 Interactive Dash Soln.xlsx
|
14.4 MB
|
|
W6 Interactive Dash.xlsx
|
14.3 MB
|
|
/Week 6/Challenges/
|
|
C4-Final-Assignment-v2.xlsx
|
98.6 KB
|
|
Questions & Ans.docx
|
63.8 KB
|
|
/Week 1/
|
|
Practice Video- Data Entry, Data Types, Editing and Deleting - Macquarie University - Coursera.webm
|
12.7 MB
|
|
Practice Video- Fill Handle - Macquarie University - Coursera.webm
|
15.7 MB
|
|
Practice Video- Fill Handle - Macquarie University - Coursera_2.webm
|
15.7 MB
|
|
Practice Video- Navigating and Selecting - Macquarie University - Coursera.webm
|
23.1 MB
|
|
Practice Video- Taking Charge of Excel - Macquarie University - Coursera.webm
|
26.9 MB
|
|
Practice Video- View Options - Macquarie University - Coursera.webm
|
33.4 MB
|
|
/Week 1/Chalanges/
|
|
W01-Challenge-1.xlsx
|
219.7 KB
|
|
/Week 1/Essentials---Week-1/__MACOSX/
|
|
._Week 1
|
0.2 KB
|
|
/Week 1/Essentials---Week-1/__MACOSX/Week 1/
|
|
._W01-V01 Take charge.xlsx
|
0.8 KB
|
|
._W01-V02-Select and Navigate.xlsx
|
0.8 KB
|
|
._W01-V03 Change View Options.xlsx
|
0.8 KB
|
|
._W01-V04-Enter Data.xlsx
|
0.9 KB
|
|
._W01-V05-Fill Handle Soln.xlsx
|
0.9 KB
|
|
._W01-V05-Fill Handle.xlsx
|
0.9 KB
|
|
/Week 1/Essentials---Week-1/Week 1/
|
|
W01-V01 Take charge.xlsx
|
215.6 KB
|
|
W01-V02-Select and Navigate.xlsx
|
200.6 KB
|
|
W01-V03 Change View Options.xlsx
|
200.7 KB
|
|
W01-V04-Enter Data.xlsx
|
8.8 KB
|
|
W01-V05-Fill Handle Soln.xlsx
|
11.3 KB
|
|
W01-V05-Fill Handle.xlsx
|
10.7 KB
|
|
/Week 2/
|
|
Excel Options - Macquarie University - Coursera.webm
|
11.9 MB
|
|
Practice Video- Absolute Cell References - Macquarie University - Coursera.webm
|
12.4 MB
|
|
Practice Video- Calculations across sheets - Macquarie University - Coursera.webm
|
14.2 MB
|
|
Practice Video- Formulas - Macquarie University - Coursera.webm
|
6.6 MB
|
|
Practice Video- Formulas in Context - Macquarie University - Coursera.webm
|
17.6 MB
|
|
Practice Video- Functions I- SUM and AUTOSUM - Macquarie University - Coursera.webm
|
15.6 MB
|
|
Practice Video- Functions II- AVERAGE, MIN and MAX - Macquarie University - Coursera.webm
|
17.3 MB
|
|
/Week 2/Challenges/
|
|
random-name.xlsx
|
10.7 KB
|
|
W01-Assessment.xlsx
|
202.3 KB
|
|
W02_Assessment.xlsx
|
10.6 KB
|
|
W02_Challenge01-Solution.xlsx
|
62.0 KB
|
|
W02_Challenge01.xlsx
|
61.4 KB
|
|
W02_Challenge02.xlsx
|
75.1 KB
|
|
W02_Challenge03-Solution.xlsx
|
72.9 KB
|
|
W02_Challenge03.xlsx
|
72.3 KB
|
|
Word-Search.xlsx
|
11.9 KB
|
|
/Week 2/Essentials---Week-2/Week 2/
|
|
W02-V01-Simple Formulas Soln.xlsx
|
9.3 KB
|
|
W02-V01-Simple Formulas.xlsx
|
9.0 KB
|
|
W02-V02-Formulas in Business Soln.xlsx
|
218.7 KB
|
|
W02-V02-Formulas in Business.xlsx
|
154.6 KB
|
|
W02-V03-Basic Functions Soln.xlsx
|
219.5 KB
|
|
W02-V03-Basic Functions.xlsx
|
219.1 KB
|
|
W02-V04-Average Max Min Soln.xlsx
|
220.0 KB
|
|
W02-V04-Average Max Min.xlsx
|
219.5 KB
|
|
W02-V05-Absolute Cell Refs Soln.xlsx
|
220.4 KB
|
|
W02-V05-Absolute Cell Refs.xlsx
|
220.2 KB
|
|
W02-V06-Calculate Across Sheets Soln.xlsx
|
226.1 KB
|
|
W02-V06-Calculate Across Sheets.xlsx
|
225.0 KB
|
|
/Week 3/
|
|
Graphics - Macquarie University - Coursera.webm
|
14.0 MB
|
|
Practice Video- Alignment Tools - Macquarie University - Coursera.webm
|
16.0 MB
|
|
Practice Video- Borders - Macquarie University - Coursera.webm
|
20.7 MB
|
|
Practice Video- Format Painter - Macquarie University - Coursera.webm
|
15.4 MB
|
|
Practice Video- Formatting - Macquarie University - Coursera.webm
|
14.2 MB
|
|
Practice Video- Number Formats - Macquarie University - Coursera.webm
|
24.8 MB
|
|
Practice Video- Styles and Themes - Macquarie University - Coursera.webm
|
22.4 MB
|
|
/Week 3/Challenges/
|
|
W03-Assessment.xlsx
|
14.8 KB
|
|
W03_Challenge01.xlsx
|
106.0 KB
|
|
/Week 3/Essentials---Week-3/Week 3/
|
|
W03-V01 Font Formatting Soln.xlsx
|
226.2 KB
|
|
W03-V01 Font Formatting.xlsx
|
226.1 KB
|
|
W03-V02 Borders Soln.xlsx
|
226.5 KB
|
|
W03-V02 Borders.xlsx
|
226.2 KB
|
|
W03-V03-Alignment Soln.xlsx
|
226.3 KB
|
|
W03-V03-Alignment.xlsx
|
226.2 KB
|
|
W03-V04-Format Painter Soln.xlsx
|
226.4 KB
|
|
W03-V04-Format Painter.xlsx
|
226.4 KB
|
|
W03-V05-Number Formats Soln.xlsx
|
226.6 KB
|
|
W03-V05-Number Formats.xlsx
|
226.5 KB
|
|
W03-V06-Styles and Themes Soln.xlsx
|
785.5 KB
|
|
W03-V06-Styles and Themes.xlsx
|
226.7 KB
|
|
/Week 4/
|
|
Accessibility - Macquarie University - Coursera.webm
|
9.4 MB
|
|
Practice Video- Conditional Formatting - Macquarie University - Coursera.webm
|
23.7 MB
|
|
Practice Video- Filtering - Macquarie University - Coursera.webm
|
38.9 MB
|
|
Practice Video- Find and Replace - Macquarie University - Coursera.webm
|
18.9 MB
|
|
Practice Video- Managing Rows and Columns - Macquarie University - Coursera.webm
|
22.5 MB
|
|
Practice Video- Sorting - Macquarie University - Coursera.webm
|
17.9 MB
|
|
/Week 4/Challenges/
|
|
W04-Challenge-1.xlsx
|
103.3 KB
|
|
W04_Challenge01-Solution.xlsx
|
120.8 KB
|
|
/Week 4/Essentials---Week-4/__MACOSX/
|
|
._Week 4
|
0.2 KB
|
|
/Week 4/Essentials---Week-4/__MACOSX/Week 4/
|
|
._W04-V01-Work with Data.xlsx
|
0.9 KB
|
|
._W04-V02-Work with Data.xlsx
|
0.9 KB
|
|
._W04-V03-Work with Data.xlsx
|
0.9 KB
|
|
._W04-V04-Work with Data.xlsx
|
0.8 KB
|
|
._W04-V05 Conditional Formatting.xlsx
|
0.9 KB
|
|
/Week 4/Essentials---Week-4/Week 4/
|
|
W04-V01-Work with Data.xlsx
|
200.9 KB
|
|
W04-V02-Work with Data.xlsx
|
200.9 KB
|
|
W04-V03-Work with Data.xlsx
|
200.9 KB
|
|
W04-V04-Work with Data.xlsx
|
200.9 KB
|
|
W04-V05 Conditional Formatting.xlsx
|
200.9 KB
|
|
/Week 5/
|
|
Practice Video- Headers and Footers - Macquarie University - Coursera.webm
|
18.0 MB
|
|
Practice Video- Orientation, Margins and Scale - Macquarie University - Coursera.webm
|
22.3 MB
|
|
Practice Video- Page Breaks - Macquarie University - Coursera.webm
|
29.2 MB
|
|
Practice Video- Print Preview - Macquarie University - Coursera.webm
|
11.3 MB
|
|
Practice Video- Print Titles - Macquarie University - Coursera.webm
|
16.7 MB
|
|
Save Options - Macquarie University - Coursera.webm
|
10.0 MB
|
|
/Week 5/Challanges/
|
|
W05-Challenge-1.xlsx
|
100.2 KB
|
|
/Week 5/Essentials---Week-5/
|
|
pushpin-logo.jpg
|
8.1 KB
|
|
W05-V01-Print Preview.xlsx
|
230.6 KB
|
|
W05-V02-Print Options.xlsx
|
230.6 KB
|
|
W05-V03 - Page Breaks.xlsx
|
249.3 KB
|
|
W05-V04 - Print Title.xlsx
|
232.1 KB
|
|
W05-V05 - Headers and Footers Soln.xlsx
|
247.0 KB
|
|
W05-V05 - Headers and Footers.xlsx
|
232.2 KB
|
|
/Week 5/Essentials---Week-5/__MACOSX/
|
|
._pushpin-logo.jpg
|
1.2 KB
|
|
._W05-V01-Print Preview.xlsx
|
0.9 KB
|
|
._W05-V02-Print Options.xlsx
|
0.9 KB
|
|
._W05-V03 - Page Breaks.xlsx
|
0.8 KB
|
|
._W05-V04 - Print Title.xlsx
|
0.9 KB
|
|
._W05-V05 - Headers and Footers Soln.xlsx
|
0.9 KB
|
|
._W05-V05 - Headers and Footers.xlsx
|
0.8 KB
|
|
/Week 6/
|
|
Practice Video- Basic Chart Types- Pie, Column and Line Charts - Macquarie University - Coursera.webm
|
22.1 MB
|
|
Practice Video- Change Chart Style & Type - Macquarie University - Coursera.webm
|
8.1 MB
|
|
Practice Video- Modify Chart Elements - Macquarie University - Coursera.webm
|
10.1 MB
|
|
Practice Video- Move and Resize Charts - Macquarie University - Coursera.webm
|
17.4 MB
|
|
Sharing Charts - Macquarie University - Coursera.webm
|
9.3 MB
|
|
/Week 6/Challenges/
|
|
W06-Challenge-1.xlsx
|
399.6 KB
|
|
/Week 6/Essentials---Week-6/
|
|
W06-V01 Basic Chart Types.xlsx
|
221.7 KB
|
|
W06-V02 Move and Resize.xlsx
|
253.8 KB
|
|
W06-V03 Change Styles and Type.xlsx
|
257.0 KB
|
|
W06-V04 Modify Chart Elements.xlsx
|
256.7 KB
|
|
/Week 6/Essentials---Week-6/__MACOSX/
|
|
._W06-V01 Basic Chart Types.xlsx
|
0.9 KB
|
|
._W06-V02 Move and Resize.xlsx
|
0.9 KB
|
|
._W06-V03 Change Styles and Type.xlsx
|
0.9 KB
|
|
._W06-V04 Modify Chart Elements.xlsx
|
0.9 KB
|
|
/Week 1/
|
|
Practice Video- 3D Formulas - Macquarie University - Coursera.webm
|
16.1 MB
|
|
Practice Video- Consolidating by Category (Reference) - Macquarie University - Coursera.webm
|
21.8 MB
|
|
Practice Video- Consolidating by Position - Macquarie University - Coursera.webm
|
23.9 MB
|
|
Practice Video- Linking Workbooks - Macquarie University - Coursera.webm
|
25.9 MB
|
|
Practice Video- Multiple Worksheets - Macquarie University - Coursera.webm
|
16.1 MB
|
|
/Week 1/Challanges/Ch-1/
|
|
challenge instr.PNG
|
71.6 KB
|
|
PracticeChallenge_Manly.xlsx
|
28.3 KB
|
|
W1_PracticeChallenge_Avalon.xlsx
|
28.3 KB
|
|
W1_PracticeChallenge_Bondi.xlsx
|
30.5 KB
|
|
W1_PracticeChallenge_Bondi_Soln.xlsx
|
29.3 KB
|
|
W1_PracticeChallenge_HeadOffice.xlsx
|
12.3 KB
|
|
W1_PracticeChallenge_HeadOffice_Soln.xlsx
|
16.0 KB
|
|
/Week 1/Challanges/Ch-2/
|
|
Help-Desk-April-Summary.xlsx
|
9.1 KB
|
|
Help-Desk-June.xlsx
|
35.9 KB
|
|
Help-Desk-May.xlsx
|
35.8 KB
|
|
instr.PNG
|
60.8 KB
|
|
W1_AdvPracticeChallenge.xlsx
|
13.0 KB
|
|
W1_AdvPracticeChallenge_Solution.xlsx
|
17.8 KB
|
|
/Week 1/Intermediate-I---Week-1/__MACOSX/
|
|
._Week 1
|
0.2 KB
|
|
/Week 1/Intermediate-I---Week-1/__MACOSX/Week 1/
|
|
._.DS_Store
|
0.1 KB
|
|
._W1-V4 Consolidating by Position
|
0.2 KB
|
|
._W1-V5 Consolidating by Reference
|
0.2 KB
|
|
._W1_V1 MultipleWorksheets Soln.xlsx
|
0.3 KB
|
|
._W1_V1 MultipleWorksheets.xlsx
|
0.9 KB
|
|
._W1_V2 3DFormulas Soln.xlsx
|
0.3 KB
|
|
._W1_V2 3DFormulas.xlsx
|
0.9 KB
|
|
/.../W1-V3 Linking Workbooks/
|
|
._W1_ExpensesQ1.xlsx
|
0.9 KB
|
|
._W1_ExpensesQ2.xlsx
|
0.9 KB
|
|
._W1_ExpensesQ3.xlsx
|
0.9 KB
|
|
._W1_LinkingWorkbooks Soln.xlsx
|
0.3 KB
|
|
._W1_LinkingWorkbooks.xlsx
|
0.9 KB
|
|
/.../W1-V4 Consolidating by Position/
|
|
._W1_Consolidate1.xlsx
|
0.9 KB
|
|
._W1_Consolidate1Soln.xlsx
|
0.9 KB
|
|
._W1_ExpensesMelbourne.xlsx
|
0.9 KB
|
|
._W1_ExpensesPerth.xlsx
|
0.9 KB
|
|
._W1_ExpensesSydney.xlsx
|
0.9 KB
|
|
/.../W1-V5 Consolidating by Reference/
|
|
._W1_Consolidate2.xlsx
|
0.9 KB
|
|
._W1_Consolidate2_Soln.xlsx
|
0.9 KB
|
|
._W1_LeaveDaysMelbourne.xlsx
|
0.9 KB
|
|
._W1_LeaveDaysPerth.xlsx
|
0.9 KB
|
|
._W1_LeaveDaysSydney.xlsx
|
0.9 KB
|
|
/Week 1/Intermediate-I---Week-1/Week 1/
|
|
.DS_Store
|
6.1 KB
|
|
W1_V1 MultipleWorksheets Soln.xlsx
|
24.3 KB
|
|
W1_V1 MultipleWorksheets.xlsx
|
21.1 KB
|
|
W1_V2 3DFormulas Soln.xlsx
|
24.4 KB
|
|
W1_V2 3DFormulas.xlsx
|
23.7 KB
|
|
/.../W1-V3 Linking Workbooks/
|
|
W1_ExpensesQ1.xlsx
|
21.4 KB
|
|
W1_ExpensesQ2.xlsx
|
24.2 KB
|
|
W1_ExpensesQ3.xlsx
|
24.3 KB
|
|
W1_LinkingWorkbooks Soln.xlsx
|
18.9 KB
|
|
W1_LinkingWorkbooks.xlsx
|
14.8 KB
|
|
/.../W1-V4 Consolidating by Position/
|
|
W1_Consolidate1.xlsx
|
14.5 KB
|
|
W1_Consolidate1Soln.xlsx
|
27.3 KB
|
|
W1_ExpensesMelbourne.xlsx
|
15.3 KB
|
|
W1_ExpensesPerth.xlsx
|
15.4 KB
|
|
W1_ExpensesSydney.xlsx
|
15.3 KB
|
|
/.../W1-V5 Consolidating by Reference/
|
|
W1_Consolidate2.xlsx
|
13.8 KB
|
|
W1_Consolidate2_Soln.xlsx
|
14.3 KB
|
|
W1_LeaveDaysMelbourne.xlsx
|
13.7 KB
|
|
W1_LeaveDaysPerth.xlsx
|
13.6 KB
|
|
W1_LeaveDaysSydney.xlsx
|
13.7 KB
|
|
/Week 2/
|
|
Practice Video- Changing Text Case (UPPER, LOWER, PROPER) - Macquarie University - Coursera.webm
|
16.8 MB
|
|
Practice Video- Combining Text (CONCAT, &) - Macquarie University - Coursera.webm
|
16.5 MB
|
|
Practice Video- Date Calculations (NOW, TODAY, YEARFRAC) - Macquarie University - Coursera.webm
|
14.8 MB
|
|
Practice Video- Extracting Text (LEFT, MID, RIGHT) - Macquarie University - Coursera.webm
|
11.6 MB
|
|
Practice Video- Finding Text (FIND) - Macquarie University - Coursera.webm
|
15.7 MB
|
|
/Week 2/Challanges/
|
|
C2-W2-Practice-Challenge-Solution.xlsx
|
94.8 KB
|
|
C2-W2-Practice-Challenge.xlsx
|
90.4 KB
|
|
/Week 2/Intermediate-I---Week-2/__MACOSX/
|
|
._Week 2
|
0.2 KB
|
|
/Week 2/Intermediate-I---Week-2/__MACOSX/Week 2/
|
|
._W2_V1 Combining_Text.xlsx.xlsx
|
0.9 KB
|
|
._W2_V2 Changing_Case.xlsx
|
0.9 KB
|
|
._W2_V3 Extracting_Text.xlsx
|
0.9 KB
|
|
._W2_V4 Find.xlsx
|
0.9 KB
|
|
._W2_V5 Date_Functions.xlsx
|
0.9 KB
|
|
/Week 2/Intermediate-I---Week-2/Week 2/
|
|
W2_V1 Combining_Text.xlsx.xlsx
|
12.9 KB
|
|
W2_V2 Changing_Case.xlsx
|
14.5 KB
|
|
W2_V3 Extracting_Text.xlsx
|
14.6 KB
|
|
W2_V4 Find.xlsx
|
15.4 KB
|
|
W2_V5 Date_Functions.xlsx
|
15.7 KB
|
|
/Week 3/
|
|
Practice Video- Apply Names - Macquarie University - Coursera.webm
|
28.9 MB
|
|
Practice Video- Creating Named Ranges - Macquarie University - Coursera.webm
|
22.4 MB
|
|
Practice Video- Introducing Named Ranges - Macquarie University - Coursera.webm
|
19.7 MB
|
|
Practice Video- Managing Named Ranges - Macquarie University - Coursera.webm
|
20.0 MB
|
|
Practice Video- Named Ranges in Formulas - Macquarie University - Coursera.webm
|
16.6 MB
|
|
/Week 3/Challanges/
|
|
C2-W3-Practice-Challenge-Solution.xlsx
|
78.8 KB
|
|
C2-W3-Practice-Challenge.xlsx
|
74.4 KB
|
|
/Week 3/Intermediate-I---Week-3/__MACOSX/
|
|
._Week 3
|
0.2 KB
|
|
/Week 3/Intermediate-I---Week-3/__MACOSX/Week 3/
|
|
._W3_V1 IntroNamedRanges Soln.xlsx
|
0.9 KB
|
|
._W3_V1 IntroNamedRanges.xlsx
|
0.9 KB
|
|
._W3_V2 CreateNamedRanges Soln.xlsx
|
0.9 KB
|
|
._W3_V2 CreateNamedRanges.xlsx
|
0.9 KB
|
|
._W3_V3 ManageNamedRanges Soln.xlsx
|
0.9 KB
|
|
._W3_V3 ManageNamedRanges.xlsx
|
0.9 KB
|
|
._W3_V4 NamedRangesInFormulas Soln.xlsx
|
0.9 KB
|
|
._W3_V4 NamedRangesInFormulas.xlsx
|
0.9 KB
|
|
._W3_V5 ApplyNames Soln.xlsx
|
0.9 KB
|
|
._W3_V5 ApplyNames.xlsx
|
0.9 KB
|
|
/Week 3/Intermediate-I---Week-3/Week 3/
|
|
W3_V1 IntroNamedRanges Soln.xlsx
|
17.5 KB
|
|
W3_V1 IntroNamedRanges.xlsx
|
17.0 KB
|
|
W3_V2 CreateNamedRanges Soln.xlsx
|
17.8 KB
|
|
W3_V2 CreateNamedRanges.xlsx
|
17.5 KB
|
|
W3_V3 ManageNamedRanges Soln.xlsx
|
17.8 KB
|
|
W3_V3 ManageNamedRanges.xlsx
|
17.7 KB
|
|
W3_V4 NamedRangesInFormulas Soln.xlsx
|
18.4 KB
|
|
W3_V4 NamedRangesInFormulas.xlsx
|
18.0 KB
|
|
W3_V5 ApplyNames Soln.xlsx
|
19.8 KB
|
|
W3_V5 ApplyNames.xlsx
|
18.4 KB
|
|
/Week 4/
|
|
Practice Video- Adding with Criteria (SUMIFS) - Macquarie University - Coursera.webm
|
15.7 MB
|
|
Practice Video- Advanced Charting - Macquarie University - Coursera.webm
|
14.1 MB
|
|
Practice Video- COUNT functions - Macquarie University - Coursera.webm
|
17.2 MB
|
|
Practice Video- Counting with Criteria (COUNTIFS) - Macquarie University - Coursera.webm
|
13.4 MB
|
|
Practice Video- Sparklines - Macquarie University - Coursera.webm
|
17.0 MB
|
|
Practice Video- Trendlines - Macquarie University - Coursera.webm
|
11.8 MB
|
|
/Week 4/Challanges/
|
|
C2-W4-Practice-Challenge-Solution.xlsx
|
119.9 KB
|
|
C2-W4-Practice-Challenge.xlsx
|
96.2 KB
|
|
/Week 4/Intermediate-I---Week-4/__MACOSX/
|
|
._Week 4
|
0.2 KB
|
|
/Week 4/Intermediate-I---Week-4/__MACOSX/Week 4/
|
|
._.DS_Store
|
0.1 KB
|
|
._W4_V1 COUNT_Functions.xlsx
|
0.9 KB
|
|
._W4_V2 COUNTIFS.xlsx
|
0.9 KB
|
|
._W4_V3 SUMIFS.xlsx
|
0.9 KB
|
|
._W4_V4 Sparklines.xlsx
|
0.9 KB
|
|
._W4_V5 AdvancedCharting Soln.xlsx
|
0.9 KB
|
|
._W4_V5 AdvancedCharting.xlsx
|
0.9 KB
|
|
/.../W4_V6 Trendlines/
|
|
._W4_V6 TrendLines Examples.xlsx
|
0.9 KB
|
|
._W4_V6 TrendLines Soln.xlsx
|
0.9 KB
|
|
._W4_V6 TrendLines.xlsx
|
0.9 KB
|
|
/Week 4/Intermediate-I---Week-4/Week 4/
|
|
.DS_Store
|
6.1 KB
|
|
W4_V1 COUNT_Functions.xlsx
|
244.6 KB
|
|
W4_V2 COUNTIFS.xlsx
|
244.7 KB
|
|
W4_V3 SUMIFS.xlsx
|
244.8 KB
|
|
W4_V4 Sparklines.xlsx
|
246.2 KB
|
|
W4_V5 AdvancedCharting Soln.xlsx
|
251.4 KB
|
|
W4_V5 AdvancedCharting.xlsx
|
246.7 KB
|
|
/.../W4_V6 Trendlines/
|
|
W4_V6 TrendLines Examples.xlsx
|
195.7 KB
|
|
W4_V6 TrendLines Soln.xlsx
|
389.0 KB
|
|
W4_V6 TrendLines.xlsx
|
251.9 KB
|
|
/Week 5/
|
|
Practice Video- Automation with Tables - Macquarie University - Coursera.webm
|
20.9 MB
|
|
Practice Video- Converting to Range and Subtotaling - Macquarie University - Coursera.webm
|
30.7 MB
|
|
Practice Video- Creating and Formatting Tables - Macquarie University - Coursera.webm
|
24.5 MB
|
|
Practice Video- Sorting and Filtering in Tables - Macquarie University - Coursera.webm
|
32.8 MB
|
|
Practice Video- Working with Tables - Macquarie University - Coursera.webm
|
21.7 MB
|
|
/Week 5/Challanges/
|
|
C2-W5-Practice-Challenge-Solution.xlsx
|
132.1 KB
|
|
C2-W5-Practice-Challenge.xlsx
|
82.6 KB
|
|
/Week 5/Intermediate-I---Week-5/__MACOSX/
|
|
._Week 5
|
0.2 KB
|
|
/Week 5/Intermediate-I---Week-5/__MACOSX/Week 5/
|
|
._W5_V1 Tables.xlsx
|
0.9 KB
|
|
._W5_V2 WorkingWithTables2.xlsx
|
0.9 KB
|
|
._W5_V3 SortingAndFiltering.xlsx
|
0.9 KB
|
|
._W5_V4 Automation.xlsx
|
0.9 KB
|
|
._W5_V5 ConvertAndSubtotal.xlsx
|
0.9 KB
|
|
/Week 5/Intermediate-I---Week-5/Week 5/
|
|
W5_V1 Tables.xlsx
|
28.2 KB
|
|
W5_V2 WorkingWithTables2.xlsx
|
44.1 KB
|
|
W5_V3 SortingAndFiltering.xlsx
|
31.1 KB
|
|
W5_V4 Automation.xlsx
|
30.7 KB
|
|
W5_V5 ConvertAndSubtotal.xlsx
|
31.6 KB
|
|
/Week 6/
|
|
Practice Video- Creating and Modifying a Pivot Table - Macquarie University - Coursera.webm
|
22.0 MB
|
|
Practice Video- Pivoting Charts - Macquarie University - Coursera.webm
|
20.3 MB
|
|
Practice Video- Pivoting Slicers - Macquarie University - Coursera.webm
|
16.0 MB
|
|
Practice Video- Reporting Filter Pages - Macquarie University - Coursera.webm
|
18.4 MB
|
|
Practice Video- Sorting and Filtering a Pivot Table - Macquarie University - Coursera.webm
|
17.5 MB
|
|
Practice Video- Value Field Settings - Macquarie University - Coursera.webm
|
17.7 MB
|
|
/Week 6/Challanges/
|
|
C2-W6-Practice-Challenge-Solution.xlsx
|
137.4 KB
|
|
C2-W6-Practice-Challenge.xlsx
|
98.4 KB
|
|
/Week 6/Intermediate-I---Week-6/Week 6/
|
|
W6_V1 CreatePivotTables Soln.xlsx
|
368.2 KB
|
|
W6_V1 CreatePivotTables.xlsx
|
256.8 KB
|
|
W6_V2 ModifyPivotTables Soln.xlsx
|
367.5 KB
|
|
W6_V2 ModifyPivotTables.xlsx
|
368.2 KB
|
|
W6_V3 GroupSortFilter Soln.xlsx
|
370.1 KB
|
|
W6_V3 GroupSortFilter.xlsx
|
368.8 KB
|
|
W6_V4 ReportFilters Soln.xlsx
|
354.3 KB
|
|
W6_V4 ReportFilters.xlsx
|
370.4 KB
|
|
W6_V5 PivotCharts Soln.xlsx
|
365.1 KB
|
|
W6_V5 PivotCharts.xlsx
|
354.3 KB
|
|
W6_V6 Slicers.xlsx
|
366.2 KB
|
|
W6_V6 Slicers_Soln.xlsx
|
369.2 KB
|
|
/Week 1/
|
|
Practice Video- Advanced Conditional Formatting - Macquarie University - Coursera.webm
|
23.7 MB
|
|
Practice Video- Creating Drop-down Lists - Macquarie University - Coursera.webm
|
28.0 MB
|
|
Practice Video- Data Validation - Macquarie University - Coursera.webm
|
29.4 MB
|
|
Practice Video- Using Formulas in Data Validation - Macquarie University - Coursera.webm
|
30.3 MB
|
|
Practice Video- Working with Data Validation - Macquarie University - Coursera.webm
|
34.0 MB
|
|
/Week 1/Challenges/
|
|
C3-W1-Practice-Challenge-Solution.xlsx
|
96.2 KB
|
|
C3-W1-Practice-Challenge.xlsx
|
92.1 KB
|
|
/.../Intermediate-II---Week-1/__MACOSX/Week 1/
|
|
._.DS_Store
|
0.1 KB
|
|
._W1_V1 DataValidation.xlsx
|
0.9 KB
|
|
._W1_V2 DropDownLists Soln.xlsx
|
0.9 KB
|
|
._W1_V2 DropDownLists.xlsx
|
0.9 KB
|
|
._W1_V3 FormulasInDataValidation Soln.xlsx
|
0.9 KB
|
|
._W1_V3 FormulasInDataValidation.xlsx
|
0.9 KB
|
|
._W1_V4 WorkingWithValidation Soln.xlsx
|
0.9 KB
|
|
._W1_V4 WorkingWithValidation.xlsx
|
0.9 KB
|
|
._W1_V5 AdvancedConditionalFormatting Soln.xlsx
|
0.9 KB
|
|
._W1_V5 AdvancedConditionalFormatting.xlsx
|
0.9 KB
|
|
/.../Intermediate-II---Week-1/Week 1/
|
|
.DS_Store
|
6.1 KB
|
|
W1_V1 DataValidation.xlsx
|
16.7 KB
|
|
W1_V2 DropDownLists Soln.xlsx
|
18.0 KB
|
|
W1_V2 DropDownLists.xlsx
|
17.0 KB
|
|
W1_V3 FormulasInDataValidation Soln.xlsx
|
19.0 KB
|
|
W1_V3 FormulasInDataValidation.xlsx
|
18.8 KB
|
|
W1_V4 WorkingWithValidation Soln.xlsx
|
19.0 KB
|
|
W1_V4 WorkingWithValidation.xlsx
|
18.9 KB
|
|
W1_V5 AdvancedConditionalFormatting Soln.xlsx
|
19.3 KB
|
|
W1_V5 AdvancedConditionalFormatting.xlsx
|
19.0 KB
|
|
/Week 2/
|
|
Practice Video- Combining Logical Functions I- IF, AND, OR - Macquarie University - Coursera.webm
|
14.6 MB
|
|
Practice Video- Combining Logical Functions II- Nested IFs - Macquarie University - Coursera.webm
|
16.7 MB
|
|
Practice Video- Handling Errors- IFERROR, IFNA - Macquarie University - Coursera.webm
|
18.4 MB
|
|
Practice Video- Logical Functions I- IF - Macquarie University - Coursera.webm
|
19.8 MB
|
|
Practice Video- Logical Functions II- AND, OR - Macquarie University - Coursera.webm
|
18.1 MB
|
|
/Week 2/Challenges/
|
|
C3-W2-Practice-Challenge-Solution.xlsx
|
72.9 KB
|
|
C3-W2-Practice-Challenge.xlsx
|
71.6 KB
|
|
/.../Intermediate-II---Week-2/__MACOSX/Week 2/
|
|
._W2_V1 IF Soln.xlsx
|
0.9 KB
|
|
._W2_V1 IF.xlsx
|
0.9 KB
|
|
._W2_V2 ANDandOR Soln.xlsx
|
0.9 KB
|
|
._W2_V2 ANDandOR.xlsx
|
0.9 KB
|
|
._W2_V3 IFwithANDandOR Soln.xlsx
|
0.9 KB
|
|
._W2_V3 IFwithANDandOR.xlsx
|
0.9 KB
|
|
._W2_V4 NestedIF Soln.xlsx
|
0.9 KB
|
|
._W2_V4 NestedIF.xlsx
|
0.9 KB
|
|
._W2_V5 IFERROR Soln.xlsx
|
0.9 KB
|
|
._W2_V5 IFERROR.xlsx
|
0.9 KB
|
|
/.../Intermediate-II---Week-2/Week 2/
|
|
W2_V1 IF Soln.xlsx
|
111.4 KB
|
|
W2_V1 IF.xlsx
|
99.9 KB
|
|
W2_V2 ANDandOR Soln.xlsx
|
117.5 KB
|
|
W2_V2 ANDandOR.xlsx
|
111.2 KB
|
|
W2_V3 IFwithANDandOR Soln.xlsx
|
117.1 KB
|
|
W2_V3 IFwithANDandOR.xlsx
|
117.5 KB
|
|
W2_V4 NestedIF Soln.xlsx
|
123.0 KB
|
|
W2_V4 NestedIF.xlsx
|
117.0 KB
|
|
W2_V5 IFERROR Soln.xlsx
|
129.7 KB
|
|
W2_V5 IFERROR.xlsx
|
123.3 KB
|
|
/Week 3/
|
|
Practice Video- Approximate Matches- Range VLOOKUP - Macquarie University - Coursera.webm
|
16.4 MB
|
|
Practice Video- Dynamic Lookups- INDEX, MATCH - Macquarie University - Coursera.webm
|
19.5 MB
|
|
Practice Video- Exact Matches- Exact Match VLOOKUP - Macquarie University - Coursera.webm
|
23.4 MB
|
|
Practice Video- Finding a Position- MATCH - Macquarie University - Coursera.webm
|
22.5 MB
|
|
Practice Video- Introduction to Lookups- CHOOSE - Macquarie University - Coursera.webm
|
9.0 MB
|
|
/Week 3/Challenges/
|
|
C3-W3-Practice-Challenge-Solution.xlsx
|
275.3 KB
|
|
C3-W3-Practice-Challenge.xlsx
|
274.6 KB
|
|
/.../Intermediate-II---Week-3/__MACOSX/Week 3/
|
|
._W3_V1 CHOOSE Soln.xlsx
|
0.3 KB
|
|
._W3_V1 CHOOSE.xlsx
|
0.9 KB
|
|
._W3_V2 VLOOKUP Range Soln.xlsx
|
0.3 KB
|
|
._W3_V2 VLOOKUP Range.xlsx
|
0.9 KB
|
|
._W3_V3 VLOOKUP Exact Match Soln.xlsx
|
0.9 KB
|
|
._W3_V3 VLOOKUP Exact Match.xlsx
|
0.9 KB
|
|
._W3_V4 MATCH Soln.xlsx
|
0.9 KB
|
|
._W3_V4 MATCH.xlsx
|
0.9 KB
|
|
._W3_V5 INDEX_MATCH Soln.xlsx
|
0.9 KB
|
|
._W3_V5 INDEX_MATCH.xlsx
|
0.9 KB
|
|
/.../Intermediate-II---Week-3/Week 3/
|
|
W3_V1 CHOOSE Soln.xlsx
|
88.4 KB
|
|
W3_V1 CHOOSE.xlsx
|
88.4 KB
|
|
W3_V2 VLOOKUP Range Soln.xlsx
|
94.9 KB
|
|
W3_V2 VLOOKUP Range.xlsx
|
88.8 KB
|
|
W3_V3 VLOOKUP Exact Match Soln.xlsx
|
97.9 KB
|
|
W3_V3 VLOOKUP Exact Match.xlsx
|
95.0 KB
|
|
W3_V4 MATCH Soln.xlsx
|
97.8 KB
|
|
W3_V4 MATCH.xlsx
|
97.9 KB
|
|
W3_V5 INDEX_MATCH Soln.xlsx
|
98.5 KB
|
|
W3_V5 INDEX_MATCH.xlsx
|
97.8 KB
|
|
/Week 4/Challenges/
|
|
C3-W4-Practice-Challenge-Solution.xlsx
|
73.6 KB
|
|
C3-W4-Practice-Challenge.xlsx
|
73.7 KB
|
|
find six errors in here.xlsx
|
276.1 KB
|
|
/.../Intermediate-II---Week-4/__MACOSX/Week 4/
|
|
._W4_V1 Errors Soln.xlsx
|
0.9 KB
|
|
._W4_V1 Errors.xlsx
|
0.9 KB
|
|
._W4_V2 CalculationOptions Soln.xlsx
|
0.9 KB
|
|
._W4_V2 CalculationOptions.xlsx
|
0.9 KB
|
|
._W4_V3 TracePrecedents Soln.xlsx
|
0.9 KB
|
|
._W4_V3 TracePrecedents.xlsx
|
0.9 KB
|
|
._W4_V4 EvaluateFormula Soln.xlsx
|
0.9 KB
|
|
._W4_V4 EvaluateFormula.xlsx
|
0.9 KB
|
|
._W4_V5 Protection Soln.xlsx
|
0.9 KB
|
|
._W4_V5 Protection.xlsx
|
0.9 KB
|
|
/.../Intermediate-II---Week-4/Week 4/
|
|
W4_V1 Errors Soln.xlsx
|
275.9 KB
|
|
W4_V1 Errors.xlsx
|
277.6 KB
|
|
W4_V2 CalculationOptions Soln.xlsx
|
275.9 KB
|
|
W4_V2 CalculationOptions.xlsx
|
277.5 KB
|
|
W4_V3 TracePrecedents Soln.xlsx
|
275.8 KB
|
|
W4_V3 TracePrecedents.xlsx
|
277.7 KB
|
|
W4_V4 EvaluateFormula Soln.xlsx
|
275.8 KB
|
|
W4_V4 EvaluateFormula.xlsx
|
275.9 KB
|
|
W4_V5 Protection Soln.xlsx
|
276.1 KB
|
|
W4_V5 Protection.xlsx
|
277.7 KB
|
|
/Week 5/
|
|
Practice Video- Data Tables - Macquarie University - Coursera.webm
|
21.7 MB
|
|
Practice Video- Goal Seek - Macquarie University - Coursera.webm
|
21.0 MB
|
|
Practice Video- Modelling Functions- SUMPRODUCT - Macquarie University - Coursera.webm
|
17.8 MB
|
|
Practice Video- Scenario Manager - Macquarie University - Coursera.webm
|
31.4 MB
|
|
Practice Video- Solver - Macquarie University - Coursera.webm
|
38.6 MB
|
|
/Week 5/Challenges/
|
|
C3-W5-Practice-Challenge.xlsx
|
13.8 KB
|
|
C3W5_PracticeChallenge_FixedSoln.xlsx
|
17.6 KB
|
|
/.../Intermediate-II---Week-5/__MACOSX/Week 5/
|
|
._.DS_Store
|
0.1 KB
|
|
._W5_V1 SUMPRODUCT Soln.xlsx
|
0.9 KB
|
|
._W5_V1 SUMPRODUCT.xlsx
|
0.9 KB
|
|
._W5_V2 DataTables Soln.xlsx
|
0.9 KB
|
|
._W5_V2 DataTables.xlsx
|
0.7 KB
|
|
._W5_V3 GoalSeek Soln.xlsx
|
0.9 KB
|
|
._W5_V3 GoalSeek.xlsx
|
0.9 KB
|
|
._W5_V4 ScenarioManager Soln.xlsx
|
0.9 KB
|
|
._W5_V4 ScenarioManager.xlsx
|
0.9 KB
|
|
._W5_V5 Solver Soln.xlsx
|
0.9 KB
|
|
._W5_V5 Solver.xlsx
|
0.9 KB
|
|
/.../Intermediate-II---Week-5/Week 5/
|
|
.DS_Store
|
6.1 KB
|
|
W5_V1 SUMPRODUCT Soln.xlsx
|
15.5 KB
|
|
W5_V1 SUMPRODUCT.xlsx
|
15.5 KB
|
|
W5_V2 DataTables Soln.xlsx
|
16.0 KB
|
|
W5_V2 DataTables.xlsx
|
15.7 KB
|
|
W5_V3 GoalSeek Soln.xlsx
|
16.0 KB
|
|
W5_V3 GoalSeek.xlsx
|
15.9 KB
|
|
W5_V4 ScenarioManager Soln.xlsx
|
18.6 KB
|
|
W5_V4 ScenarioManager.xlsx
|
16.2 KB
|
|
W5_V5 Solver Soln.xlsx
|
19.5 KB
|
|
W5_V5 Solver.xlsx
|
18.0 KB
|
|
/Week 6/
|
|
Practice Video- Edit a Macro - Macquarie University - Coursera.webm
|
13.7 MB
|
|
Practice Video- Record a Macro - Macquarie University - Coursera.webm
|
20.9 MB
|
|
Practice Video- Relative Reference Macros - Macquarie University - Coursera.webm
|
18.5 MB
|
|
Practice Video- Run a Macro - Macquarie University - Coursera.webm
|
12.0 MB
|
|
Practice Video- Working with Macros - Macquarie University - Coursera.webm
|
12.2 MB
|
|
/Week 6/Challenges/
|
|
C3-W6-Practice-Challenge.xlsx
|
66.7 KB
|
|
/.../C3-W6-Practice-Challenge-Solution/
|
|
C3 W6 Practice Challenge Solution.xlsm
|
83.1 KB
|
|
/.../Intermediate-II---Week-6/
|
|
BPAY20170814.txt
|
0.5 KB
|
|
BPAY20170815.txt
|
0.6 KB
|
|
BPAY20170816.txt
|
1.6 KB
|
|
W6_V1 RecordedMacro.xlsm
|
15.9 KB
|
|
W6_V1 RecordedMacro.xlsx
|
9.0 KB
|
|
W6_V2 RunMacro.xlsm
|
16.4 KB
|
|
W6_V3 EditMacro.xlsm
|
22.9 KB
|
|
W6_V4 WorkWithMacros.xlsm
|
25.9 KB
|
|
W6_V4 WorkWithMacros_Soln.xlsm
|
27.7 KB
|
|
W6_V5 RelativeReferenceMacro.xlsm
|
154.0 KB
|
|
W6_V5 RelativeReferenceMacro.xlsx
|
138.4 KB
|
|
W6_V5 RelativeReferenceMacro_Soln.xlsm
|
149.3 KB
|
|
Total files 552
|
