Curriculum For This Course
Video tutorials list
-
Level 1, Section 1 - An introduction to Excel
Video Name Time 1. Creating new blank workbooks 4:00 2. Entering data 9:00 3. An introduction to fonts and highlighting 4:00 4. Saving and closing your workbook 5:00 5. Practice Activity Number 1 - The Solution 2:00 -
Level 1, Section 2 - Create worksheets and workbooks
Video Name Time 1. Creating new workbooks using templates 6:00 2. Menus and toolbars 7:00 3. Managing multiple workbooks - Excel 2013 and 2016 4:00 4. Managing multiple workbooks - Excel 2007 and 2010 7:00 5. Importing files and Opening non-native files directly in Excel 8:00 6. Adding worksheets to existing workbooks 4:00 7. Copying and moving worksheets, and changing spreadsheet order 5:00 -
Level 1, Section 3: Configure worksheets and workbooks to save
Video Name Time 1. Saving workbooks in alternate file formats 7:00 2. Maintaining backward compatibility 6:00 3. Saving files to remote locations 3:00 -
Level 1, Section 4: Basic formulas
Video Name Time 1. Using basic operators 6:00 2. Order of operations 6:00 3. How to enter numbers and dates in Excel 3:00 4. Referencing cell ranges in formulas 10:00 5. Practice Activity Number 2 - Solution 6:00 -
Level 2, Section 1: Navigate through Excel worksheets and workbooks
Video Name Time 1. Searching for data within a workbook 5:00 2. Hyperlinks 5:00 3. Using Go To and Using Name Box 5:00 4. Hot Keys 4:00 -
Level 2, Section 2: Format worksheets and workbooks
Video Name Time 1. Changing worksheet tab colour 5:00 2. Inserting and deleting columns and rows 8:00 3. Undo and Redo 4:00 4. File Management tips 4:00 5. Adjusting row height and column width 5:00 6. Hiding columns and rows 4:00 7. Selecting multiple ranges 4:00 -
Level 2, Section 3: Customise options and views for worksheets and workbooks
Video Name Time 1. Hiding worksheets 4:00 2. Customising the Quick Access toolbar 3:00 3. Customising the Ribbon 5:00 4. Assigning shortcut keys 3:00 5. Recording simple macros 5:00 6. Managing macro security 8:00 7. Changing workbook views 4:00 8. Using zoom 3:00 9. Adding values to workbook properties 5:00 10. Displaying formulas 3:00 11. Freezing panes 5:00 12. Splitting the window 3:00 -
Level 2, Section 4: Configure Excel worksheets and workbooks to print
Video Name Time 1. Printing individual worksheets 3:00 2. Printing an entire workbook and printing a selection 2:00 3. Setting a print area 4:00 4. Page setup, Part 1 (first two tabs) 6:00 5. Page setup, Part 2 (Repeating headers and footers) 3:00 6. Adding dynamic text to headers and footers 3:00 7. Inserting watermarks 3:00 8. Page setup, Part 3 (Headings etc.) 7:00 9. Configuring workbooks to print 3:00 10. Inspecting your workbook prior to distribution 4:00 -
Level 2, Section 5: Utilise cell ranges and references in formulas and functions
Video Name Time 1. Copying and pasting basics, and Utilising references (relative, mixed, absolute) 9:00 2. Practice Activity - multiplication table 3:00 3. Answer - multiplication table 3:00 -
Level 3, Section 1: Insert data in cells and ranges
Video Name Time 1. Appending data to Excel worksheets 3:00 2. Setting data validation 11:00 3. Finding and replacing data 7:00 4. Copying and pasting data, including Paste Special 5:00 5. Cutting and moving cell data 3:00 6. Using AutoFill tool, and Expanding data across columns 5:00 -
Level 3, Section 2: Format cells and ranges
Video Name Time 1. Modifying cell alignment and indentation 5:00 2. Wrapping text within cells 5:00 3. Merging cells and Shrink to Fit 7:00 4. Changing font and font styles 4:00 5. Applying highlighting 2:00 6. Applying Number format 8:00 7. Applying borders 6:00 8. Applying cell styles 3:00 9. Using Format Painter 3:00 10. Changing text to WordArt 2:00 -
Level 3, Section 3: Highlight and filter cells and ranges in Excel
Video Name Time 1. Applying conditional formatting - highlighting 12:00 2. Applying conditional formatting - Bars, Scales and Sets 10:00 3. Transposing columns and rows, and #####s 3:00 4. Inserting sparklines, and how to define a range 5:00 5. Customising Sparklines 7:00 -
Level 3, Section 4: Summarise data with Excel functions
Video Name Time 1. Doing calculations without formulas 3:00 2. Utilising the SUM function 5:00 3. Formula syntax - SUM function 7:00 4. Utilising the COUNT function 7:00 5. Utilising the AVERAGE and other averaging functions 8:00 6. Utilising the MIN and MAX functions 3:00 7. Creating named ranges 8:00 8. Getting help with functions 3:00 -
Level 4, Section 1: Create a table
Video Name Time 1. Moving between tables and ranges 5:00 2. Adding and removing cells within tables 4:00 3. Formulas in tables 6:00 4. Defining titles 4:00 -
Level 4, Section 2: Modify a table
Video Name Time 1. Inserting total rows 4:00 2. Adding and removing styles and Banding rows and columns 6:00 -
Level 4, Section 3: Filtering, Sorting and Grouping
Video Name Time 1. Setting up a filter and Filtering records 6:00 2. More advanced filtering options 12:00 3. Using sort options 5:00 4. Sorting data on multiple columns; changing sort order 4:00 5. Removing duplicates 4:00 6. Inserting subtotals 4:00 7. Creating outlines; collapsing groups of data in outlines 6:00 8. Utilising the SUBTOTAL function 7:00 -
Level 4, Section 4: Utilise conditional logic in functions
Video Name Time 1. Utilising the IF function 8:00 2. Utilising the SUMIF function 6:00 3. Utilising the COUNTIF function 4:00 4. Utilising the AVERAGEIF function 4:00 5. Nested IFs and Evaluate Formulas 6:00 6. The CHOOSE function 3:00 -
Level 5, Section 1: Create a chart in Excel
Video Name Time 1. Creating charts and graphs 6:00 2. Adding and removing additional data series 4:00 3. Exploring the Column charts 6:00 4. Line, bar and area charts 4:00 5. Pie charts 3:00 6. Other graph types 8:00 7. Switching between rows and columns in source data 3:00 -
Level 5, Section 2: Format a chart in Excel
Video Name Time 1. Adding legends 7:00 2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets 5:00 3. Modifying chart and graph parameters - Excel 2007 and 2010 6:00 4. Modifying chart and graph parameters - Excel 2013 and 2016 6:00 5. Applying chart layouts and styles 4:00 -
Level 5, Section 3: Insert and format an object
Video Name Time 1. Inserting text boxes and positioning objects 4:00 2. Inserting SmartArt 5:00 3. Inserting ClipArt and images 3:00 4. Inserting Screenshots 3:00 5. Adding borders to objects 5:00 6. Inserting shapes 5:00 7. Adding styles and effects to objects 4:00 8. Changing workbook themes 4:00 9. Modifying object properties, including adding alternate text 5:00 -
Level 5, Section 4: create and modify images by using the Image Editor
Video Name Time 1. Making corrections to an image 3:00 2. Using picture colour tools 2:00 3. Send to front and back, and transparent colour 2:00 4. Changing artistic effects on an image 3:00 5. Crop picture 4:00 -
Level 5, Section 5: Format and modify text with functions
Video Name Time 1. Utilising the CONCATENATE function 5:00 2. Utilising the RIGHT, LEFT and MID functions 7:00 3. Utilising the TRIM function 3:00 4. Utilising the UPPER and LOWER functions 3:00
Add Comment