{"id":7143,"date":"2014-01-09T10:55:14","date_gmt":"2014-01-09T10:55:14","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=7143"},"modified":"2015-06-10T10:35:04","modified_gmt":"2015-06-10T09:35:04","slug":"intermediate-spreadsheet-skills","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/financial-training-courses\/business-it-skills\/intermediate-spreadsheet-skills\/","title":{"rendered":"Intermediate Spreadsheet Skills"},"content":{"rendered":"\"in-house\n

Intermediate Spreadsheet Skills
\nIn-house training course<\/h2>\n

The following course is an in-house course. We also offer an open course in excel<\/a>.<\/p>\n

We offer courses in financial spreadsheet skills for both finance and non-finance professionals.<\/p>\n

If you are looking for an introduction to spreadsheets, a practical guide, a refresher or to enhance your existing understanding then we have the right course for you.<\/p>\n

No matter what your experience or level, we can pitch our courses at the right level for you.<\/p>\n

<\/a><\/p>\n

Our Intermediate Spreadsheet Skills Course objectives<\/h3>\n

This course is aimed at those who have attended the course: \u2018Spreadsheet Skills \u2013 The Basics\u2019 or with a reasonable existing experience in excel. <\/p>\n

This course aims to further develop some basic skills as well as looking at some more advanced techniques, functions and formulas.<\/p>\n

We will focus on three areas of spreadsheet skills:
\n\u2022\tFunctions
\n\u2022\tData analysis
\n\u2022\tBest practice<\/p>\n

Our Intermediate Spreadsheet Skills Course Includes:<\/h3>\n

Our spreadsheet skills courses are usually tailored to meet our clients specific needs. <\/p>\n

1.\tFunctions<\/strong><\/big><\/p>\n

Logical & conditional functions<\/strong>
\n\u2022\tCountif\/s
\n\u2022\tSumif\/s.<\/p>\n

Date functions<\/strong>
\n\u2022\tExcel serial numbers
\n\u2022\tAdding
\n\u2022\tSubtracting
\n\u2022\tNetworkdays.
\n\"Training
\nText functions<\/strong>
\n\u2022\tConcatenate
\n\u2022\tLeft, Right, Mid, Len
\n\u2022\tFind
\n\u2022\tTrim, Proper, Clean<\/p>\n

Lookup functions<\/strong>
\n\u2022\tvlookup
\n\u2022\thlookup.<\/p>\n

Error control functions<\/strong>
\n\u2022\tIferror, Ifna, isblank<\/p>\n

2.\tData analysis<\/strong><\/big><\/p>\n

Importing data <\/strong>
\n\u2022\tText to columns and other tips<\/p>\n

Data Validation<\/strong>
\n\u2022\tDropdown lists
\n\u2022\tPermissible values
\n\u2022\tHelp and error messages<\/p>\n

Pivot Tables<\/strong>
\n\u2022\tBuilding
\n\u2022\tFormatting
\n\u2022\tFiltering
\n\u2022\tSorting
\n\u2022\tAlternative view
\n\u2022\tSlicers (Excel 2010 onwards)<\/p>\n

Viewing<\/strong>
\n\u2022\tGrouping columns and rows<\/p>\n

Conditional Formatting<\/strong>
\n\u2022\tTypes and uses
\n\u2022\tAdding
\n\u2022\tManaging & clearing rules
\n\u2022\tBest practice<\/p>\n

More in-depth graphs and charts<\/strong>
\n\u2022\tDealing with more complex data
\n\u2022\tManipulating axes, legends, presentation & source data
\n\u2022\tAlternative presentations
\n\u2022\tSparklines (excel 2010 onwards)
\n\u2022\tBest practice tips
\n\"Spreadsheet
\n3.\tBest practice<\/strong><\/big><\/p>\n

The ideal spreadsheet <\/strong>
\n\u2022\tTransparency
\n\u2022\tDocumentation
\n\u2022\tVersion control
\n\u2022\tPlanning
\n\u2022\tStandardisation
\n\u2022\tSeparation of inputs, workings and outputs
\n\u2022\tUsing hyperlinks<\/p>\n

Named Ranges<\/strong>
\n\u2022\tBenefits
\n\u2022\tCreating
\n\u2022\tEditing
\n\u2022\tInserting
\n\u2022\tNavigating with<\/p>\n

Working with multiple worksheets and workbooks<\/strong>
\n\u2022\tReferencing within a workbook
\n\u2022\tReferencing between workbooks
\n\u2022\tUpdating external references.<\/p>\n

Sharing spreadsheets<\/strong>
\n\u2022\tThe sharing function
\n\u2022\tAvoiding conflict
\n\u2022\tVersion control
\n\u2022\tProtecting cells, sheets and workbooks.<\/p>\n

Spreadsheet auditing<\/strong>
\n\u2022\tExcel checks
\n\u2022\tUser built checks and controls<\/p>\n

Expensive mistakes are made by many organisations through poor spreadsheet techniques.<\/p>\n

Our courses demonstrate best practice techniques.<\/p>\n

Delegates are advised to use laptops on our spreadsheet skills training courses.<\/p>\n

Requirements for Intermediate Spreadsheet Skills<\/h3>\n

Prior attendance on \u2018Spreadsheet Skills \u2013 The Basics\u2019 or a reasonable level of existing proficiency in excel.<\/p>\n

\"Spreadsheet<\/p>\n

See also our investment appraisal<\/a> courses, which complement this course.<\/p>\n

Intermediate Spreadsheet Skills Course Delivery<\/h3>\n

\"Spreadsheet<\/p>\n

We take an open friendly and enthusiastic approach to learning finance. We believe that people learn more effectively when they are enjoying themselves. We make finance interesting for you. We love questions and welcome as many as possible. <\/p>\n

We encourage an open atmosphere which in our experience accelerates the learning process. We always use lots of exercises, case studies and real life examples in our training as we believe this really helps our clients to understand concepts. <\/p>\n

We find that people only really learn when they test their understanding through practice. We offer traditional training, facilitation, interactive simulations, coaching and online training.<\/p>\n

Tailored Spreadsheet Skills Courses<\/h3>\n

All our courses are tailored to meet our client’s specific needs. We like to spend time getting to know our clients as we strongly believe that training is most effective and valuable when tailored and focused.
\n\"In-house<\/p>\n

In-house Intermediate Spreadsheet Skills Training<\/h3>\n

Our training can be held within your office or an external venue of your choice. <\/p>\n

We can also secure venues on your behalf through our venue sourcing agency.<\/p>\n

 
\n 
\n<\/a><\/p>\n

Make Enquiry or Book Now \"in-house<\/h2>\n
\n

<\/p>