134 Courses

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Advanced Adobe InDesign Training Program Learn InDesign with a course at Real Animation Works. Choose from Weekend, Weekday or Evening Courses and learn from expert tutors. Benefit from professional InDesign training conducted by Adobe Certified Instructors with extensive graphic design expertise. Check our Website Duration: 10 hours. Approach: 1-on-1 and personalized attention. Schedule: 1-on-1 sessions, available Monday to Saturday from 9 am to 7 pm.   Course Title: Comprehensive Adobe InDesign Training Duration: 10 Hours Session 1: Introduction to Adobe InDesign (1 hour) Overview of InDesign interface and tools Document setup: page size, margins, and columns Basic text formatting and paragraph styles Introduction to working with images and graphics Session 2: Advanced Text Formatting and Styles (1 hour) In-depth exploration of character and paragraph styles Advanced text composition techniques Managing text flow with threaded frames Incorporating special characters for typographic control Session 3: Mastering Images and Graphics (1 hour) Advanced image manipulation: resizing, cropping, and effects Text wrap options and integrating text with images Creating image frames and working with transparency Interactive elements: buttons and hyperlinks Session 4: Layout Design Techniques (1.5 hours) Grids and guides: precise alignment and spacing Working with layers for efficient design management Advanced object arrangement and distribution Utilizing master pages for consistent layout elements Session 5: Advanced Document Features (1.5 hours) Tables and data merge: organizing and automating data Interactive PDFs: forms, multimedia, and navigation Advanced print preparation: color management and preflighting Exporting for various digital and print outputs Session 6: Advanced Special Effects (1 hour) Creating drop shadows, gradients, and blending modes Working with typography on a path Advanced text and image effects Integrating Adobe Illustrator and Photoshop files Session 7: Project-Based Learning (1 hour) Participants work on a comprehensive project applying learned skills Instructor-guided project review and feedback Session 8: Tips, Tricks, and Time-Saving Techniques (1 hour) Productivity hacks and shortcuts Troubleshooting common issues and errors Best practices for efficient workflow and collaboration Session 9: Portfolio Building and Career Guidance (0.5 hour) Creating a professional portfolio showcasing InDesign projects Career advice and industry insights from the instructor Session 10: Q&A, Certification, and Course Completion (0.5 hour) Addressing participant questions and concerns Certificate of Completion distribution and course review Celebrating the completion of the Adobe InDesign training journey Upon completion of the Comprehensive Adobe InDesign Training course, participants will: Master Core Skills: Develop proficiency in essential InDesign tools, functions, and techniques for effective layout design. Advanced Text and Typography: Understand advanced text formatting, paragraph styles, and typographic controls for professional typography. Image Manipulation Expertise: Acquire skills in advanced image manipulation, text wrapping, transparency, and integration of multimedia elements. Advanced Layout Design: Learn precise layout techniques using grids, guides, layers, and master pages for consistency and visual appeal. Interactive Document Creation: Create interactive PDFs, forms, multimedia-rich content, and navigation elements for digital publications. Data Management and Automation: Master tables, data merge, and automation features for organized data presentation and streamlined workflow. Print and Export Proficiency: Understand color management, preflighting, and export settings for high-quality print and digital output. Special Effects and Integration: Apply advanced effects, gradients, blending modes, and integrate InDesign with Illustrator and Photoshop files seamlessly. Project-Based Expertise: Develop a comprehensive portfolio-worthy project, showcasing a range of InDesign skills and creativity. Efficient Workflow and Troubleshooting: Implement time-saving techniques, shortcuts, and troubleshoot common design challenges effectively. Career Readiness: Gain valuable insights into industry practices, portfolio building, and career guidance for pursuing opportunities in graphic design and desktop publishing. Versatile Learning Choices: Opt for either in-person sessions at our London center or engage in interactive online learning. Both options offer hands-on experience, detailed demonstrations, and ample chances for inquiries. Compatibility and Assistance: InDesign operates smoothly on Windows and Mac systems. Participants receive a comprehensive InDesign training manual for reference and an electronic certificate upon course completion. Additionally, enjoy lifelong email assistance from your InDesign instructor. Entry Requirements: No prior InDesign expertise is necessary. The training concentrates on InDesign 2023, relevant to recent software updates. Guarantees: We ensure exceptional value for your investment, guaranteeing your acquisition of essential skills and concepts during the training. Course Highlights: Master advanced typography techniques, including paragraph styles, character styles, and nested styles. Explore multi-page layout design, long document management, and advanced table formatting. Acquire skills to create and manipulate complex shapes, vector graphics, and custom illustrations. Learn efficient workflows for data merging, interactive documents, and digital/print output. Collaborate seamlessly with other Adobe Creative Cloud applications. Upon completion, receive a Certificate of Completion and access recorded lessons for self-paced learning. Expert Instruction: Learn from certified tutors and industry experts, gaining valuable insights, tips, and best practices for professional-level designs. Flexible Learning Options: Choose between in-person or live online sessions based on your schedule. Sessions are available Monday to Sunday, from 9 am to 8 pm, accommodating your convenience. Lifetime Support: Benefit from lifetime email support for continuous assistance. Our dedicated team is available to address your queries and challenges. Explore Adobe InDesign - Free Trial:  https://www.adobe.com/uk/products/indesign/free-trial-download.html

Adobe Premiere Pro is one of the most powerful yet affordable video editing solution currently on the market. In addition to video editing, Premiere enables you to perform colour correction and audio adjustments. This introductory course assumes no prior video editing knowledge and covers the fundamentals of non-linear editing. After taking this Adobe Premiere Pro course you will be able to edit video for film, television and the Web.

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualisations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Who is this for? Essential Adobe InDesign Training Course. Acquire Adobe InDesign basics from certified instructors. Master layout design, typography, and core design concepts. Opt for in-person or live online sessions. Receive a Certificate of Completion and lifelong email assistance. Lean desktop publishing skills and quality layouts.  Click here for more info: Website Duration: 5 hours Approach: Individualized 1-on-1 training with customized content. Schedule: Flexible sessions, available Monday to Saturday from 9 am to 7 pm. Course Outline: Module 1: Introduction to Adobe InDesign (1 hour) Familiarize with workspace and tools Create new documents with appropriate page size and margins Effectively format text and images Customize the interface for efficient workflow Module 2: Text Formatting and Styles (1 hour) Apply consistent character and paragraph styles Manage text flow using frames Organize lists with bullets and numbering Master special characters for precise typography Module 3: Working with Images (1 hour) Import and position images in documents Adjust image size and alignment within frames Create professional layouts with text wrapping around images Enhance visuals with image frames and effects Module 4: Layout Design (1 hour) Create precise grids and guides for alignment Arrange objects for balanced layouts Streamline work with layers Maintain consistency using master pages and templates Module 5: Printing and Exporting (1 hour) Understand color modes and print principles Export to PDF and other formats for diverse outputs Ensure print readiness through preflighting Efficiently archive and manage InDesign files Through practical exercises, solidify your grasp of each module, enabling you to design visually appealing layouts, craft documents for various purposes, and manage InDesign projects adeptly. Adobe InDesign's potential is vast, and this fundamentals course opens doors for you to explore diverse design projects. Seize this opportunity to unleash your creative prowess with InDesign! Upon completing the Adobe InDesign Fundamentals course, participants will be able to: Master InDesign Tools: Demonstrate proficiency in utilizing InDesign's essential tools, workspace, and interface for effective design workflows. Layout Design Skills: Create visually appealing layouts using grids, guides, and balanced object arrangements, ensuring professional-quality design. Text Formatting Mastery: Apply consistent character and paragraph styles, manage text flow, and enhance typography with special characters. Image Manipulation Expertise: Import, position, and enhance images within frames, integrating them seamlessly into layouts. Printing and Exporting Proficiency: Understand color modes, print principles, and export documents to various formats, ensuring print readiness and diverse output options. Efficient Project Management: Utilize layers, master pages, and templates for streamlined project organization and management in InDesign. Book Recommendations: "InDesign CC Classroom in a Book" by Kelly Kordes Anton and John Cruise: This official Adobe guide provides hands-on lessons and practical techniques for mastering InDesign's core features. "InDesign Type: Professional Typography with Adobe InDesign" by Nigel French: Explore advanced typography techniques, layout principles, and typographic finesse specific to Adobe InDesign. "Real World Adobe InDesign CC" by Olav Martin Kvern, David Blatner, and Bob Bringhurst: A comprehensive guide offering practical insights, tips, and real-world techniques for InDesign users of all levels. "The Adobe InDesign CS6 Book for Digital Photographers" by Scott Kelby: Focused on integrating photography with InDesign, this book provides valuable insights into creating visually stunning layouts with images. "InDesign Secrets" by David Blatner and Anne-Marie Concepción: This book is packed with expert tips, tricks, and techniques that can significantly enhance your efficiency and creativity in InDesign. 1-on-1 InDesign Courses: Personalized Learning: Tailored 1-on-1 courses designed to meet your specific learning needs and goals. Expert Instructors: Learn from industry professionals with extensive experience in animation and design. Flexible Scheduling: Schedule sessions at your convenience, allowing you to balance learning with your busy lifestyle. Comprehensive Curriculum: Dive deep into animation techniques, software mastery, and creative skills through our comprehensive courses. Hands-On Training: Get practical, hands-on experience with real-world animation projects, enhancing your skills effectively. Individual Attention: Benefit from personalized attention and detailed feedback from instructors, ensuring your progress and understanding. Professional Development: Acquire skills relevant to the industry, empowering you for career advancement in animation and related fields. Portfolio Enhancement: Develop a strong portfolio with the guidance of experts, showcasing your newfound skills and creativity. Post-Course Support: Enjoy continued support even after the course completion, ensuring you have resources for ongoing learning and growth. Certification: Receive a certificate upon course completion, validating your expertise and enhancing your professional credentials. Course Highlights: Master Adobe InDesign's key features for layout, text, images, and graphics. Learn design principles and typography techniques for visually appealing documents. Efficiently handle multi-page projects like magazines and brochures. Utilize styles, templates, and libraries for streamlined design and consistency. Explore advanced techniques for interactive PDFs and digital publishing. Earn a Certificate of Completion for your Adobe InDesign proficiency. Flexible learning options: in-person or live online sessions. Lifetime email support for ongoing assistance after the course. Adobe InDesign Learn & Support https://helpx.adobe.com â€º support › indesign Get started with Adobe InDesign. Find tutorials, the user guide, answers to common questions, and help from the community forum.

Indesign face to face training customised and bespoke. One to One Online or Face to Face

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Do you have a growing mountain of negatives and/or prints and wish to have them as digital files? This course will equip you with the skills to digitally archive your collection ready for reprinting and sharing online! It can be intimidating to approach alone, but this class will break the process down into an easy step-by-step tutorial – from scanning, to editing, and exporting. Having completed the course, participants will have a solid understanding of the required processes and can go on to take full control of their negatives and potential outputs. This workshop will take you through the scanning process – turning analogue negatives/prints into digital files – using two different scanners: an Epson flatbed and a Hasselblad virtual drum scanner. Providing an opportunity to look at how best to scan and restore prints as well as negatives, you will learn the benefits of both scanning systems and understand when and why to use them. Once images are scanned, you will then be shown how to take full advantage of all the information you have captured to really get the most out of the files. The course will guide you through the editing process using Adobe Photoshop to bring your photos up to the highest standard, utilizing colour correction, levels, adjustments as well as a walkthrough of the processes used to clean dust and scratches from your images. You will be shown how to export files for digital printing as well as for sharing online. All equipment and software will be provided for you, but in order to get the most out of the course you are encouraged to bring along a varied selection of negatives and/or prints to use during the course. It is estimated that you will have time to scan up to a dozen images during the day, so please do not bring along whole archives at this stage! Having completed the course you will be able to return to Stills to confidently use the scanning facilities here on a session or daily basis. However, much of the information and learning from these systems can be directly applied to your own home scanning setup if required.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.