• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

721 Macro courses

Microsoft Office 2007 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

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

Microsoft Office 2007 Excel Advanced - Complete Video Course
Delivered Online On Demand1 hour 51 minutes
£21

3D AutoCAD Basics to Advanced Training Course

By ATL Autocad Training London

Why Choose 3D AutoCAD Basics to Advanced Training Course? Students learn how to create and modify both solid and surface models. This AutoCAD Training course also teaches students how to present their designs in 3D products and designs. Check our Website Duration: 16 hours Approach: 1-on-1, Book your own day and time. We are open Monday to Saturday 9 am to 7 pm.  How to Book this course? Call us on 02077202581 and we will book the dates and times you like. Flexible Schedule: 1-on-1 Face to Face or Live Online. AutoCAD 3D Training: Comprehensive Course Overview Exploration of 3D Modeling and Imaging Generating 3D Drawings Navigating the 3D Modeling Workspace Crafting 3D Shapes using Solid Tools Extruding Polylines into 3D Forms Isolating Coordinates with Point Filters Navigating and Orienting Your Model Achieving Visual Effects Converting 3D Views into 2D AutoCAD Drawings Advanced 3D Techniques Setting Up AutoCAD for 3D Mastering the User Coordinate System Leveraging UCS Options Utilizing Viewports for 3D Drawing Employing Array Tools Crafting Complex 3D Surfaces Constructing Spiral Forms Developing Surface Models Manipulating Objects in 3D Space Rendering and Visualization of 3D Drawings Introduction to Rendering Rapid Rendering Techniques Simulating Sunlight and Shadows Application and Adjustment of Materials Creating Effects with Lights and Materials Texture Mapping and Adjustments Exploration of Rendering Options Enhancing Views with Cameras Printing Rendered Drawings Simulating Natural Lighting Editing and Visualizing 3D Solids Overview of Solid Modeling Creation of Basic and Complex Solids Editing Solid Forms Improving the 2D Drawing Process Visualization and Analysis of Solids Exploration of 3D Mesh and Surface Modeling Introduction to 3D Meshes and Surfaces Creation and Editing of 3D Meshes Crafting Mesh Surfaces Conversion of Meshes to Solids Understanding and Editing 3D Surfaces Customization of Interface and Tools Customization of Workspaces Personalization of the User Interface Creation of Macros in Tools and Menus Working with Expanded Text Boxes Saving and Managing Customizations Exploration of the Diesel Macro Language Designing Custom Linetypes and Hatch Patterns Management and Sharing of Your Drawings Sharing Drawings Online ePublishing Your Work Managing Drawings with DesignCenter and Tool Palettes Exploring the Drawing Library with Content Explorer Establishment of Office Standards Conversion of Layer Settings https://www.autodesk.co.uk  Download a free 30-day trial of AutoCAD Learning outcomes after completing the AutoCAD 3D course. Professional Presentation: Create dynamic walkthroughs and presentations that effectively communicate your 3D models and designs. Certification: Obtain a certification as proof of your proficiency in AutoCAD 3D modeling, validating your skills in the industry. Mastery of 3D Modeling: Possess comprehensive skills, from fundamental concepts to advanced techniques in 3D modeling. Enhanced Career Prospects: Improve your career opportunities and prospects in various design-related fields such as architecture, engineering, and product design. Realistic Rendering: Be able to create highly realistic visualizations that enhance the quality of your designs. Practical Hands-On Experience: Gain practical experience and confidence in 3D modeling through extensive hands-on practice. Personalized Learning: Benefit from one-on-one attention and tailored training to meet your specific learning needs and pace. Lifetime Email Support: Continue to receive assistance and guidance through lifetime email support, ensuring you are supported even after completing the course. 3D AutoCAD Training Courses Gain confidence and proficiency in AutoCAD. Discover the fundamentals of 3D modeling and object creation in this introductory AutoCAD 3D course. Booking Your Training Course: Experience personalized training with our adaptable 1-on-1 sessions. You have the freedom to customize your schedule by reserving a convenient hour at your discretion. Our booking slots are available from Monday to Saturday, spanning from 9 a.m. to 7 p.m. You can also reach us at 02077202581 to make a booking over the phone. Course Duration: 10 hours "You have the flexibility to divide these 10 hours across multiple days to suit your ideal schedule." Training Method: 1-on-1 (In-person face-to-face or Live Online) Expect personalized attention, tailor-made content, a flexible learning pace, and dedicated individual support throughout your training journey. This hands-on course provides ample opportunities to experiment with newly acquired techniques and seek answers to your questions. Key Features: An introductory course tailored to AutoCAD 3D's essential features. Abundant one-on-one guidance and dedicated question time. Friendly expert trainers, small class sizes, and a comfortable learning environment. Comprehensive course materials and additional resources. Ongoing support and assistance with post-course challenges. What Will You Learn? This course will equip you with the foundational knowledge and workflows necessary to create 3D models within AutoCAD 3D. You will delve into the creation and modification of both solid and surface models. Upon completion, you will be able to: Effortlessly fashion intricate shapes by combining simple elements. Precisely extract geometries and dimensions from your creations. Easily customize the view and presentation style of your objects. Is This Course Right for You? No prior experience with AutoCAD 3D is required. This course caters to individuals proficient in working with 2D objects who aspire to construct 3D models of their designs. Gain proficiency in the fundamental tools and functionalities to create precise and professional 2D and 3D drawings, advancing to more complex techniques. Enhanced Efficiency: Discover time-saving strategies, tips, and workflows that will boost your productivity and streamline your design process within AutoCAD 3D. Versatility in Design: Develop the skills needed to undertake a wide range of projects, from architectural plans and engineering drawings to mechanical components and electrical schematics. Industry-Recognized Expertise: Cultivate in-demand skills relevant to architecture, engineering, construction, and manufacturing, paving the way for career advancement and professional development. Accessible Lesson Recordings: Access recorded lessons at your convenience to review and reinforce course material whenever necessary. Continuous Email Support: Benefit from ongoing assistance with lifetime email support, ensuring you have access to guidance, answers, and clarifications even beyond the completion of the course.

3D AutoCAD Basics to Advanced Training Course
Delivered in London or OnlineFlexible Dates
£696

Microsoft Office 2016 Word Advanced Level - Complete Video Course

4.3(43)

By John Academy

Description: By this Microsoft Office 2016 Word Advanced Level - Complete Video Course you will be introduce with the advanced level of Microsoft Word 2016. This advanced level will help you to broad up your knowledge which you got from the intermediate level. Here you will learn how to work with tables of content, footnotes and endnotes, how to insert bibliographies and indexes, how to use comments, track changes including accepting and rejecting changes, compare and combine documents, how to use mail merge and create envelope and labels, protect document ,use bookmarks, add watermarks, and customize the Ribbon, and more. You can join this course, if you have intermediate skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and join this course now. 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 2016 Word Advanced Level - 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 2016 Word Advanced Level - 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. Manipulating Images Integrate Pictures and Text FREE 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:11:00 Securing a Document Suppress Information 00:07:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Word Advanced Level - Complete Video Course
Delivered Online On Demand3 hours 38 minutes
£21

Microsoft Office 2016 Excel Beginners - Complete Video Course

4.3(43)

By John Academy

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. Therefore after completing this video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn different features of Excel program that allows you take the right business decisions for your company. 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 2016 Excel Beginners - 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 2016 Excel Beginners - 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. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Excel Beginners - Complete Video Course
Delivered Online On Demand4 hours 55 minutes
£22

Internal Audit Emerging Risks for 2021 and Beyond - Part 4

By Study Plex

This session is part four in our series on Internal Audit Focus and Emerging Risks for 2021 and Beyond. The world has changed. 2020 was an unprecedented year for all professions. Internal auditors were faced with a tremendous impact to their audit plans causing refocus and realignment of not just projects but resources. As a profession, internal auditors have traditionally focused on past events or as some would say, taking the look in the rear-view mirror. Most financial or accounting professionals can look at previous year data and tell management where past mistakes were made. With the evolving landscape, risks and economy that have been spurred on by the pandemic of 2021, internal auditors must look to stretch their skills to areas that are most valued by their organizations. Today's insight may well be tomorrow's hindsight. Part one of the series evaluated three core categories that impact the “Hot Topic” areas for internal auditors to focus on in the future. These included: Heightened Focus on Organizational Resilience Elevated Macro Environment Uncertainty Humanization vs. Dehumanization of the Workforce After reviewing these areas, we will then link them to “Hot Spot” topics as identified by the Gartner group that internal audit should be attuned to in 2021 and years forward. In session one we delved into the topics of IT Governance and Data Governance. Within Part Two of the series, we examined: Cyber Vulnerabilities Business Continuity Disaster Recovery Talent Resilience Corporate Social Responsibility Within Part Three of the series, we examined: Third-Party management Supply Chain management Data and Analytics Learning Objectives Explore Risk Management and Culture. Explore and examine risk management and culture and evaluate methods internal audit can use to evaluate their organizational processes. Identify and examine workforce management and workplace audit concepts and evaluate methods internal audit can use to evaluate their organizational processes. Recognize and examine corporate financial management concepts and evaluate methods internal audit can use to evaluate their organizational processes. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction and Overview Introduction to Internal Audit Emerging Risks for 2021 and Beyond - Part 4 00:09:00 Continuous Play Risk Culture 00:11:00 Challenges 00:11:00 Workforce Management and Workplace Audit 00:07:00 Workforce Management and Workplace Audit Cont'd 00:13:00 Corporate Financial Management 00:09:00 Summary 00:04:00 Supplementary Resources Supplementary Resources - Internal Audit Emerging Risks for 2021 and Beyond - Part 4 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Internal Audit Emerging Risks for 2021 and Beyond - Part 4
Delivered Online On Demand
£19.99

B6259 IBM Cognos Analytics - Author Reports Advanced V11.1.x

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Authors Overview Please refer to course overview This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations

B6259 IBM Cognos Analytics - Author Reports Advanced V11.1.x
Delivered OnlineFlexible Dates
Price on Enquiry

Basics of Finance

5.0(1)

By LearnDrive UK

Demystify the world of finance with our comprehensive Basics of Finance course. From understanding banking systems to mastering personal financial planning, this course is designed to equip you with the skills to make informed financial decisions in personal and corporate settings.

Basics of Finance
Delivered Online On Demand1 hour
£5

MS Access 2016 Advanced

4.3(43)

By John Academy

Description Access 2016 is a software development and graphical user interface tool that assist you to collect, report, and analyze information for the reference. To become better at MS Access take a look at our well designed MS Access 2016 Advanced course. It will help you in understanding all you need to know about the MS Access. The course aims at the students' efficiency to improve their skill in the functions of an Access database. It teaches the learners how to form joint table and use table analyzer wizard effectively. The course incorporates the fundamental issues of MS Access such as automation process with the help of VBA, creation, and modification of switchboards, and function of table events. It enables the students to configure security and access for different environments providing knowledge with the multiple uses of tools and backup system. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Access 2016 Advanced 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 MS Access 2016 Advanced 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. Introduction Introduction FREE 00:01:00 Improving the Structure of a Database Using the Table Analyzer Wizard 00:05:00 Append Querying to Normalize a Table 00:08:00 Creating a Junction Table 00:06:00 Maintaining a Database Backing Up a Database 00:02:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:02:00 Using the Database Documenter Too 00:02:00 Using the Performance Analyzer Tool 00:02:00 Working with Access Switchboards Understanding the Access Switchboard 00:03:00 Using The Switchboard Manager 00:09:00 Modifying a Switchboard 00:05:00 Setting the Startup Options 00:04:00 Configuring Access for Multiple Users Using the database Splitter 00:04:00 Configuring Trusted Locations 00:02:00 Password Protecting a Database 00:03:00 Password Protecting Modules 00:01:00 Converting a Database to an ACCDE file 00:01:00 Automating Processes with VBA Understanding VBA Basics 00:06:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:06:00 Converting a Macro to VBA 00:02:00 Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:04:00 Using the After Change Event Command 00:04:00 Conclusion Course Recap 00:04:00 Resources Resources - MS Access 2016 Advanced 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MS Access 2016 Advanced
Delivered Online On Demand1 hour 41 minutes
£18

LEVEL 1: Art Market Data and Analytical Tools

By ArtTactic

An introduction to art market data, sources, analysis and tools As the art market is gradually moving from a small niche market towards becoming a global industry – data, information and research are becoming essential tools in supporting the development and growth of both new and existing art businesses. Whilst data and research traditionally was focusing on auction data and prices of art, the new art industry is in need of a broader set of indicators to help them navigate an increasingly complex marketplace. In this course, Anders Petterson, Founder of ArtTactic and regular lecturer of Sotheby's Institute since 2005, will introduce you to the changing nature of the global art eco-system, and discuss the type of data sources, analytical tools and industry research available. The course includes: Videos: You will have access to 2h 20min of online video content. The content of this course is an in-depth look at data in the art market, and is building on what Anders Petterson is regularly teaching for MA and Executive Programmes at Sotheby's Institute, Christie's Education and ESA Business School in Beirut. Slides: The students can download pdf copies of the slides used in the presentations. Certification: The student will be issued with a certificate of completion when all the online videos and test quizzes have been completed. CPD Accredited: Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. Certification: Continuing Professional Development (CPD) Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. This means our courses comply with universally accepted principles of Continual Professional Development (CPD) and have been structured to meet the criteria of personal development plans. Join one of the online courses below and get an ArtTactic Certificate of Completion with the Continuing Professional Development (CPD) certification stamp. Your Instructor Anders Petterson, Founder of ArtTactic Anders Petterson is a leading authority on the art market, with particular focus on art market research and analysis. He is the Founder and Managing Director of ArtTactic, a London-based art market research and data intelligence company he set up in 2001. All the online courses are based on his own experience in collecting, analysing and presenting data on the global art market, and the courses will give an insight into how ArtTactic conceptualizes, designs and executes research projects linked to art market and introduces analytical models to better understand the value of art. Anders is regularly lecturing on MA and Executive courses at Sotheby's Institute, Christie's Education and ESA Business School (Beirut) covering topic such as Art Market Analysis, Art & Technology and NFTs as well as Art as an Asset Class. He is also a regular speaker on these topics at international conferences and seminars. ArtTactic is also well-known for its industry research on the art market and its intersection with other industries, such as the Deloitte | ArtTactic Art & Finance Report, TEFAF Art Dealer Finance Report 2018, and the TEFAF Art Patronage Report 2020. ArtTactic has also produced the Hiscox Online Art Trade Report annually since 2013. Anders Petterson is a founding Board Member of Professional Advisors to the International Art Market (PAIAM), a role he had between 2011 and 2021. PAIAM was founded in London in 2011 bringing together professionals who provide specialist services to the art market.such as lawyers, accountants, tax advisors, insurance specialists and logistics experts, amongst others. Connect on LinkedIn Course Curriculum Art Market Data - Models and Applications Lecture 1: Introduction by Anders Petterson, Founder of ArtTactic (2:56) Lecture 2: About ArtTactic (10:49) Lecture 3: Art Forecasting (5:28) Lecture 4: Big and Small Data in the Art Market (12:59) Lecture 5: Macro Data in the art market (20:18) Lecture 6: Micro Data and the art market eco-system (25:59) Art Market Data - Sources and Tools Lecture 7: Art Market Footprints - An Overview (9:39) Lecture 8: Auction Data (13:32) Lecture 9: Primary art market data (19:50) Lecture 10: Media and Social Media Data (9:35) Lecture 11: Crowd-sourced data (17:21) Download presentation slides Download complimentary ArtTactic Reports Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

LEVEL 1: Art Market Data and Analytical Tools
Delivered Online On Demand2 hours
£180

Sports Nutrition Training - Course

By Training Tale

Sports Nutrition: Sports Nutrition Course Our Sports Nutrition course will teach you about nutrition and its role and importance in leading a healthy lifestyle. It will also expand your knowledge so that you are well prepared to design diet plans based on your clients' needs. The sole purpose of our Sports Nutrition course is to teach an individual about the fundamental and advanced mechanisms of nutrition as a whole that will help an athlete perform at his or her best. With this Sports Nutrition, you will find it much easier to achieve success and monetise your skills. This course is destined for both part-time and full-time students and can be completed at your own pace. Enrol in the Sports Nutrition to increase your knowledge of sports and nutrition and help athletes, sportspeople, and fitness enthusiasts to achieve their goals. Whether you plan to take this course for personal or professional reasons, it will benefit you at every stage of your life cycle; after all, health is wealth. In short, knowing what foods are good for your body is extremely important for leading a healthy lifestyle. Learning Outcomes By the end of this Sports Nutrition Course, you will be able to: Describe the basics of sports nutrition and its classification, including macro and micronutrients especially designed for athletes. Get insight into the digestive system. Explain nutritional requirements according to various age groups and professions. Demonstrate planning healthy eating habits for athletic clients. Understand the framework for energy requirements. Carry out weight control and weight loss management. Explain how to design nutrients plans for specific sports competitions and to replace them afterwards. Special Offers of this Sports Nutrition Course This Sports Nutrition Course includes a FREE PDF Certificate. Lifetime access to this Sports Nutrition Course Instant access to this Sports Nutrition Course Get FREE Tutor Support from Monday to Friday in this Sports Nutrition Course Free Courses Course 01: Sports First Aid Course 02: Martial Arts First Aid ***Others Benefits Included Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Sports Nutrition: Sports Nutrition Course] Sports Nutrition: Sports Nutrition Course Industry Experts Designed this Sports Nutrition Course into 11 detailed modules. Course Curriculum of Sports Nutrition: Sports Nutrition Course Module 01: A Quick Overview of Sports Nutrition Module 02: Diet and Nutrition: Dietary Guidelines Module 03: Nutrition and Athlete Health Module 04: Diet Planning Module 05: Healthy Dieting Module 06: The Digestive System Module 07: Water Module 08: Weight Control and Weight Loss Management Module 09: The Role of the Vegetarian/Vegan in Sports Nutrition Module 10: Myth and Misinformation Module 11: Performance Boosters Assessment Method of Sports Nutrition Course After completing each module of the Sports Nutrition Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification of Sports Nutrition Course After completing the MCQ/Assignment assessment for this Sports Nutrition Course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Sports Nutrition: Sports Nutrition Course The Diploma in Sports Nutrition course is ideal for highly motivated individuals who want to improve their professional skills and train for the job of their dreams! In addition, this Diploma in Sports Nutrition is also suitable for those who want to gain in-depth knowledge on the subject and stay up to date with the latest information. Requirements Sports Nutrition: Sports Nutrition Course Students who intend to enrol in this Sports Nutrition Course must meet the following requirements: Sports Nutrition: Good command of the English language Sports Nutrition: Must be vivacious and self-driven Sports Nutrition: Basic computer knowledge Sports Nutrition: A minimum of 16 years of age is required Career path Sports Nutrition: Sports Nutrition Course Certificates Certificate of completion Digital certificate - Included

Sports Nutrition Training - Course
Delivered Online On Demand22 hours
£12