721 Macro courses

Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.

Complete C programming training course description A hands-on introduction to programming in the ANSI C programming language. The course initially moves at a fast pace in order to spend as much time as possible on the subject of pointers - the area which cause the most bugs in C programs. What will you learn Write ANSI C programs Use the C libraries Debug C programs Examine existing code and determine its function. Complete C programming training course details Who will benefit: Programmers wishing to learn C. Programmers wishing to learn C++ or Java. Prerequisites: None, although experience in another high level language would be useful. Duration 5 days Complete C programming training course contents Getting started The compilation process, comments, main(), statement blocks, printf(). C data types and operators char, int, float and double, qualifiers, arithmetic and assignment operators, precedence, Associativity. Basic I/O C libraries, stdin and stdout, getchar(), putchar(), printf() formatting. Flow control if else, dangling elses, else if, while and for loops. switch statements, the null statement, break, continue and gotos. Functions Function calls, arguments and return types, function declarations (prototypes), function definitions, scope of variables. The preprocessor Preprocessor actions, macros, #include. Libraries and their relationship with header files. Conditional compilation. More data types and operators Logical, bitwise and other operators, type conversion, casting, typedefs and access modifiers. Arrays Declaring and handling arrays, common gotchas, multidimensional arrays. Pointers What are pointers? Why they are so important, declaring and using pointers,The three uses of the *,pointer example - scanf, pointers as arguments. More pointers Golden rules of pointers and arrays, pointers to arrays, pointer arithmetic, arrays of pointers, multiple indirection. Character/string manipulation Arrays of characters, string definition, working with strings, String library. Program arguments argc and argv, example uses,char *argv[] versus char ** argv. Program structure and storage classes Globals (externals), multi source programs, the look of a C program. Structures Declaration, the . and - operators, unions and bitfields. Library functions File handling, fopen and fclose, reading from and writing to files, fseek().calloc() and malloc()

Sports Nutrition: Sports Nutrition Course Online Whether you are a bodybuilder, a professional athlete, or simply working out to improve your health, sports nutrition is important for getting the most out of your physical activity. Better nutrition and hydration decisions can lead to improved performance, recovery, and injury prevention. If you regularly exercise and want to gain sound advice and specialist knowledge in this area, this Sports Nutrition: Sports Nutrition Course is perfect. Learning Objectives By the end of this Sports Nutrition: Sports Nutrition Course, the learner will be able to: Understand the basics of Sports Nutrition and its classification, including Macro and Micronutrient 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. This Sports Nutrition: Sports Nutrition Course will give you sports nutrition advice to help you understand the main nutritional areas and keep your diet well balanced, healthy, and supportive towards the fitness level you want to maintain or achieve. The purpose of this Sports Nutrition: 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. Courses including with this bundle. Course 01: Diploma in Sports Nutrition Course 02: Level 1 Diet and Nutrition Course 03: Level 2 Certificate in Understanding Nutrition and Health Course 04: Level 5 Nutritional Therapy Course Course 05: Sports First Aid Course 06: Sports Coaching Course 07: Personal Trainer [ Note: Free PDF certificate as soon as completing the Sports Nutrition: Sports Nutrition Course Sports Nutrition: Sports Nutrition Course Online This Sports Nutrition: Sports Nutrition Course consists of 11 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: Sports Nutrition Course After completing Sports Nutrition: Sports Nutrition Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Sports Nutrition: Sports Nutrition Course After completing the Sports Nutrition: Sports Nutrition Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Sports Nutrition: Sports Nutrition Course Online The Sports Nutrition: Sports Nutrition Course is designed for candidates who want to advance their careers as a Nutritionist, Chef, Dietician, Health Service Manager. Athletes, coaches, and personal trainers can also enrol in this course for self-improvement. Requirements Sports Nutrition: Sports Nutrition Course Online To enrol in this Sports Nutrition: Sports Nutrition Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Sports Nutrition: Sports Nutrition Course. Be energetic and self-motivated to complete our Sports Nutrition: Sports Nutrition Course. Basic computer Skill is required to complete our Sports Nutrition: Sports Nutrition Course. If you want to enrol in our Sports Nutrition: Sports Nutrition Course, you must be at least 15 years old. Career path Sports Nutrition: Sports Nutrition Course Online This Sports Nutrition: Sports Nutrition Course will help you open up opportunities in the following career paths: Sports Nutritionist Food Technologist Lead Nutritionist

Our Economic and Financial Modelling courses are suitable for economists, researchers and regulators in policy making institutions such as central banks, ministries of finance, trade and investment, economic planning authorities, regional/international policy institutions, think tanks, petroleum industry and other business/economic sectors that make use of statistical and econometric modelling techniques.

This course aims to teach the programming language C++ with an emphasis on the modern features introduced in C++17. The course will cover both old and new concepts in C++, including classes, operator overloading, inheritance, polymorphism, templates, and concurrency. By the end of the course, the students will have gained the knowledge needed to become proficient C++ developers.

MPEG training course description This course studies the MPEG standards for video and audio compression. A major focus is on MPEG-4 and MPEG-TS. Hands on includes decoding and analysing MPEG streams. What will you learn Recognise the main MPEG standards. Describe the techniques used in MPEG video and audio compression. Compare MPEG2m MPEG4 and MPEG-H. Describe the MPEG-TS. Analyse MPEG streams. MPEG training course details Who will benefit: Anyone working with MPEG. Prerequisites: None. Duration 2 days MPEG training course contents Introduction What is MPEG? MPEG and VCEG, MPEG 1, MPEG 2, MPEG-3, MPEG-4, MPEG-H, others, codecs and containers, licensing and patents, parts and layers (System, Video, Audio, others). MPEG2 DVD, DVB, characteristics, MPEG2 Part2, audio MPEG2 Part 7 (AAC). MPEG tools Wireshark, vlc, analysers, decoders, ffmpeg, wowzer. MPEG2 Video compression Sampling, bit rates, resolution. Inter and Intra frame coding, I, B, P frames, GOP, slices, blocks, macroblocks. Motion estimation. Hands on Analysing MPEG frames. MPEG4 Profiles and levels, Enhancements, Parts 1,2,3, Part 10 and AVC, Part 14 and mp4. Performance versus MPEG2. MPEG audio Coding, frequencies, bit rates. MPEG-TS PES, Transport Streams, TS elements, packets, PID, Programs, PSI, PAT, PMT, synchronisation, PCR, PTS. MPEG-H Part 2 HEVC, benefits, improvements. Video codecs What is a CODEC, pictures and audio, digitisation, sampling, quantisation, encoding, compressing.

Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++

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 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. 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 BM 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 Management 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 Management Programme right for me? The ultimate aim of the SEMP Business Management program is to prepare participants to work in a management position in an ever-changing international environment where advanced technology and multicultural situations occupy an increasingly important place in the daily lives of companies. It exposes you to key issues in business management, provides insight into relevant social, political, legal, and macroeconomic conditions affecting business. The online Programme is suited to a wide range of interests but is particularly relevant to those who plan to have a career in organizations that conduct business beyond a single domestic economy.   Why SEMP Business Management? Succeeding in today's economy requires the ability to communicate and collaborate across the globe with a diversified workforce. The business world is constantly fluctuating, and successful business people must be adaptive to change and capable of working with diverse populations. The function of business is to create fiscal integrity and stability, prosperity, employment, and beneficial products and services. The online SEMP Business Management Programme will help you understand big and small businesses, entrepreneurship, along with the important relationship between businesses and the communities they serve.   Who should enrol in this online Certificate Program? The SEMP Business Management 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 are seeking an opportunity to obtain a richer, deeper understanding of management skills. The SEMP Business Management Program is ideal for professionals of all levels. This Programme provides practical skills to overcome daily challenges by providing participants with the latest management 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 Programme as its as Online Programme.

Learn to make your raw images more beautiful and appealing with a few simple tricks and easy to follow instructions! This photo editing course aims at providing you with a complete guideline to edit photos in Adobe Lightroom Classic CC and Adobe Lightroom CC. With this course, you will discover engaging lessons that incorporate Adobe Lightroom Classic CC, Adobe Lightroom CC, and Adobe Lightroom CC on a smartphone. Each and every topic of this course is presented in an easy to grasp manner. You will also develop your skills by learning a range of Photoshop techniques such as adjustment and white balance, vibrant and colour strength and many more. On completion, you will be able to manipulate images according to the need and create eye-catching photographs for branding and marketing. Work with this popular program to its full potential, whether you are using Lightroom Classic CC, Lightroom CC or Lightroom on the smartphone! Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal for people who want to start working as a receptionist, office administrator, office manager, administrative assistant or secretary Entry Requirement for this photo editing course: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module: 01 0 Lightroom Course Promo 00:02:00 0.1 Promo for Lightroom CC Course 00:02:00 0.1 Promo Video Lightroom Classic CC Course 00:02:00 1.1 Course Introduction 00:03:00 1.1 Into Video 00:02:00 1.1 Intro Video V2 00:04:00 Module: 02 2.1 Importing 00:08:00 2.2 Organizing with Collections 00:07:00 2.4 Face Tagging 00:03:00 Module: 03 3.1 Enhancing Eyes 00:06:00 3.1 Crop and Rotate in Lightroom Classic CC 00:05:00 3.2 Whitening Teeth 00:03:00 3.2 Crop and Straighten 00:11:00 3.3 Exposure in Lightroom Classic CC 00:06:00 3.3 Smoothing Skin 00:02:00 3.4 Color and Saturation in Lightroom Classic CC 00:09:00 3.4 Removing Wrinkles 00:07:00 3.5 Enhancing Lips & Changing Lip Color 00:04:00 3.5 Presence Clarity and Saturation Jon 00:05:00 3.5 Sharpening and Noise Reduction in Lightroom Classic CC 00:07:00 3.6 Cheek Enhancements and Face Contouring 00:05:00 3.6 Tone Curve 00:07:00 3.6 Vignettes, Grain and Dehaze in Lightroom Classic CC 00:06:00 3.7 Exporting in Lightroom Classic CC 00:10:00 3.7 full portrait editing techniques 00:11:00 3.7 HSL 00:07:00 3.8 Lens Corrections in Lightroom Classic CC 00:05:00 3.9 Split Tone in Lightroom Classic CC 00:05:00 3.10 Removing Blemishes with the Heal and Clone Tools in Lightroom Classic CC 00:08:00 3.11 Graduated, Radial and Brush Adjustments in Lightroom Classic CC 00:10:00 3.12 Adjustment Brush Presets in Lightroom Classic CC 00:03:00 3.12 Calibrate Your Camera Profile 00:08:00 3.13 Range Masks in Lightroom Classic CC 00:05:00 3.13 Range Masks in Lightroom Classic CC 00:05:00 Module: 04 4.1 Full Edit - Car 00:15:00 4.1 The Adjustment Brush 00:04:00 4.1 Using, Creating, and Importing Presets 00:05:00 4.2 Color Profiles 00:04:00 4.2 Full Edit - Starry Sky 00:10:00 4.2 Radial Filter 00:03:00 4.3 Full Edit - Woman and Dog 00:15:00 4.3 Graduated Filter 00:05:00 4.3 Speed Up Your Editing Workflow 00:04:00 4.4 Full Edit - Snowy Landscape 00:11:00 4.4 Panorama 00:04:00 4.4 Spot Healing Brush 00:05:00 4.5 Full Edit - Icy River 00:12:00 4.5 HDR 00:03:00 4.6 Automatically Fix Exposure & White Balance 00:02:00 4.6 Full Edit - Surfs Up 00:10:00 4.7 Full Edit - Wildlife Bird 00:15:00 4.8 Full Edit - Roses are Red 00:11:00 Module: 05 5.1 Enhance Eyes and Change Eye Color 00:08:00 5.1 Exporting Photos from Lightroom 00:09:00 5.2 Adding a Watermark Lightroom 00:04:00 5.2 Whitening Teeth 00:03:00 5.3 Smoothing Skin 00:02:00 5.4 Removing Wrinkles 00:05:00 5.5 Enhancing Lips & Changing Lipstick Color 00:03:00 5.6 Enhancing Cheeks _ Face Contouring 00:08:00 5.7 Full Portrait Edit 00:07:00 Module: 06 6.1 Moonscape 00:11:00 6.1 Portrait of a Woman 00:20:00 6.2 Landscape Editing 00:07:00 6.2 Night Edit 00:15:00 6.3 Long Exposure 00:14:00 6.3 Ocean Flash Portrait 00:09:00 6.4 Group Photo Edit 00:16:00 6.4 Product Photo 00:12:00 6.5 Nature 00:09:00 6.5 Portrait With No Flash 00:05:00 6.6 Action 00:08:00 6.6 Lightroom To Match Color For Corporate Branding Images 00:06:00 6.7 Landscape 00:12:00 6.8 Travel 00:13:00 6.9 Couples Portrait 00:18:00 6.10 Architecture Photo 00:18:00 6.11 Aerial Photo 00:09:00 6.12 Street Photo 00:14:00 6.13 Macro Photo 00:10:00 6.14 Pet Photo 00:10:00 6.15 Maternity Couple Photo 00:12:00 6.16 Interior Nursery 00:13:00 6.17 Portrait of a Man 00:19:00 6.18 Sports Photo 00:10:00 Module: 07 7.1 Intro To Lightroom Mobile 00:03:00 7.1 The Map Module 00:04:00 7.2 Syncing Lightroom Mobile 00:08:00 7.2 The Book Module 00:10:00 7.3 Edit Lightroom Mobile 00:09:00 7.3 The Slideshow Module 00:10:00 7.4 Lightroom Mobile Organizing and Sharing 00:05:00 7.4 The Print Module 00:08:00 7.5 The Web Module 00:06:00 Module: 08 8.1 Conclusion and Thank You 00:02:00 8.1 Using Lightroom Presets 00:04:00 8.2 Installing Lightroom Presets 00:03:00 Module: 09 9.1 Calibrate Your Monitor 00:03:00 9.2 Color Checker Passport 00:10:00 9.3 Tablets 00:08:00 9.4 Catalogues 00:11:00 9.5 Brighten and Whiten Teeth and Eyes 00:04:00 9.6 Remove Wrinkles in Lightroom 00:05:00 9.7 Create a Panorama in Lightroom 00:03:00 9.8 Remove Red-Eye 00:01:00 9.9 Soften Skin in Lightroom 00:03:00 9.10 Reduce Noise in Your Photos 00:05:00 Module: 10 10.1 Google NIK 00:17:00 Module: 11 11.1 full lightroom session workflow 00:07:00 Module: 12 12.1 Conclusion 00:01:00 Resources Resources - Complete Guide to Adobe Lightroom Classic CC & CC - Photo Editing Masterclass 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00