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.
$14.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

Hot Exams

How to Open Test Engine .dumpsqueen Files

Use FREE DumpsQueen Test Engine player to open .dumpsqueen files

DumpsQueen Test Engine

Windows

safe checkout

Your purchase with DumpsQueen.com is safe and fast.

The DumpsQueen.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.

Need Help Assistance?

Customer Support