Exclusive SALE Offer Today

77-420: Excel 2013

Best Seller 135 Lectures 11h 9m
Prepare for your Microsoft examination with our training course. The 77-420 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft 77-420 test with flying colors.
$13.99$24.99
Curriculum For This Course

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