Further Details
What do I get out of it? You will learn how to utilise database functionality, create lookups to obtain range and precise data. You will also have gained an understanding on how to add ‘IF’ statements and using validation to restrict access to cells, rows and columns. Course Overview:Recap on User Interface, Environment and ShortcutsAbsolute ReferencesNaming Cells and RangesReferring to named cells and ranges in formulaeEditing Named Cells and RangesSetting up entire workbooks with Group EditingUsing Lookup statements to retrieve dataEditing Lookups and ensuring accuracy in returned dataLinking spreadsheets and Workbooks together with formulas and functionsUtilising If Statements to assist decision makingIf statements and CalculationsAnalysing Data with the all new Conditional Formatting FeaturesDatabases in Excel understanding Fields and RecordsSorting data numerically and alphabeticallyFiltering Data for range and precision analysisSetting up data Validation to ensure integrity of the dataAttaching Security to a spreadsheetSelective protection i.e.: Protecting formulas while allowing data entrySetting up and utilising TemplatesCreating and Formatting ChartsAdding Trend lines to the chartUtilising Custom Chart types
Guide price
£275 + VAT |
