Thursday, November 7, 2013
Vlookup : Learn Excel step by step
| Promo | Promo | Benefits of Excel |
| Introduction to Excel | Introduction to Excel | what is Excel ? Activities you can do with Excel – where can you buy Excel ? |
| Quick demo of Excel – basic functions | quick sum – insert picture – send picture back and bring to front. Data labelling. Charts. Chart types and more | |
| Excel & Skydrive | Introduction to cloud & skydrive | Cloud concept – cloud vendors – skydrive |
| Excel 2007 – 2010 – 2013 | Versions of excel program | Versions of excel – cloud storage further detailed |
| Program objectives – Excel menu | Complete excel menu explained. What will we study | |
| Excel Features | Excel spreadsheet menu features | Excel spreadsheet menu descriptions. Various menu buttons, ribbons, tabs explained |
| Workbook worksheet explained | workbook – worksheet explained status bar – zoom bar – mouse pointer change – formula bar | |
| Keyboard shortcuts for excel | Keyboard shortcuts – how to use various shortcuts | |
| Data formats | Data formats – numbers – data – formulas- special characters – currency | |
| Autocorrect & column width | Autocorrect & column width | |
| Spellcheck and Thesauras | Spellcheck, Thesauras, Autocorrect | |
| Cell range | Cell range – review so far | |
| Excel Formulas | Formula | Formulas – Basic add, substract, multiply & divide |
| Day, month year date difference | functions of day and date | |
| Reference – relative and absolute | Reference – relative and absolute | |
| Function – arguments – Func without arguments | Function – arguments – Func without arguments | |
| Alignment and format painter | Alignment, format painter and indent | |
| Row height – Number format – currency | Row height – Number format – currency vs accounting entries | |
| Excel Charts | Charting – Excel charts – objectives – features | Charting – Excel charts – objectives – features |
| Quick style charts – cell – charts – pictures | Quick style charts – cell – charts – pictures | |
| Quick style contd. Cell, themes | Quick style contd. Cell, themes | |
| Chart elements and chart types | Chart elements and chart types | |
| chart objects – chart element groups – data labels | chart objects – chart element groups – data labels | |
| Headers and footers – charting end review | Headers and footers – charting end review | |
| Managing and analyzing a workbook – objectives – features -Abso ref – sheet name – autofill – flashfill – sheet reference – find and replace | Managing and analyzing a workbook – objectives – features -Abso ref – sheet name – autofill – flashfill – sheet reference – find and replace | |
| Referencing in Excel | Absolute reference – sheet naming | Absolute reference – sheet naming |
| Autofill – sheet reference – find and replace | Autofill – sheet reference – find and replace | |
| split windows | split windows | |
| Freeze panes + what if analysis | Freeze panes + what if analysis | |
| Excel If functions | What if analysis – goal seek function | What if analysis – goal seek function |
| conditional formatting | conditional formatting | |
| Vlookup | Vlookup - | Vlookup – list check – numbers example |
| Excel Pivot | Excel model- pivot example | Excel model- pivot example |
| Vlookup theory | Vlookup theory | |
| Concatenate | Explain concatenate function completely | |
| Concatenate demo | Concatenate demo | |
| Is functions | user feedback | iserror function |
| All is functions | isnumber, istext, isblank | |
| Excel Data import | Importing data | Importing data into excel – importing text |
| Importing data | Importing data from text type | |
| Excel Functions | Maths functions | Maths functions – operators – and – or – Not – If |
| Maths functions – contd. | And – or – not – if theory. Round – Large – small command | |
| Averageif | Averageif | |
| is functions | iserr and iserror | |
| ISNA function & error handling | ISNA function – various errors explained | |
| Vlookup + | Vlookup and text file import reviewed | |
| Function 1 | Today – Now – yearFrac | |
| Function 2 | datedif | |
| Function 3 | Find – Left | |
| Function 4 | Len – Left – Right – Concatenate | |
| Function 5 | Lower – upper – proper | |
| Function 6 | Trim and clean | |
| Function 7 | Text functions in excel, Replace | |
| Function 8 | Average, count | |
| Function 9 | Count – CountA – Max | |
| Function 10 | Median – Min | |
| Function 11 | Sum function explained | |
| Function 12 | Quick review of functions covered | |
| Pivot | Pivot theory explained | Theory behind pivot table |
| Pivot demo | Demo behind pivot table | |
| Conclusion | Conclusion | Conclusion |
