Professional Development of Bespoke Business Software and Database Specialists
Audience: This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros
Course Duration : This is a 1 day Excel Advanced Course. Course starts at 09:30 and runs until 16:30 Excel 2003 Advanced Course Objectives: After the course, you will be able to: Use Lookup & Informational Functions Create Pivot Tables Use What-If Tools Sharing and Tracking Workbooks Record Basic Macros Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level. Course Locations / Schedule : This course can be run at your premises (equipment must be provided) or at one of our training centres throughout the UK. The course is run on a date that suits you! We do not run public scheduled courses. The following content applies broadly to all versions of Excel. Some content may slightly differ, full course content packs are provided on the day. Remember courses can be customised to fit your exact needs. Lookup & Information Functions Vertical Lookup (Vlookup) Horizontal Lookup (Hlookup) Match and Index IsText, IsValue, IsDate, IsErr, Is Error, IsNaAdvanced List Management Advanced Filters Using List Features Dynamic ListsPivot Tables Using the Pivot Table Wizard Changing the pivot table layout Formatting Grouping items Inserting calculated fields Pivot Table Options Display and hide data in fields Lay out reports directly on worksheet Pivot ChartWhat If Analysis Scenarios Custom Views Reports Goal Seek Solver Data TablesProtecting & Sharing Files Sharing a file Tracking changes Accepting or rejecting changes Applying Data validation rules Inserting commentsIntroduction to Macros Purpose of Macros Recording macros Where to save macros Absolute and relative record Running macros: Custom buttons, menu items, keyboard shortcutsAt Mill House Data we are experts in the design and construction of bespoke software development solutions. With a high level of experience in application development for many industries, from small business to corporate clients, we are capable of designing and developing the perfect business software for your needs.
Our software development company utilizes MS Access which not only allows for multiple user ids but up to 2GB of data storage which is more than adequate for most business needs. Utilising this method of application development is the most economic route as only one Microsoft license is required, so we can provide your custom software development needs with a smaller budget than most other development houses.
Using the services of Mill House has really improved our company's customer services. The database that Mill House have provided is very customer friendly, easy to use and practical. I would highly recommend Mill house and surely use them again.
Read more testimonials >