1107 Courses

Learning Objectives Introduction , Building a Basic InDesign Document , Customizing the Workspace , Modifying the Layout , Understanding Pages Panel , Working with Text , Formatting Text , Working with Color , Using Styles , Modifying Graphics , Managing Objects and Layers , Adding and Transforming Shapes , Using Effects , Working with Tables , Exporting the Document to Other Formats , Conclusion Pre-Requisites Basic computer skills.  Description This introductory course is designed to introduce students to the basic functionality and user interface of Adobe InDesign CC. In this course, Students will learn to navigate InDesign, build documents, add text and graphics, and customize the workspace. Students will also learn to modify the layout, manage pages, modify text, modify graphics, work with color, apply effects, and add and transform shapes. In addition, students will learn to manage objects and layers, format text, use styles, work with tables, export documents, and prepare for printing. Introduction to the Course Introduction 00:01:00 Section 01 Overview of InDesign 00:03:00 Touring the InDesign Interface 00:10:00 Customizing Preferences 00:09:00 Building a Document 00:09:00 Advanced Document Settings 00:09:00 Adding Graphics 00:06:00 Adding Text 00:03:00 Section 02 Using Panels and Workspace Presets 00:10:00 Document Views 00:08:00 Understanding the Control Panel 00:04:00 Section 03 Changing the Document Setup 00:06:00 Section 04 Adding, Moving, and Deleting Pages 00:06:00 Using Master Pages 00:10:00 Section 05 Selecting Text 00:03:00 Understanding Text Frame Options 00:09:00 Importing Text 00:06:00 Threading Text 00:05:00 Using Special Characters 00:10:00 Using Spell Check 00:07:00 Using the Story Editor 00:04:00 Section 06 Character Formatting 00:11:00 Advanced Character Formatting 00:10:00 Paragraph Formatting 00:10:00 Section 07 Basics of Color 00:06:00 Working with Swatches 00:08:00 Creating Swatches 00:08:00 Making Spot Color Swatches 00:03:00 Working with the Color Panel 00:05:00 Creating and Using Gradients 00:08:00 Section 08 Basics of Style 00:01:00 Managing Paragraph Styles 00:10:00 Managing Character Styles 00:05:00 Using Object Styles 00:08:00 Section 09 Defining Graphic Types 00:07:00 Placing Multiple Graphics 00:04:00 Selecting Graphics 00:05:00 Fitting Options 00:07:00 Updating Graphics 00:07:00 Placing Photoshop and Illustrator Files 00:05:00 Section 10 Managing Layers 00:10:00 Aligning and Grouping Objects 00:06:00 Wrapping Text Around an Object 00:07:00 Section 11 Adding Vector Shapes 00:08:00 Drawing Vector Lines 00:08:00 Selecting and Moving Frames 00:07:00 Scaling Arrowheads 00:05:00 Section 12 Using the Effects Panel 00:08:00 Using the Blend Modes 00:04:00 Adding and Removing Effects 00:03:00 Section 13 Creating Tables 00:10:00 Formatting Tables and Cells 00:08:00 Using Table and Cell Styles 00:08:00 Section 14 Preflighting your Document 00:09:00 Packaging your Document 00:09:00 Printing your Document 00:09:00 Converting to PDF 00:06:00 Course Recap Recap 00:01:00 Final Exam Final Exam - Adobe InDesign CC Beginner 00:20:00

Understanding commodity codes is vital to internationally trading businesses. Commodity codes are used worldwide to determine the customs duty and other charges levied on the goods when importing and exporting. They also determine any preferential treatments or restrictions and prohibitions that may apply to the goods and are used for monitoring trade volumes and applying international trade measures. This virtual half-day course will provide an insight into what commodity codes are and how getting them wrong can have a big impact on your business. By attending this course, we will ensure you: Are aware of what a commodity code is and what it is used for Understand the process of how to classify goods Successfully classify a range of goods Understand the importance of getting your commodity codes correct. Please note: If you are working towards your British Chamber of Commerce (BCC) Foundation Award, this course will count towards 1 of your 6 modules. Please make sure you select the ‘Yes’ option in the dropdown option for BCC when booking.

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for: ? System Administrators ? Patch Administrators ? SA Administrators ? Policy Setters ? IT Managers ? IT or Application Architects ? Data Center Managers ? Application Experts ? Operations Experts ? Deployment Specialists ? Application Deployment Manager Administrators ? QA Team Members and Managers ? Security Administrators ? Other technical personnel who are responsible for data center automation Overview After completing this course, you should be able to: ? Describe the Server Automation (SA) core architecture and key components of SA ? Integrate unmanaged servers into the SA managed environment and discover server information through SA ? Use the Operation System (OS) Provisioning feature of SA to automate the installation of OS onto servers ? Provision virtual servers and manage their server lifecycle through SA ? Create static and dynamic device groups to manage multiple servers as groups ? Manage packages as part of the software management feature in SA ? Use a policy-based management methodology to provision software and manage software updates ? Describe and use Application Deployment Manager (ADM) to manage an application lifecycle using SA ? Use the Application Configuration feature of SA to manage the values in configuration files on managed servers ? Manage patches on various OS platforms using a patch policy or software policy ? Use the Audit and Remediation feature of SA to ensure servers and applications are compliant with defined best practices or corporate policies ? Use the Compliance feature of SA to discover out-of-compliance servers in the managed environment and ensure that they are in compliance with corporate policies ? Use the Global Shell and Global File System (OGFS) features to explore and manage servers in an SA environment ? Create, manage, and execute scripts I SA to manage servers or server groups This five-day course provides the necessary foundation to manage the data center servers and application environment using HP Server Automation (SA) 10. The course covers the key components of SA and their functionality. Course Overview and Introduction to HP Server Automation ? Discuss the IT organization?s preference for automation ? Discuss the main features of HP SA ? Discuss the benefits of using SA ? Describe the distributed architecture of SA Exploring the Architecture and Interfaces ? Define an SA core ? Describe the functionality of each key component of SA ? Describe SA users ? Use the SA client to explore a managed server environment ? Describe the SA core architecture and key components ? Learn how to use the SA interfaces to explore the server environment Agent Functionality and Server Integration ? Differentiate the agent types ? Describe the SA agent functionality ? Specify the requirements for installing an SA agent onto an unmanaged server ? Install an agent onto an unmanaged server using the SA client and manual installation ? Troubleshoot agent installation and communication failures ? Explore the server inventory using the Device Explorer of the SA client ? Describe the Agent Tools feature within SA ? Integrate existing, unmanaged servers into the SA managed environment ? Summarize what server information is collected by the agent ? Explain the server module objects ? Explain agent extensions Provisioning Operating Systems (OS) Using OS Build Plans (OSBPs) ? Describe the Operating System (OS) provisioning feature within SA ? Describe the process of provisioning an OS on a server ? Define and run an OS Build Plan (OSBP) Dynamic Host Configuration Protocol (DHCP) Less or Static IP Provisioning ? Configure and run the Managed Boot Client(s) (MBC) ? Provision Operating Systems (OS) without using Dynamic Host Configuration Protocol (DHCP) (or by using Static IP) Managing Virtualization ? Describe the supported virtualization management features in SA ? Describe the process of provisioning virtual servers for VMware Enterprise Server Xi (VMware ESXi) and Solaris 10 ? Identify the relationship between the hypervisor and its virtual servers ? Manage the lifecycle of VMware Virtual Machines (VMs) ? Manage the lifecycle of Solaris zones ? Integrate with VMware Virtual Center using Virtualization Service (VS) Exploring Device Groups ? Explain device groups and their characteristics ? Describe the different types of device groups supported in SA ? Create static and dynamic device groups using the SA client Exploring Device Groups with Search Results ? Describe the different types of search in the SA client ? Discuss the process to save and retrieve search results ? Create device groups from search results ? Develop sample reports using advanced search Managing Packages ? Describe how to manage packages in SA ? Discuss the supported package types ? Explain how to organize the software library ? Import and export packages into the software repository ? Install and uninstall packages ? Manage Red Hat Package Manager (RPM) packages Software Management ? Describe the use of policy-based software management in SA ? Describe how to manage software policies in SA ? List the software management setup tasks ? Install and uninstall software using software policies ? Manage software updates using software policies Working with Application Deployment Manager (ADM) ? Describe the Application Deployment Manager (ADM) and its functions ? Manage the ADM ? Set permissions for ADM ? Define an application, a target, and a component ? Deploy an application ? Manage an Application Deployment job ? Describe the rollback and undeploy process ? Import and export Application Deployment data from SA Application Configuration Management ? Describe how application configurations are managed in SA ? Describe application configuration components ? Control values using an application configuration inheritance model ? Push application configuration values to servers Managing Patches ? Describe the patch management feature in SA ? View patch information ? Describe UNIX patch management tasks ? Install patches using patch policies on the Windows platform ? Identify Microsoft patch administration tasks ? Manage patches on Red Hat LINUX Working with Audits, Snapshots, and Remediation ? Describe the audit and remediation feature in SA ? Create and run audits ? Configure file audit rules ? Set audit rule exceptions ? View audit results and remediate the differences ? Describe how to use Business Service Automation Essentials (BSAE) Network to run compliance audits Enforcing Compliance ? Define server compliance concepts ? Describe the compliance management feature in SA ? Scan and view the compliance status of servers ? Remediate non-compliant servers Exploring Servers Using the Global Shell and Global File System ? Describe the Global Shell and Opsware Global File System (OGFS) features within SA ? Describe how Global Shell and OGFS features can be used to manage servers within the SA environment ? Describe how to navigate and filter data in the OGFS using the Global Shell ? Use the Remote Shell (ROSH) command to login to a managed server and execute shell scripts on a managed server ? Use the SA remote terminal feature to access and manage servers in the managed environment Scripting with SA ? Describe the script management and execution feature in SA ? Create scripts using the SA client ? Execute ad hoc or saved scripts ? View and download script results ? Describe PowerShell integration with SA ? Explain the Extensible Discovery server module ? Introduce Automation Platform eXtensions (APX) scripting Exploring Reports in SA ? Explain SA reports ? List the reports available in SA ? Generate an SA report ? Explain Business Service Automation (BSA) Essentials basics as a reporting tool OS Provisioning with OS Sequences ? Describe the OS Provisioning feature within SA ? Describe the process of provisioning an OS on a server ? Define and run an OS Sequence

Overview In an ever-digitalising world, mastery of indispensable tools becomes crucial. Enter 'MS Office Project 2013 for Beginners'. Whether you're at the inception of your professional journey or seeking to amplify your skill set, this course is your portal to proficiency in managing tasks, resources, and calendars seamlessly. Learn to pioneer your projects, presenting them with a blueprint that encapsulates efficiency and effectiveness.  Embarking on this learning voyage, you'll discover how to initiate a project, manage timeframes using calendars, direct tasks, and marshal resources, culminating in the expertise to deliver a cohesive project plan. Learning Outcomes of MS Office Project 2013 for Beginners course Comprehend the foundational framework and interface of MS Office Project 2013. Formulate and initiate new projects with clarity and foresight. Manipulate and optimise project calendars for efficient time management. Demonstrate competence in curating and organising diverse project tasks. Allocate and oversee project resources ensuring optimal utilisation. Synthesise information to present a well-structured project plan. Adopt a strategic approach to project delivery ensuring timelines and resources align. Why buy this MS Office Project 2013 for Beginners? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the MS Office Project 2013 for Beginners there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This MS Office Project 2013 for Beginners course is ideal for Individuals new to the realm of project management tools. Professionals eager to bolster their project planning capabilities. Team leaders aiming for refined time and resource management. Entrepreneurs keen on streamlining business projects. Any individual targeting enhanced organisational skills in a digital platform. Prerequisites This MS Office Project 2013 for Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This MS Office Project 2013 for Beginners was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Project Manager: Average UK salary range of £40,000 - £70,000 per annum. Operations Coordinator: Average UK salary range of £25,000 - £35,000 per annum. Business Analyst: Average UK salary range of £35,000 - £55,000 per annum. Resource Planner: Average UK salary range of £30,000 - £50,000 per annum. Project Consultant: Average UK salary range of £50,000 - £80,000 per annum. Team Lead: Average UK salary range of £45,000 - £65,000 per annum. Course Curriculum Starting a Project Project Management 101 00:13:00 Navigate and Customize the Project 2013 Interface 00:25:00 Add Tasks to a Project 00:23:00 Add Resources to a Project 00:12:00 Save a Project 00:05:00 Working with Project Calendars Manage Project Time Frames 00:10:00 Change Working Time 00:17:00 Working with Project Tasks Manage Project Tasks 00:45:00 Add Summary Tasks and Milestones 00:06:00 Working with Project Resources Manage Project Resources 00:18:00 Allocate and Level Work Resources 00:18:00 Delivering a Project Plan Print Project Views 00:06:00 Share Projects 00:03:00 Export Projects 00:08:00

Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Google Analytics Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Google Analytics Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Google Analytics Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Google Analytics Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Google Analytics? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Google Analytics there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Google Analytics course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Google Analytics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Google Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Google Analytics is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Google Analytics Module 01: Overview 00:02:00 Module 02: Navigation and Admin 00:03:00 Module 03: Creating a New Google Analytics Account 00:03:00 Module 04: Website Account Creation 00:05:00 Module 05: Connecting To WordPress Website 00:03:00 Module 06: Connecting To HTML Site 00:03:00 Module 07: Connect Custom Page and Site Builders 00:03:00 Module 08: Setting Up Annotations 00:03:00 Module 09: Setting Up Intelligence Events 00:03:00 Module 10: Set Up Custom Segments 00:02:00 Module 11: Export Data for Analysis 00:03:00 Module 12: Set Up Custom Reports 00:03:00 Module 13: Set Up Google Integrations 00:03:00 Module 14: Google Analytics Templates 00:02:00 Module 15: Real Time Reporting 00:02:00 Module 16: Setting Up Goals 00:04:00 Module 17: Third Party Integrations 00:03:00 Module 18: Audience Menu Overview 00:04:00 Module 19: Interests and Geography 00:03:00 Module 20: Conclusion 00:01:00 Assignment Assignment - Google Analytics 00:00:00

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. Overview After completing this course, you will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Use encryption and auditing features to protect data Describe recovery models and backup strategies Backup and Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure. 1 - Creating advanced functions Lesson 1: Converting a command into an advanced function Lesson 2: Creating a script module Lesson 3: Defining parameter attributes and input validation Lesson 4: Writing functions that accept pipeline input Lesson 5: Producing complex pipeline output Lesson 6: Using comment-based Help Lesson 7: Using Whatif and Confirm parameters 2 - Using Microsoft .NET Framework and REST API in Windows PowerShell Lesson 1: Using .NET Framework in PowerShell Lesson 2: Using REST API in PowerShell 3 - Writing controller scripts Lesson 1: Understanding controller scripts Lesson 2: Writing controller scripts with a user interface Lesson 3: Writing controller scripts that create reports 4 - Handling script errors Lesson 1: Understanding error handling Lesson 2: Handling errors in a script 5 - Using XML, JSON, and custom-formatted data Lesson 1: Working with XML formatted data Lesson 2: Working with JSON formatted data Lesson 3: Working with custom-formatted data 6 - Enhancing server management with Desired State Configuration and Just Enough Administration Lesson 1: Implementing Desired State Configuration Lesson 2: Implementing Just Enough Administration 7 - Analyzing and debugging scripts Lesson 1: Debugging in Windows PowerShell Lesson 2: Analyzing and debugging an existing script 8 - Understanding Windows PowerShell Workflow Lesson 1: Understanding Windows PowerShell Workflows Lesson 2: Running Windows PowerShell Workflows

Get ready for an exceptional online learning experience with the Procurement, Product Management, Quality, and Retail Management & Commercial Law bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Procurement, Product Management, Quality, and Retail Management & Commercial Law is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Procurement & Product Management package has something for everyone. As part of the Procurement, Product Management, Quality, and Retail Management & Commercial Law package, you will receive complimentary PDF certificates for all courses in Procurement & Product Management bundle at no extra cost. Equip yourself with the Procurement & Product Management bundle to confidently navigate your career path or personal development journey. Enrol our Procurement & Product Management bundletoday and start your career growth! This Procurement & Product Management Bundle Comprises the Following CPD Accredited Courses: Certificate in Purchasing and Procurement Product Management Quality Management Anti Money Laundering (AML) Level 3 Training Commercial law CSR Policies & Supply Chain Management Cost Control & Project Scheduling Purchase Ledger Retail Management SAP Controlling (CO) - Product Costing S4HANA Logistic Management Import/Export Warehouse Safety Transport Manager Business Plan for Entrepreneurs Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: By completing the Procurement, Product Management, Quality, and Retail Management & Commercial Law course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Procurement & Product Management Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Procurement & Product Management Bundle. Build a strong knowledge base in your chosen course via the Procurement & Product Management Bundle. Benefit from the flexibility and convenience of online learning. With the Procurement & Product Management package, validate your learning with a CPD certificate. Each course in Procurement, Product Management, Quality, and Retail Management & Commercial Law bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Procurement, Product Management, Quality, and Retail Management & Commercial Law, a rich anthology of 15 diverse courses. Each course in the Procurement & Product Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisProcurement, Product Management, Quality, and Retail Management & Commercial Law bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Procurement, Product Management, Quality, and Retail Management & Commercial Law bundle offers you the flexibility and convenience to learn at your own pace. Make the Procurement & Product Management package your trusted companion in your lifelong learning journey. CPD 205 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Procurement, Product Management, Quality, and Retail Management & Commercial Law bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Procurement, Product Management, Quality, and Retail Management & Commercial Law course. Career path Unleash your potential with the Procurement, Product Management, Quality and Retail Management & Commercial Law bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with this bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Master Adobe InDesign with our comprehensive course! Learn design techniques, create multi-page documents, and unlock Adobe's potential.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Using VBA with Form Controls Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00