1073 Courses

Overview This comprehensive course on Complete Microsoft Access Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Access Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Complete Microsoft Access Course. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Access Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 58 lectures • 08:04:00 total length •Orientation to Microsoft Access: 00:39:00 •Create a Simple Access Database: 00:10:00 •Get Help and Configure Options in Microsoft Access: 00:06:00 •Modify Table Data: 00:17:00 •Sort and Filter Records: 00:05:00 •Create Basic Queries: 00:15:00 •Sort and Filter Data in a Query: 00:14:00 •Perform Calculations in a Query: 00:08:00 •Create Basic Access Forms: 00:07:00 •Work with Data on Access Forms: 00:23:00 •Create a Report: 00:12:00 •Add Controls to a Report: 00:12:00 •Enhance the Appearance of a Report: 00:05:00 •Prepare a Report for Print: 00:03:00 •Organize Report Information: 00:15:00 •Format Reports: 00:12:00 •Relational Database Design: 00:16:00 •Create a Table: 00:09:00 •Create Table Relationships: 00:09:00 •Create Query Joins: 00:14:00 •Relate Data Within a Table.avi: 00:04:00 •Work with Subdatasheets from: 00:05:00 •Use Field Validation: 00:16:00 •Use Form and Record Validation: 00:14:00 •Create Parameter Queries: 00:12:00 •Summarize Data: 00:06:00 •Create Subqueries: 00:07:00 •Create Action Queries: 00:05:00 •Create Unmatched and Duplicate Queries: 00:06:00 •Data Normalization: 00:10:00 •Create a Junction Table: 00:04:00 •Improve Table Structure: 00:06:00 •Include Control Formatting in a Report: 00:04:00 •Add a Calculated Field to a Report: 00:05:00 •Add a Subreport to an Existing Report: 00:07:00 •Add Controls to Forms: 00:11:00 •Enhance Navigation and Organization of Forms: 00:14:00 •Apply Conditional Formatting: 00:04:00 •Import Data into Access: 00:08:00 •Export Access Data: 00:06:00 •Link Tables to External Data Sources: 00:05:00 •Create a Mail Merge: 00:02:00 •Create a Macro: 00:08:00 •Restrict Records by Using a Condition: 00:04:00 •Validate Data by Using a Macro: 00:05:00 •Automate Data Entry by Using a Macro: 00:04:00 •Manage a Database: 00:08:00 •Determine Object Dependency: 00:04:00 •Manage a Database: 00:07:00 •Determine Object Dependency: 00:04:00 •Document a Database: 00:04:00 •Splitting a Database for Multiple User Access: 00:05:00 •Implement Security: 00:03:00 •Convert an Access Database to an ACCDE File: 00:04:00 •Package a Database with a Digital Signature: 00:01:00 •Create a Database Switchboard: 00:05:00 •Modify a Database Switchboard: 00:02:00 •Set Start up Options: 00:04:00

Description Register on the Maya & Unity 3D: Modeling Environments for Mobile Games today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Maya & Unity 3D: Modeling Environments for Mobile Games course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.   Course Content Maya & Unity 3D: Modeling Environments for Mobile Games Module 01: Get To Know Your Instructor and the Course 00:02:00 Module 02: Modeling the Base of the Island 00:17:00 Module 03: Modeling the Buildings 00:36:00 Module 04: Unwrap, Texture And Apply Materials 00:14:00 Module 05: Add Flowers, Birds and Background 00:13:00 Module 06: Export the Models from Maya to Unity 00:05:00 Module 07: Import and Setup the Project in Unity 00:04:00 Module 08: Add Our Mesh to the Scene 00:05:00 Module 09: Materials and Textures 00:06:00 Module 10: Setup Camera and Lightning 00:06:00 Module 11: Bake the Light Map 00:08:00 Module 12: Add Camera Effect to Polish the Scene 00:03:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Master VN Video Editor from scratch with our beginner-friendly course. Learn to import, edit, and enhance videos with text, music, effects, and more, crafting captivating content with ease.

Description: Are looking forward to learning each and every single details of Microsoft Office 2016? Then you are at the right place! Microsoft Office 2016 Essentials is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text, adjust cells, create columns, rows and much more. Next, Microsoft PowerPoint will help you to learn to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Microsoft Outlook will help you to set up and use Outlook on Windows. It will also assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and much more. Overall, this course gives you all information to access Microsoft Office 2016. Register today and get benefit from this course. Learning Outcomes: Word 2016 user interface, creating basic documents and utilizing help Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists Understanding the commands on the home tab and mini toolbar Paragraph layout tool, borders, shading, styles and formatting management techniques Maximizing your ability to utilize tables within Word 2016 Inserting symbols and special characters along with techniques for adding them Managing your page's appearance with colours, borders, watermarks, headers, footers and page setup dialog box Reviewing documents through spell check, research pane and thesaurus Document accessibility options Customizing the user interface, modifying save options and managing other file types Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses Customize reading options, work with attachments and manage message responses Managing and organization of messages with the help of tags, flags, other commands and folders Using calendar options to manage appointments and meetings Using People workspace to create, update, view and organise contacts Managing tasks and notes Creating and managing Quick Steps, and customizing the interface according to needs Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records, and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format 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 Essentials 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 Essentials 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.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Adobe InDesign Training bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Adobe InDesign Training bundle will help you stay ahead of the pack. Throughout the Adobe InDesign Training programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Adobe InDesign Training course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Adobe InDesign Training Bundle Consists of the following Premium courses: Course 01: Adobe InDesign Training Course 02: Advanced Diploma in User Experience UI/UX Design Course 03: Level 2 Adobe Graphics Design Course Course 04: Basic Adobe Photoshop Course 05: Drawing and Illustration Level 2 Course 06: Diploma in Animation Design Course 07: Revit Architecture Ultimate Interior Design Course Course 08: Arts Management Course 09: Diploma in Becoming Career Smart Course 10: Freelancing on UpWork Course 11: Time Management So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Adobe InDesign Training: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum: Course 01: Adobe InDesign Training Module: 01 1 Intro Indesign 2 - Course Downloadables 2 Conclusion InDesign 3 Let's Start Creating! 4 InDesign Workspace 5 The Workspace 6 Customize Your Workspace 7 Create a New Document 8 Navigating and Zooming 9 Setting up Your Document 10 Working with Pages 11 Working with Multiple Documents 12 Challenge: Create a Mock Setup Document 13 Assignment Solution Module: 02 14 - Saving and Exporting 15 - Creating a Real Estate Listing 16- Placeing Image 17 - Placing Text 18 - Preflighting 19- Formatting and Flowing 20 Text Wrap 21 - Text on Paths 22 - Craislist Assignment 23 My Version Module: 03 24 Intro Multi -Page Documents 25 - Master Pages 26 - Page Numbers 27 - Master Text Frames 28 - Threading Text 29 - Placeholder Frames 30 - Styles 31 - HyperLinks 32 - Layer Panel 33 - 4 Page Assignment 34 - My Version 5 Page Module: 04 35 - Creating a Table 36 - Formatting table 37 - Assignment Report 38 - My Version 39 - Color Swatches 40 - Additional Tools 41- Shapes 42 - Keyboard Shortcuts 43 - Finishing Work 44 - Export Settings 45 - Final Project Course 02: Advanced Diploma in User Experience UI/UX Design Module 01: UX/UI Course Introduction Module 02: Introduction To The Web Industry Module 03: Foundations of Graphic Design Module 04: UX Design (User Experience Design) Module 05: UI Design (User Interface Design) Module 06: Optimization Module 07: Starting a Career in UX/UI Design Course 03: Level 2 Adobe Graphics Design Course LESSON 01 Basics of Graphic Design LESSON 02 Foundation in Design LESSON 03 Photoshop Basics LESSON 04 Designers go to Software LESSON 05 Illustrator Introduction and Typography LESSON 06 Creating Logos with Illustrator LESSON 07 Logo Design Basics LESSON 08 Adobe in Design and Print Work Introduction Course 04: Basic Adobe Photoshop Section 01: Shortcuts & the Brush Section 02: Layers Section 03: Modify Your Portrait Section 04: Watermark & Figures Section 05: Modify Your Text Course 05: Drawing and Illustration Level 2 Introduction Perspective Shading Measuring Still Life Drawing Drawing a Portrait Drawing a Tree Course 06: Diploma in Animation Design INTRODUCTION THE 12 PRINCIPLES OF ANIMATION JUMPING ELEPHANT WALKCYCLE RUNCYCLE DIALOGUE Course 07: Revit Architecture Ultimate Interior Design Course Module 01: Modelling and Rendering Office Interior Module 02: Modelling and Rendering Living Room Course 08: Arts Management Module 01: Introduction to Arts Management Module 02: Planning in Arts Management Module 03: Financial Management in Arts Module 04: Fundraising in Arts Management Module 05: Marketing in Arts Module 06: Organisational Perspectives Module 07: Leadership and Entrepreneurship Module 08: Cultural Policy Module 09: Globalisation and Internationalisation in Arts Management Module 10: Career in Arts Management Course 09: Diploma in Becoming Career Smart Module 01: Understanding the Talk Module 02: Getting Prepared to Make the Call Module 03: Creative Openings Module 04: Making Your Pitch Module 05: Handling Objections Module 06: Sealing the Deal Module 07: Following Up Module 08: Setting Goals Module 09: Managing Your Data Module 10: Using a Prospect Board Course 10: Freelancing on UpWork Introduction & Overview Setting Up Your UpWork Profile Submitting Proposals To Jobs Pricing, Upgrading & Closing Sales Conclusion Course 11: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Adobe InDesign Training bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Adobe InDesign Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special The Basics of ArcGIS for Hydrology Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The The Basics of ArcGIS for Hydrology Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This The Basics of ArcGIS for Hydrology Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This The Basics of ArcGIS for Hydrology Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this The Basics of ArcGIS for Hydrology? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the The Basics of ArcGIS for Hydrology there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This The Basics of ArcGIS for Hydrology course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This The Basics of ArcGIS for Hydrology does not require you to have any prior qualifications or experience. You can just enrol and start learning.This The Basics of ArcGIS for Hydrology was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This The Basics of ArcGIS for Hydrology is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction to ArcGIS software Introduction to ArcGIS software 00:09:00 Selection by Location, attributes, clip features and tables to Excel 00:11:00 Performing actions on the data: change the projections, dissolve, clip 00:13:00 From .TXT and .DXF to shapefile 00:10:00 Calculations with attribute table and KML files in ArcMap 00:11:00 Export from ArcMap to PDF 00:11:00 ArcScene 3D 00:08:00 GIS Example Test 00:15:00 AutoCAD fixing polygon coordinates 00:14:00 Section 02: ArcGIS for Hydrology Download hydrological data 00:06:00 Calculate flow direction and flow accumulation 00:09:00 Watershed delineation 00:10:00 Clip layers to watershed boundary 00:10:00 Stream segments and catchments areas 00:09:00 Stream order convert to vector 00:10:00 Spatial join to catchments 00:11:00 Join stream id to stream order 00:08:00 Map data and initial layout 00:11:00 Add and format map elements 00:14:00 Resources Resources - The Basics of ArcGIS for Hydrology 00:00:00 Assignment Assignment - The Basics of ArcGIS for Hydrology 00:00:00

Description: Adobe InDesign is a desktop publishing software application that mostly used by creative professionals to design printed or electronic publications, such as posters, flyers, brochures, magazines, newspapers, presentations, books, ebooks, etc. Enrolling in the Level 3 Diploma in Adobe InDesign will give you the opportunity to learn the techniques of using the Adobe InDesign. In this course, you will learn how to work with the software, as well as create and format tables, print projects, and other essential tools. Apart from these, the course also teaches you the keyboard shortcuts for making your work simple and quicker. You will learn to create simple vector illustrations using the tools available in InDesign. Upon completion of the course, you will able to create a layout with a combination of text, images and colour, or with either text or images alone, and you can cope without any difficulty by only using InDesign. If you want to be creative in your ideas and designs, then InDesign is superb for enabling your creativity. Who is the course for? Anyone who wants to learn Adobe InDesign Anyone wanting to design professional flyers, PDFs, eBooks, and other publications Entrepreneurs, online businesses, artists, graphic designers - anyone who wants to learn this amazing Adobe application Entry Requirement: 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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. Module: 01 1 Intro Indesign FREE 00:02:00 2 - Course Downloadables 00:01:00 2 Conclusion InDesign 00:02:00 3 Let's Start Creating! 00:14:00 4 InDesign Workspace 00:08:00 5 The Workspace 00:06:00 6 Customize Your Workspace 00:08:00 7 Create a New Document 00:06:00 8 Navigating and Zooming 00:03:00 9 Setting up Your Document 00:00:00 10 Working with Pages 00:08:00 11 Working with Multiple Documents 00:03:00 12 Challenge: Create a Mock Setup Document 00:01:00 13 Assignment Solution 00:02:00 Module: 02 14 - Saving and Exporting 00:05:00 15 - Creating a Real Estate Listing 00:01:00 16- Placeing Image 00:12:00 17 - Placing Text 00:10:00 18 - Preflighting 00:05:00 19- Formatting and Flowing 00:09:00 20 Text Wrap 00:11:00 21 - Text on Paths 00:09:00 22 - Craislist Assignment 00:02:00 23 My Version 00:14:00 Module: 03 24 Intro Multi -Page Documents 00:03:00 25 - Master Pages 00:09:00 26 - Page Numbers 00:04:00 27 - Master Text Frames 00:04:00 28 - Threading Text 00:08:00 29 - Placeholder Frames 00:04:00 30 - Styles 00:11:00 31 - HyperLinks 00:06:00 32 - Layer Panel 00:13:00 33 - 4 Page Assignment 00:01:00 34 - My Version 5 Page 00:21:00 Module: 04 35 - Creating a Table 00:12:00 36 - Formatting table 00:16:00 37 - Assignment Report 00:01:00 38 - My Version 00:18:00 39 - Color Swatches 00:07:00 40 - Additional Tools 00:10:00 41- Shapes 00:05:00 42 - Keyboard Shortcuts 00:04:00 43 - Finishing Work 00:04:00 44 - Export Settings 00:07:00 45 - Final Project 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Practical Excel training that will turn you into a certified Excel master About course Become a master of Excel Learn how to use the crucial Excel functions and tools. Learn from the experts The course is conducted by an Excel specialist with many years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you want to master Excel quickly and efficiently? We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas. Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period. You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic. On top of everything, after completion of the course, you will receive certificate confirming your skills. Join the Excel course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Lewis Hardin Excel expert The Excel course is conducted by an MS Excel expert and trainer. He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program. Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way. Overview of the course: The Excel course program: I. Module 1 – Editing Basic issues Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts. Editing and formatting Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit. Graphic and special elements Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments. II. Module 2 – Analysis and modeling Create charts and tables Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts. Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts. Filters (Slicer and Timeline): PivotTables and Plain Tables. Use formulas Rules for working on formulas. Review and application of formulas. Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking. Working on data (databases) Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis). III. Module 3 – Review, view and print Review and data protection Checking: spelling; thesaurus; workbook statistics. Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink. View, printing and formats View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros. Printing: print area; page settings; margin settings; sheet adjustment. File formats and saving. IV. Module 4 – Advanced issues Advanced features Work with other apps Tools and plugins for professionals V. Tests Tests and repetitions of acquired knowledge The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training. Final test After completing the final test at the end of the Excel course, you will get certified. VI. Tasks Practical tasks and exercises Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level. VII. Bonus materials for the course Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more. Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert 

CPD Certified Diploma | 10-in-1 Premium Bundle | Free PDF Certificate | Updated Lesson Plan | Learner Support

Explore the vibrant world of social media video production with our course, 'YouTube and Instagram Video Production.' This course is an ideal launchpad for those keen to make their mark in the realm of digital content creation. Immerse yourself in the intricacies of preparing, filming, and producing engaging videos that resonate with a global audience. Start your journey by mastering the art of preparation for filming, where every detail sets the stage for impactful storytelling. Whether your interest lies in vlogging, instructional videos, or creative storytelling, this course provides the essential toolkit to bring your vision to life. Progressing through the curriculum, you will delve into the practical aspects of filming, storage, and backup, ensuring your work remains secure and accessible. The course then transitions into the art of editing, where your raw footage transforms into polished, captivating narratives. Finally, learn the nuances of exporting, publishing, and uploading your creations, ensuring they reach your audience with maximum impact. This course is designed not just to teach you the skills but to inspire and empower you to create content that stands out in the bustling world of YouTube and Instagram. Learning Outcomes Master the pre-production process including planning and preparing for filming. Acquire skills in filming techniques tailored for YouTube and Instagram. Learn efficient methods for importing, storing, and backing up video content. Gain proficiency in editing videos for maximum audience engagement. Understand the process of exporting, publishing, and uploading videos effectively. Why choose this Youtube and Instagram Video Production course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Youtube and Instagram Video Production course for? Aspiring content creators looking to excel in video production for YouTube and Instagram. Social media enthusiasts keen on producing high-quality digital content. Digital marketers aiming to enhance their video production skills. Bloggers and influencers seeking to create more engaging video content. Anyone interested in the process of video production for social media platforms. Career path Content Creator - £20,000 to £35,000 Video Editor - £22,000 to £37,000 Social Media Manager - £24,000 to £40,000 Digital Marketing Specialist - £23,000 to £38,000 Multimedia Producer - £25,000 to £42,000 Influencer Marketing Coordinator - £21,000 to £36,000 Prerequisites This Youtube and Instagram Video Production does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Youtube and Instagram Video Production was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Preparation for Filming Introduction 00:16:00 Preparation. How to Choose Your Topic 00:06:00 Creating Outline of Your Video 00:09:00 Choosing Shooting Environment 00:07:00 Complexity of Your Videos - How Not To Get Overwhelmed 00:05:00 Video Equipment - Camera, Tripod, Cards, Computer, Etc 00:13:00 Section 02: Filming Your Videos Filming. Video Diaries & Shooting Exercises 00:04:00 Creating Screencasts 00:02:00 Camera Work - Different Setups 00:06:00 Your Filming Checklist - What You Shouldn't Forget 00:03:00 Filming in Parts 00:03:00 Plan B - What to Do If Everything Goes Wrong 00:03:00 4K vs 1080p - Pros and Cons 00:03:00 Section 03: Importing, Storage & Backup Importing, Storage & Backup 00:10:00 Section 04: Editing Editing Software 00:06:00 Editing Diary 00:03:00 Editing On the Go 00:02:00 Content Libraries - Where to Find Music, Images, Graphics 00:07:00 Section 05: Exporting, Publishing & Uploading Render & Export 00:07:00 Assignment Assignment - Youtube and Instagram Video Production 00:00:00