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

35447 Courses delivered Online

Special Executive Master's Programme in Personal Development Studies

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Personal Development Studies - Education Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The SEMP Personal Development Studies - Education deals with approaches involved in the learning process, which are useful for tackling the process of organizing and taking in new information for development purposes. Online Students who enroll in this Programme will examine a section of development studies that focuses on personal development, soft skills improvement, and project management. In the modules, participants will also study research and development, business writing, and general communication skills. Study skills are skills that can be learned in a short time and can be applied to all fields or career path. The course provides a solid ground for enhancing your reading and writing skills demonstratable in a professional environment. Apart from inculcating team leadership and project management skills, the course will ensure the learner creates the best business presentations and write academic grade reports and essays. The course also provides a detailed explanation of key tools and concepts for researching and avoiding plagiarism. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Development Studies the right Programme for me? As a professional, manager, or consultant, if you want to develop your individual skills in the following areas, then SEMP Personal Development Studies - Education is the right option for you:  Communication Problem Solving Critical Thinking and Conceptual Skill Creativity Multidisciplinary Approach Research Self- Reflector Why SEMP Development Studies? This non-credit-bearing course examines the various skills needed for the development of professionals across the education field, and how these improved skills can be harnessed together to produce a leading professional. To study comparative development effectively, one must draw upon many disciplines and construct a balanced understanding of historical and contemporary processes. Thus, studying development as a means for social transformation requires a blend of knowledge and perspectives ranging from communication, creative thinking, time management, and self-reflection. Who should enrol in this online Certificate Program? The SEMP Personal development Studies - Education Programme is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role or fast approaching such a position and want an opportunity to develop their personal skills. Here is a list of people who can enrol in the Programme. Non-Governmental OrganizationMembers(NGOs) International literacy Professionals Journalists Educators Archivist Consultants Economic Development Advisor Government Relations Advisor Intelligence Officer Policy Analyst Public Administrations Professionals Public Policy Advisor Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as it's an Online Course.

Special Executive Master's Programme in Personal Development Studies
Delivered Online On Demand
£2,500

Special Executive Master's Programme in Strategic Business Management

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Strategic Business Management Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. Gaining deep insight into successful business strategies is a must for business professionals and managers alike. That’s because no matter where you are in your career, it’s critical to understand the market your business is in and the effect your leadership and decision making can have on your company’s success. How else can you maintain your company’s value proposition, increase market share, and remain competitive? Strategic management is important because it helps in setting detailed goals, analyzing all our internal and external resources, analyzing our external environment, as well as stakeholder views. Good corporate governance needs an efficient strategic management process. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Strategic Business Management Programme right for me? In this online course, you will:  Gain new perspectives for building market resilience and dominance for your organization. Understand the difference between corporate and business strategy and what it takes for a corporate headquarters to add value and increase business unit success. Study best practices in key areas of corporate strategy, including diversification, mergers and acquisitions, strategic alliances, corporate governance, and strategic leadership. Why SEMP Strategic Business Management? Strategic management is important because it helps in setting detailed goals, analyzing all internal and external resources, analyzing the external environment, as well as stakeholders’ views. Good corporate governance needs an efficient strategic management process. Who should enroll in this online Certificate Program? This non-credit-bearing course benefits professionals at all levels who want to contribute to their organization’s performance. It is ideal for directors and company executives who determine strategic directions to position their organizations well so as to lead within their different industries. The SEMP Strategic Business Management Certificate program is open to anyone interested in gaining and improving their organizational management skills.   Modules What is Strategy?· Understanding Strategic Management· Understanding the Competitive Environment· Analyzing the Competitive Environment· Stakeholder Analysis, Organisational Purpose, and Organizational Vision· Understanding Core Competence· Competitive Advantages· Competitive Strategy· Strategic Choice · Strategy Formulation· Strategy Implementation· Business Ethics and Social Responsibility Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa requirements for this course as it's an Online Course.

Special Executive Master's Programme in Strategic Business Management
Delivered Online On Demand
£2,500

Special Executive Master's Programme in Business Administration

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Business Administration Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. Economic knowledge and good administration are crucial to prosperity and progress in modern society. For both customers and employees, it is important that companies and public institutions are administered well. At the same time, good administration has a significant impact on a company’s bottom line figures. One of the keywords in Business Administration is management, and as a SEMP BA student, you will gain insight into both financial and psychological aspects of management. The online Programme will provide you with a wide range of skills that will qualify you for many different positions in the public or private sectors. The courses in Business Administration will provide you with insight into Organisational theory, management psychology, marketing, planning, microeconomics and cost management. You will learn how to locate and analyze management issues, such as how to increase customer satisfaction; you will also learn to understand how companies and institutions are influenced by international conditions, technology, the global economy, or legislation. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Business Administration right for me? SEMP Business Administration Programme emphasizes preparation for practical decision making in a business environment. The online Programme will prepare you for a career in business. Students develop specialized skills and improve their capacity to analyze, communicate effectively with associates, think independently, and thrive in work situations.   Why SEMP Business Administration? The courses in Business Administration will provide you with insight into organizational theory, management psychology, marketing, planning, microeconomics and cost management. You will learn how to locate and analyze management issues, such as how to increase customer satisfaction. You will also learn to understand how companies and institutions are influenced by international conditions, technology, the global economy, or legislation. Who should enrol in this online Certificate Program? This non-credit-bearing course is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role, or fast approaching such position and are seeking an opportunity to obtain a richer and deeper understanding of management skills. It is ideal for professionals of all levels. This Programme provides practical skills to overcome daily challenges by providing participants with the latest administration principles and techniques. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa requirements for this Course as it is an Online Course.

Special Executive Master's Programme in Business Administration
Delivered Online On Demand
£2,500

Objective-C programming

5.0(3)

By Systems & Network Training

Objective-C programming training course description A hands on introduction that will allow you to master Objective-C and start using it to write powerful native applications for even the newest Macs and iOS devices! Using The step-by-step approach, will let you get comfortable with Objective-C's unique capabilities and Apple's Xcode 5 development environment. Make the most of Objective-C objects and messaging. Work effectively with design patterns, collections, blocks, foundation classes, threading, Git and a whole lot more. Every session builds on what you've already learned, giving a rock-solid foundation for real-world success! What will you learn Use Xcode 5. Declare classes, instance variables, properties, methods, and actions. Use arrays, dictionaries, and sets. Expand and extend classes with protocols, delegates, categories, and extensions. Use Apple's powerful classes and frameworks. Objective-C programming training course details Who will benefit: Developers wanting to learn Objective-C. Prerequisites: Software development fundamentals. Duration 5 days Objective-C programming training course contents PART 1: GETTING STARTED WITH OBJECTIVE-C The Developer Program: Objective-C, enrolling as an Apple Developer, setting up the development environment, Xcode. Your first project. OO programming with Objective-C: OO projects, Frameworks, classes and instances, encapsulation, accessors, Inheritance. OO features in Objective-C: Messages, methods, working with id, nesting messages, method signatures and parameters. allocating and initializing objects. Using Xcode: Xcode, source code control, git and Xcode, Using a Remote Repository. Compiler Directives: Projects, Compiler Directives, Prefix headers, main.m, .h files. PART 2: OBJECTIVE-C BASICS Messaging in a Testbed App: Setting Up the Testbed Apps, Adding a Text Field and Connecting It to Your Code, Sending a Message to the Text Field, Reviewing the Message Syntax. Declaring a Class in an Interface File: Context, Creating an Instance Variable with id, What Happens When Execution Stops, dynamic binding, Creating an Instance Variable for with the Class Name and with a Superclass Name, instance variable visibility. Properties in an Interface File: Interface Variables vs Properties, Declared Properties, Using Attributes. Implementing Properties. @synthesize, @dynamic. Methods in an Interface File: Methods in a Class, class and instance methods, Method declaration, returning complex data structures from Methods. Actions in an Interface File: Actions, Actions in OS X and iOS, disconnecting actions. Routing messages with selectors: Receiver and selector objects in messages, Objective-C Runtime, SEL and @selector (), performSelector, NSInvocation, testing whether an Instance can respond to a selector. Building on the Foundation: The Foundation Framework, Foundation Classes, Foundation Paradigms and Policies; Mutability, class clusters, notifications. Defining a Class in Implementation Files: Projects, dynamic typing, creating a new App, implementing a method, expanding Classses with init Methods. Organizing Data with Collections: Collecting Objects, Property Lists, Runtime, comparing the Collection Classes, Creating a Collection, Objective-C Literal Syntax, Enumerating collections, Testing Membership in a Collection, Accessing an Object in a Collection. Managing Memory and Runtime Objects: Managing objects in memory, managing reference counts manually and with ARC, variable qualifiers, variable autorelease. PART 3: EXPANDING AND EXTENDING CLASSES Protocols and Delegates: Subclassing, Protocols, Delegates, Looking Deeper Inside Protocols. Categories and Extensions: Comparing categories and protocols, categories vs subclasses, working with categories, class extensions, informal protocols. Associative References and Fast Enumeration: Objective-C 2.0 Time-Saving Features, Extending Classes by Adding Instance Variables (Sort of), Using Fast Enumeration. Blocks: Revisiting Blocks, Callbacks, Blocks, Exploring Blocks in Cocoa, Cocoa Blocks and Memory. PART 4: BEYOND THE BASICS Handling Exceptions and Errors: Exception and Error classes: NSException, NSError, Identifying exceptions, throwing exceptions, catching exceptions. Queues and Threading: Getting Started with Concurrency, Introducing Queues, Dispatch Sources, Using Dispatch Queues. Working with the Debugger: Logging Information, Console Logs, NSLog, Smart Breakpoints, enhancing breakpoints with messages. Using Xcode Debug Gauges for Analysis: Debug Gauges, Monitoing CPU and memory utilization, monitoring energy, Using Instruments. PART 5: OPTIONAL TOPICS C Syntax Summary: Data Types, Control Structures. Apps, Packages, and Bundles: Project Bundles, lproj Files, Asset Catalogs, plist Files, Precompiled Header Files (.pch). Archiving and Packaging Apps for Development and Testing: Archiving.

Objective-C programming
Delivered in Internationally or OnlineFlexible Dates
£4,997

Digital, Text & Voice Communicators Course

By Hi-Tech Training

The Hi-Tech Training Digital Text & Voice Communicator Course is designed to provide participants with the skills required to connect Digital, Text & Voice Communicators to an Alarm Control Panel for transmission of Digital status signals via the telephone line, GSM Network or IP network to a central monitoring station. The Digital Communicator Course’s practical application and our highly experienced trainers ensure that this course is second to none. The course is technical and practical in nature and is suitable for participants who have successfully completed the Hi-Tech Training Intruder Alarm Installation Course or equivalent.

Digital, Text & Voice Communicators Course
Delivered OnlineFlexible Dates
£85 to £685

Diploma in Entrepreneurship - Level 4 (Fast Track)

4.0(2)

By London School Of Business And Research

This Diploma in Entrepreneurship - Level 4 (Fast Track) qualification (Accredited by Qualifi, UK) has been created to develop and reward the business managers of today and the future, and to continue to bring recognition and professionalism to the management sectors. It is envisaged that this Diploma in Entrepreneurship - Level 4 (Fast Track) programme will encourage both academic and professional development so that you learners move forward to realise not just their own potential but also that of organisations across a broad range of sectors. Key Highlights of this Diploma in Entrepreneurship - Level 4(Fast track) qualification are: Program Duration: 9 Months (Fast track 6 months duration mode Available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Undergraduate degree programme. Alumni Status No Cost EMI Option Requirements This Fast Track Diploma in Entrepreneurship - Level 4 (Accredited by Qualifi, UK) qualifications has been designed to be accessible without artificial barriers that restrict access and progression. Entry to the qualification will be through centre interview and learners will be expected to hold the following: Qualifications at Level 3 OR A Level 4 qualification in another discipline and want to develop their careers in business and entrepreneurship. Career path Learners completing this Course progress to: Level 5 Diploma in Business Management, or Level 5 Diploma in Business Enterprise, or Combined Level 5 + Level 6 Diploma in Business Management - 240 Credits Qualification, or BA (Hons) in Business Management Degree qualification, or The Second year of undergraduate study, or Directly into employment in an associated profession. Certificates Certificate of Achievement Hard copy certificate - Included Once you complete the course, you would be receiving a Physical hard copy of your Diploma along with its Transcript which we would Courier to your address via DHL or Royal Mail without any additional charge

Diploma in Entrepreneurship - Level 4 (Fast Track)
Delivered Online On Demand
£1,599

Diploma in Business Management - Level 3 (Fast Track mode)

4.0(2)

By London School Of Business And Research

This fast track Diploma in Business Management - Level 3 Qualification has been created to develop and reward those learners who are looking to or already have chosen a career in a business-related sector. The rationale of the programme is to provide a career path for learners who wish to develop their care capabilities within the business sector. The outcome of this fast track Diploma in Business Management - Level 3, which is a recognised UK Qualification, is for learners to develop the skills required by organisations globally. Key Highlights of this fast track Level 3 Diploma in Business Management qualification are: Program Duration: 6 Months (Regular 9 months duration course also available) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Undergraduate degree programme. Alumni Status No Cost EMI Option Requirements This fast track Level 3 Diploma in Business Management (Accredited by Qualifi) qualifications has been designed to be accessible without artificial barriers that restrict access and progression. Learners will be expected to hold the following: Learners who have demonstrated some ability and possess Qualifications at Level 2 and/or OR work experience in a business environment and demonstrate ambition with clear career goals; Level 3 qualification in another discipline and want to develop their careers in management. Career path Learners completing the Level 3 Diploma in Business Management in fast track mode can progress to: The First year of an Undergraduate Degree in Business and Management, or Level 4 Diploma qualifications (click here to view) Directly into employment in an associated profession. Certificates Certificate of Achievement Hard copy certificate - Included Once you complete the course, you would be receiving a Physical hard copy of your Diploma along with its Transcript which we would Courier to your address via DHL or Royal Mail without any additional charge

Diploma in Business Management - Level 3 (Fast Track mode)
Delivered Online On Demand
£1,599

Human Resources Work Placement Programme

4.8(47)

By Bradstone Allington

In today’s world, the HR industry is more competitive than ever and goes beyond simply having theoretical qualifications. Candidates who desire to make an impression are required to have an understanding of a broad range of HR activities. Our 3-month training programme provides everything you need to become fully qualified in HR practice & management. Once you have completed your training session you will gain accredited certifications and three months of remote experience directly with one of our clients. After completing this programme candidates will be able to showcase that they have the following: HR practice and Management award 3 months of remote work experience Job reference Career support This comprehensive training programme has been developed to enhance your CV and boost your job prospects. CPD 120 CPD hours / pointsAccredited by The CPD Certification Service Description 3 months full access to the WPP Professional certification Digital certifications Guaranteed work placement (3 – 6 months) Learn industry-leading skills and stand out from the crowd. Information-packed practical training starting from basics to advanced testing techniques. Best suitable for beginners to advanced level users and who learn faster when demonstrated. Course content designed by considering current trends in the job market. A practical learning experience with live project work and examples. *Terms Apply Training Period: 4-12 Weeks Assessment: To pass the course learners are required to successfully pass an online examination. HR Work Experience: 3 Months after the training. HR work experience or Human Resources Job placement is optional. When can you start: You must first apply to be selected. The training takes place online. Once you finish your training modules then you can start the remote job placement. Payment Options: Full Fee:£1195 Buy Now Pay Later: Join from as little as £395 and spread the cost over monthly instalments. Who is this course for? Part Qualified, Freshly Qualified HR Students Graduates with No or little Job Experience Students Currently Studying or intending to study HR or want to refresh knowledge People who are already working in the industry but want to gain further knowledge Requirements There are no formal entry requirements for this course. We also expect the candidates to have basic knowledge of Human Resources. Career path Secure yourself an entry-level HR role.

Human Resources Work Placement Programme
Delivered Online On Demand5 days
£1,995

Microsoft Excel in Depth: Virtual In-House Training

By IIL Europe Ltd

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel in Depth: Virtual In-House Training
Delivered OnlineFlexible Dates
£850

Alarm Installation Course

By Hi-Tech Training

The Alarm Installation Course is designed to teach participants how to install an intruder alarm system in domestic, commercial or industrial premises. The Alarm Installation Course simulates the practical installation of many different alarm control panels. The course is designed to equip students with the skills and expertise to competently install a wide variety of Alarm systems on the market.

Alarm Installation Course
Delivered OnlineFlexible Dates
£685