Thursday, November 7, 2013

Vlookup - Formulas, Excel functions - A complete Excel certification program launched.

Vlookup : Learn Excel step by step




















































































































































































































































































Vlookup - Formulas, Excel functions - A complete Excel certification program launched.
PromoPromoBenefits of   Excel
Introduction to ExcelIntroduction   to Excelwhat   is Excel ? Activities you can do with Excel – where can you buy Excel ?

Quick   demo of Excel – basic functionsquick   sum – insert picture – send picture back and bring to front. Data labelling.   Charts. Chart types and more
Excel & SkydriveIntroduction   to cloud & skydriveCloud   concept – cloud vendors – skydrive
Excel 2007 – 2010 – 2013Versions   of excel programVersions   of excel – cloud storage further detailed

Program   objectives – Excel menuComplete   excel menu explained. What will we study
Excel Features Excel spreadsheet menu featuresExcel   spreadsheet menu descriptions. Various menu buttons, ribbons, tabs explained

Workbook   worksheet explainedworkbook   – worksheet explained status bar – zoom bar – mouse pointer change – formula   bar

Keyboard   shortcuts for excelKeyboard   shortcuts – how to use various shortcuts

Data   formatsData   formats – numbers – data – formulas- special characters – currency

Autocorrect   & column widthAutocorrect   & column width

Spellcheck   and ThesaurasSpellcheck,   Thesauras, Autocorrect

Cell   rangeCell   range – review so far
Excel FormulasFormulaFormulas   – Basic add, substract, multiply & divide

Day,   month year date differencefunctions   of day and date

Reference   – relative and absoluteReference   – relative and absolute

Function   – arguments – Func without argumentsFunction   – arguments – Func without arguments

Alignment   and  format painterAlignment,   format painter and indent

Row   height – Number format – currencyRow   height – Number format – currency vs accounting entries
Excel ChartsCharting   – Excel charts – objectives – featuresCharting   – Excel charts – objectives – features

Quick   style charts – cell – charts – picturesQuick   style charts – cell – charts – pictures

Quick   style contd. Cell, themesQuick   style contd. Cell, themes

Chart   elements and chart typesChart   elements and chart types

chart   objects – chart element groups – data labelschart   objects – chart element groups – data labels

Headers   and footers – charting end reviewHeaders   and footers – charting end review

Managing   and analyzing a workbook – objectives – features -Abso ref – sheet name –   autofill – flashfill – sheet reference – find and replaceManaging   and analyzing a workbook – objectives – features -Abso ref – sheet name –   autofill – flashfill – sheet reference – find and replace
Referencing in ExcelAbsolute   reference – sheet namingAbsolute   reference – sheet naming

Autofill   – sheet reference – find and replaceAutofill   – sheet reference – find and replace

split   windowssplit   windows

Freeze   panes + what if analysisFreeze   panes + what if analysis
Excel If functionsWhat   if analysis – goal seek functionWhat   if analysis – goal seek function

conditional   formattingconditional   formatting
VlookupVlookup   -Vlookup   – list check – numbers example
Excel PivotExcel   model- pivot exampleExcel   model- pivot example

Vlookup   theoryVlookup   theory

ConcatenateExplain   concatenate function completely

Concatenate   demoConcatenate   demo
Is functionsuser   feedbackiserror   function

All   is functionsisnumber,   istext, isblank
Excel Data importImporting   dataImporting   data into excel – importing text

Importing   dataImporting   data from text type
Excel FunctionsMaths   functionsMaths   functions – operators – and – or – Not – If

Maths   functions – contd.And   – or – not – if theory. Round – Large – small command

AverageifAverageif

is   functionsiserr   and iserror

ISNA   function & error handlingISNA   function – various errors explained

Vlookup   +Vlookup   and text file import reviewed

Function   1Today   – Now – yearFrac

Function   2datedif

Function   3Find   – Left

Function   4Len   – Left – Right – Concatenate

Function   5Lower   – upper – proper

Function   6Trim   and clean

Function   7Text   functions in excel, Replace

Function   8Average,   count

Function   9Count   – CountA – Max

Function   10Median   – Min

Function   11Sum   function explained

Function   12Quick   review of functions covered
PivotPivot   theory explainedTheory   behind pivot table

Pivot   demoDemo   behind pivot table
ConclusionConclusionConclusion
at

No comments:

Post a Comment