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.
$6.99
$14.99
Curriculum For This Course
-
1. Creating new blank workbooks4m
-
2. Entering data9m
-
3. An introduction to fonts and highlighting4m
-
4. Saving and closing your workbook5m
-
5. Practice Activity Number 1 - The Solution2m
-
1. Creating new workbooks using templates6m
-
2. Menus and toolbars7m
-
3. Managing multiple workbooks - Excel 2013 and 20164m
-
4. Managing multiple workbooks - Excel 2007 and 20107m
-
5. Importing files and Opening non-native files directly in Excel8m
-
6. Adding worksheets to existing workbooks4m
-
7. Copying and moving worksheets, and changing spreadsheet order5m
-
1. Saving workbooks in alternate file formats7m
-
2. Maintaining backward compatibility6m
-
3. Saving files to remote locations3m
-
1. Using basic operators6m
-
2. Order of operations6m
-
3. How to enter numbers and dates in Excel3m
-
4. Referencing cell ranges in formulas10m
-
5. Practice Activity Number 2 - Solution6m
-
1. Searching for data within a workbook5m
-
2. Hyperlinks5m
-
3. Using Go To and Using Name Box5m
-
4. Hot Keys4m
-
1. Changing worksheet tab colour5m
-
2. Inserting and deleting columns and rows8m
-
3. Undo and Redo4m
-
4. File Management tips4m
-
5. Adjusting row height and column width5m
-
6. Hiding columns and rows4m
-
7. Selecting multiple ranges4m
-
1. Hiding worksheets4m
-
2. Customising the Quick Access toolbar3m
-
3. Customising the Ribbon5m
-
4. Assigning shortcut keys3m
-
5. Recording simple macros5m
-
6. Managing macro security8m
-
7. Changing workbook views4m
-
8. Using zoom3m
-
9. Adding values to workbook properties5m
-
10. Displaying formulas3m
-
11. Freezing panes5m
-
12. Splitting the window3m
-
1. Printing individual worksheets3m
-
2. Printing an entire workbook and printing a selection2m
-
3. Setting a print area4m
-
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 footers3m
-
7. Inserting watermarks3m
-
8. Page setup, Part 3 (Headings etc.)7m
-
9. Configuring workbooks to print3m
-
10. Inspecting your workbook prior to distribution4m
-
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)9m
-
2. Practice Activity - multiplication table3m
-
3. Answer - multiplication table3m
-
1. Appending data to Excel worksheets3m
-
2. Setting data validation11m
-
3. Finding and replacing data7m
-
4. Copying and pasting data, including Paste Special5m
-
5. Cutting and moving cell data3m
-
6. Using AutoFill tool, and Expanding data across columns5m
-
1. Modifying cell alignment and indentation5m
-
2. Wrapping text within cells5m
-
3. Merging cells and Shrink to Fit7m
-
4. Changing font and font styles4m
-
5. Applying highlighting2m
-
6. Applying Number format8m
-
7. Applying borders6m
-
8. Applying cell styles3m
-
9. Using Format Painter3m
-
10. Changing text to WordArt2m
-
1. Applying conditional formatting - highlighting12m
-
2. Applying conditional formatting - Bars, Scales and Sets10m
-
3. Transposing columns and rows, and #####s3m
-
4. Inserting sparklines, and how to define a range5m
-
5. Customising Sparklines7m
-
1. Doing calculations without formulas3m
-
2. Utilising the SUM function5m
-
3. Formula syntax - SUM function7m
-
4. Utilising the COUNT function7m
-
5. Utilising the AVERAGE and other averaging functions8m
-
6. Utilising the MIN and MAX functions3m
-
7. Creating named ranges8m
-
8. Getting help with functions3m
-
1. Moving between tables and ranges5m
-
2. Adding and removing cells within tables4m
-
3. Formulas in tables6m
-
4. Defining titles4m
-
1. Inserting total rows4m
-
2. Adding and removing styles and Banding rows and columns6m
-
1. Setting up a filter and Filtering records6m
-
2. More advanced filtering options12m
-
3. Using sort options5m
-
4. Sorting data on multiple columns; changing sort order4m
-
5. Removing duplicates4m
-
6. Inserting subtotals4m
-
7. Creating outlines; collapsing groups of data in outlines6m
-
8. Utilising the SUBTOTAL function7m
-
1. Utilising the IF function8m
-
2. Utilising the SUMIF function6m
-
3. Utilising the COUNTIF function4m
-
4. Utilising the AVERAGEIF function4m
-
5. Nested IFs and Evaluate Formulas6m
-
6. The CHOOSE function3m
-
1. Creating charts and graphs6m
-
2. Adding and removing additional data series4m
-
3. Exploring the Column charts6m
-
4. Line, bar and area charts4m
-
5. Pie charts3m
-
6. Other graph types8m
-
7. Switching between rows and columns in source data3m
-
1. Adding legends7m
-
2. Positioning and Resizing charts and graphs, inc5m
-
3. Modifying chart and graph parameters - Excel 2007 and 20106m
-
4. Modifying chart and graph parameters - Excel 2013 and 20166m
-
5. Applying chart layouts and styles4m
-
1. Inserting text boxes and positioning objects4m
-
2. Inserting SmartArt5m
-
3. Inserting ClipArt and images3m
-
4. Inserting Screenshots3m
-
5. Adding borders to objects5m
-
6. Inserting shapes5m
-
7. Adding styles and effects to objects4m
-
8. Changing workbook themes4m
-
9. Modifying object properties, including adding alternate text5m
-
1. Making corrections to an image3m
-
2. Using picture colour tools2m
-
3. Send to front and back, and transparent colour2m
-
4. Changing artistic effects on an image3m
-
5. Crop picture4m
-
1. Utilising the CONCATENATE function5m
-
2. Utilising the RIGHT, LEFT and MID functions7m
-
3. Utilising the TRIM function3m
-
4. Utilising the UPPER and LOWER functions3m
