Excel 2016 - Smarter Not Harder - Key Points (ROI)

Key objectives include demonstrating how to speed up navigation by tailoring the Excel desktop, using some of the new and improved features and formulae in Excel 2016/Office 365, and finally, previewing some of the more advanced Excel features that firms could/should be using to their advantage.

Content will include:

• Navigation and customisation tips
• Minimising rounding errors, and cross-casting techniques
• Cell referencing
• Data Validation
• Lookup and Conditional formulae (including Vlookup, IF's and SUMIF's)
• Concatenation and Concat
• Control keys and other keyboard shortcuts
• Conditional formatting
• Named ranges and Name manager
• Database Advanced Filter
• Tables, Pivot tables and Power Query
• Custom number and date formats
• Delimited files
• Introduction to keystroke macros

Please note that this is NOT a hands-on course.

(ROI) courses are for sale to accountants in the Republic of Ireland.  The on-demand courses are also available as part of the ROI Box Set – click here for details.