-
Section 1: Introduction to the course and your tutor 2
-
Introduction to what we’ll cover and how 02 minLecture1.1
-
Downloadable ResourceLecture1.2
-
-
Section 2: Data 11
-
Enter numbers and fractions 05 minLecture2.1
-
Dates and Times 08 minLecture2.2
-
Name Cells and Ranges 04 minLecture2.3
-
Validate Data entry using a pick list 08 minLecture2.4
-
Extend a series of dates with autofill 05 minLecture2.5
-
Add a symbol or special character 04 minLecture2.6
-
Compare multiple spreadsheets using freeze panels 06 minLecture2.7
-
Hide rows 05 minLecture2.8
-
Keyboard 10 minLecture2.9
-
Speak Cells 04 minLecture2.10
-
Find and replace data 11 minLecture2.11
-
-
Section 3: Formulas and Functions 18
-
Add values 03 minLecture3.1
-
Function wizard 06 minLecture3.2
-
Formulas with comments 05 minLecture3.3
-
OneNote 06 minLecture3.4
-
Define a constant 04 minLecture3.5
-
Apply names in functions 05 minLecture3.6
-
Figure out the best loan terms 05 minLecture3.7
-
Internal Rates of Return 04 minLecture3.8
-
Nth largest value 04 minLecture3.9
-
Large. Small. Max, Min 05 minLecture3.10
-
Conditional formula 03 minLecture3.11
-
Conditional formula with names 04 minLecture3.12
-
Count If 02 minLecture3.13
-
Conditional sum 03 minLecture3.14
-
Inner calculator 03 minLecture3.15
-
Square Roots 03 minLecture3.16
-
Calculate the duration between two times 04 minLecture3.17
-
Calculate days between two dates 05 minLecture3.18
-
-
Section 4: Copying Data, Formats etc. 6
-
Copy a range 03 minLecture4.1
-
Transpose a row into a column 02 minLecture4.2
-
Copy styles to another workbook 08 minLecture4.3
-
Chart formatting 07 minLecture4.4
-
Paste special and copying worksheets 07 minLecture4.5
-
Track changes while Editing 06 minLecture4.6
-
-
Section 5: Lists 13
-
Enter list data using a form 05 minLecture5.1
-
Searching through a data list 04 minLecture5.2
-
Import a word list into excel 05 minLecture5.3
-
Sort a list 02 minLecture5.4
-
Filter a list 03 minLecture5.5
-
Sort by multiple criteria 03 minLecture5.6
-
Find averages in a sorted group 05 minLecture5.7
-
Filter by multiple criteria 03 minLecture5.8
-
Remove duplicate records from a list 03 minLecture5.9
-
Count filtered records 07 minLecture5.10
-
Filter by multiple criteria in the same column 06 minLecture5.11
-
Chart a filtered list 03 minLecture5.12
-
Look up information in a List 05 minLecture5.13
-
-
Section 6: Data Patterns 14
-
Create a PivotTable 06 minLecture6.1
-
Modify a PivotTable and layout 03 minLecture6.2
-
Find the average of a field 04 minLecture6.3
-
Create a calculated field 02 minLecture6.4
-
Calculated fields and charts 02 minLecture6.5
-
Hide rows and columns in a PivotTable 01 minLecture6.6
-
AutoFormat a PivotTable 03 minLecture6.7
-
Create a PivotChart 03 minLecture6.8
-
Turning on the Data Analysis function so that statistical info can be run 03 minLecture6.9
-
Describe Data with Statistics 03 minLecture6.10
-
Discover associations within your data 04 minLecture6.11
-
Product Numbers 02 minLecture6.12
-
What-if analysis 05 minLecture6.13
-
Goal seek 07 minLecture6.14
-
-
Section 7: Creating Charts 14
-
Create a Chart 06 minLecture7.1
-
Modify Chart details 04 minLecture7.2
-
Change the Chart Type 04 minLecture7.3
-
Add a Trendline to a Chart 07 minLecture7.4
-
Remove Chart Data 02 minLecture7.5
-
Add chart data 02 minLecture7.6
-
Missing chart data 04 minLecture7.7
-
Error bars 04 minLecture7.8
-
Pull a slice from a Pie Chart 03 minLecture7.9
-
Label slices of a Pie Chart 04 minLecture7.10
-
Histogram 07 minLecture7.11
-
Paste a chart into Word 04 minLecture7.12
-
Amending a chart in Word 02 minLecture7.13
-
Paste-link a Chart into Word 05 minLecture7.14
-
-
Section 8: Worksheets 6
-
Format Numbers as Percentages 04 minLecture8.1
-
Format Currencies in Currency and Accounting Formats 04 minLecture8.2
-
Format Column Headings 05 minLecture8.3
-
Format Quickly with Format painter 03 minLecture8.4
-
Insert a background image into your worksheet 03 minLecture8.5
-
Create a Transparent image 03 minLecture8.6
-
-
Section 9: Saving and Printing Worksheets 8
-
Save a workbook as a Template 07 minLecture9.1
-
Save a workbook as an XML spreadsheet 05 minLecture9.2
-
Print multiple cell ranges on One Page 03 minLecture9.3
-
Page setup, header, footer, margins – 1 page printing 05 minLecture9.4
-
Print multiple areas of a workbook 08 minLecture9.5
-
Print multiple worksheets of a workbook 02 minLecture9.6
-
Repeat Headings of a Row or Column 07 minLecture9.7
-
Print functions to show calculations & comments 08 minLecture9.8
-
-
Section 10: Extending Excel 6
-
Hyperlink a worksheet to another office documents 03 minLecture10.1
-
Embed a chart within PowerPoint 06 minLecture10.2
-
Publish an Interactive Workbook 05 minLecture10.3
-
Importing data from a Website or Access Database 03 minLecture10.4
-
Import a Worksheet into Access 09 minLecture10.5
-
Use Excel Data to create labels in Word 10 minLecture10.6
-
-
Section 11: Customizing Excel 5
-
Launch a specific Workbook when Excel Opens 04 minLecture11.1
-
Save Time by Creating a Custom View 04 minLecture11.2
-
Create a Custom Number Format 06 minLecture11.3
-
Changing Text to Columns 06 minLecture11.4
-
Create a Macro to Format Numbers 07 minLecture11.5
-
-
Section 12: Next steps 1
-
What to study next – Excel advanced 01 minLecture12.1
-
This content is protected, please login and enroll course to view this content!
