As follow-on to our brief discussion on the value of getting familiar with and cultivating Excel (spreadsheet) skills, the following is the link to the excellent "free" YOUTube video training series that Binoj shared with us that has been so helpful for him.
I looked at some of the classes briefly and I found them easy to follow and quite helpful...and have already made plans to watch selected ones for my own professional development. Hope you find this a helpful resource to develop your computer skills to add to the value you can offer your next employer. Art
Learn about: How Excel is setup Ribbons Quick Access Toolbar QAT Scroll Bars Numbers and Text Keyboard shortcuts This is a beginning to advanced ...
Learn about: 1) The different elements of formulas: equal sign, cell references, math operators, comparative operators, built-in functions ...
Learn about: 1)VLOOKUP to lookup an exact match 2)VLOOKUP to lookup an approximate match 3)VLOOKUP can return a value to a cell 4)VLOOKUP can ...
Learn about: How to Name a range of cells Use Names in Formulas Cell References: Relative, Absolute, Mixed Assumption Tables Formula Inputs ...
See these 20 PivotTable Pivot Table examples: 1 Proper Format 2 Understanding Pivot Tables 3 Drag & Drop in 2003 4 Change 2003 to 2007 5 Pivot ...
1800 Videos, 90 Playlists. Excel Efficiency Tricks so you can work faste...
Learn 1-way, 2-way & 3-way lookup using the INDEX and MATCH functions see these tricks: 1.Two-Way lookup (2 way Lookup, Two Way Lookup) 2.1-Way ...
INDEX function & MATCH function. See 12 examples for the INDEX and MATCH function: 1.Use INDEX, MATCH and SUMPRODUCT to retrieve a whole column of ...
See how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a Percentage Increase Formula ...
See these 5 Subtotal examples: 1. Basics of the Subtotal Feature including Sorting before Subtotaling 2. Adding two Subtotals 3. Adding Subtotals ...
See these 8 Filtering Examples: 1. Keyboard shortcut: Ctrl + Shift + L 2. See that Filtering hides rows whereas, sorting does not hide rows 3 ...
Learn about: Style Formatting Number Formatting (Date, Time, Currency, Accounting) ROUND function This is a beginning to advanced Excel class ...
Learn about: 1.How to Record a Macro 2.Macro = VBA code 3.Macros are great for repetitive tasks 4.What file extension to use for Excel 2007: .xlsm ...
Excel 2013 Preview Is Out: Smooth and Improved Excel 2013, Office 15 (Excel Magic Trick 949)
No comments:
Post a Comment