1549 Running courses in Cardiff delivered Online

Description: Corel Quattro Pro X3 is a spreadsheet program; it is practically designed for storing, calculating and analyzing massive amount of data in an efficient way. In this {course_title] you will learn the basic concepts that revolves around this program. Spreadsheet applications are essential for running any office work. In this course, you will start off with an introduction in the basic functions and interactions with the program. After learning the basics, you will categorically move up through the hierarchy to advanced levels. This course will sharpen your skills and help you in the professional field. Learning Outcomes: Review common spreadsheet applications, opening and closing the spreadsheet application Creating a blank spreadsheet, entering, editing and deleting data Creating a spreadsheet from a template, saving it multiple times, changing default directory, opening and closing the program, and switching between open spreadsheets Utilizing the editing tools like select, undo, cut, copy, changing cell dimensions, sort and other related options Using zoom, showing and hiding toolbars, locking and unlocking rows and columns, changing basic options Inserting, naming, deleing, moving and copying worksheets Creating basic formulas, identifying errors, using cell referencing, advanced formulas and IF functions Formatting cells to include decimals, commas, date, currency, percentage; while also changing font size, type and adding effects More formatting options through quick format, text wrapping, aligning cell contents, centring titles, modifying cell orientation and applying borders and shading Creating a chart and changing its titles, background colour, and colour of other chart elements; also find out how to edit charts through the cut, copy, paste, resize, move and delete options Setting up worksheet by modifying margins, orientation, paper size and fitting the worksheet into a page How to prepare to print and carry out the printing job by creating header and footers and using print preview respectively, and explore many other related options 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? Corel Quattro Pro X3 Application Training 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 Corel Quattro Pro X3 Application Training 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. Spreadsheet Basics Getting Started 01:00:00 Creating a Spreadsheet 00:15:00 Working with Files 01:00:00 Editing Tools Part 1 00:15:00 Editing Tools, Part 2 01:00:00 Viewing Tools 00:30:00 Working With Spreadsheets Working with Worksheets 00:15:00 Working With Formulas 00:30:00 Formatting Cells 00:15:00 Advanced Formatting 00:30:00 Advanced Spreadsheet Tasks Creating a Basic Chart 01:00:00 Editing Charts 00:15:00 Setting up the Worksheet 00:15:00 Preparing to Print 00:30:00 Printing the Worksheet 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

If you prefer the convenience of learning from home, or live outside the UK, join our online hypnotherapy training. We welcome students from all over the world* and you can study at either Foundation or Practitioner levels. If you want to train during the week, our midweek class offers a blended option, including both online and in-person students. This involves attending for one full day, then thirty-eight half days (one per week in term time only). It starts in September, so the Foundation level ends in January and the Practitioner level in July. Availability of blended places is limited, so please complete the enrolment form in good time.

The complete online marketing and advertising course cover step-by-step instructions for fruitful and meaningful online advertising. You will discover the pro techniques from Professor Paul Cline and Sandor Kiss.  Many lose themselves in the ever-growing online marketing and advertising arena. It's imperative to gain the key skills to be massively successful. With the proper techniques and tools, your potential for a good income is limitless. Have you heard of sales funnels? Yes, it's a key concept in online marketing and advertising too. Learn to engage, attract and encourage your customers to take action. Discover the art of lead generation and the importance of attracting and retaining customers. The door to your future success in the online marketing and advertising industry opens here. What you'll learn How To Build An Amazing Income Generating Funnel That SELLS! The RIGHT Way To Do Online Advertising ... Like The Pros Do How To Advertise Effectively On Facebook, LinkedIn, Twitter, Google & How To Do Banner Ads Learn How The MARKETING PROS Do 'Lead Generation' To Get a Flood Of New Customers, Sales & Build Their Email List! How To Get The BEST Results from YOUR Online Advertising ... To BOOST Profits Learn How The PROS Build Huge Customer Bases & Massive Sales ... How They REALLY Drive Traffic & Make Money (NOT Some Silly System That Sounds Good ... But Doesn't Work!) Why You Should Choose 'Complete Online Marketing & Advertising Course' Access from all types of devices with internet access and optimum screen size 2.5 hours of video lessons A CPD-accredited certificate of completion Opportunity to download PDF certification promptly after successful completion of the course. Mastering the art of online advertising Obtaining the skills for creating an effective sales funnel Gaining insights into the practices of Pro advertisers Learning how to build a huge customer base and maximize sales online Who is this course for? The course is designed for internet marketers, business owners, online entrepreneurs, sales executives, internet influencers and online marketing enthusiasts. Requirements Basic Internet Connection Career Path For online entrepreneurs, the course will cover all the core aspects of online sales generation using online marketing and advertising strategies on different platforms. For expanding your business online and generating sales using organic and paid media, you need to know the principles of online marketing and formulating your sales funnel.  Funnel Building For Massive Profits Intro to Funnel Building FREE 00:01:00 Funnel Building - Part 1 FREE 00:04:00 Funnel Building - Part 2 00:07:00 Funnel Building - Part 3 00:09:00 Lead Generation, Traffic & List Building Intro To Lead Generation 00:01:00 Lead Gen - Lead Magnets 00:04:00 Lead Gen - Landing Pages 00:02:00 Lead Gen - Getting Traffic 00:05:00 LinkedIn Advertising Intro to LinkedIn Advertising 00:01:00 LinkedIn Ads - Campaign Manager 00:07:00 LinkedIn Ads - Creating ADS that SELL - Part 1 00:08:00 LinkedIn Ads - Creating ADS that SELL - Part 2 00:04:00 How To Do Banner Advertising Intro to Banner Ads 00:01:00 Banner Ads - Designing The Ad 00:04:00 Banner Ads - Ad Campaign Goals 00:05:00 Banner Ads - Setting Up & Running Campaigns 00:12:00 Twitter Ads For Fun & Profit Intro To Twitter Timeline Ads 00:01:00 Twitter Ads - Campaign Objects & Details 00:08:00 Twitter Ads - Ad Groups & Targeting 00:06:00 Twitter Ads - Creating The Ad & Launching 00:04:00 Make Profits With Facebook Ads Intro to Facebook Newsfeed Ads 00:01:00 Facebook Ads - Marketing Objectives 00:05:00 Facebook Ads - Ad Targeting & Budgeting 00:11:00 Facebook Ads - Creating The Ad 00:10:00 Search Ads - For Massive Profits Intro To Search Ads 00:01:00 Search Ads - Marketing Objectives 00:05:00 Search Ads - Ad - Groups & Keywords 00:06:00 Search Ads - Creating & Monitoring Ads 00:05:00

This is a hands-on training course with practical learning; know how to install, configure, and maintain Windows 10 in a Windows environment. Individuals who want to learn how to troubleshoot and diagnose Windows 10 and add Windows 10 to a Windows network will be highly beneficial.

Learn Scrum, a popular framework used to develop software applications through the Agile methodology. This course provides you with step-by-step instructions for learning Scrum and gaining a strong foundation toward various Scrum certifications. Learn Scrum with a build-along experience and apply Scrum in your Agile-based product team at work.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before In the UK, Value Added Tax (VAT) is a fundamental aspect of running a business, and it's essential to understand how to navigate it. Just ask Amazon, who were ordered to pay £250 million in back taxes and interest after a dispute over their VAT payments. Don't let this happen to your business! Our Value Added Tax (VAT) course covers everything you need to know to ensure you're compliant and avoid costly mistakes. This comprehensive course on Forensic Accounting: VAT, Tax, AML provides an in-depth exploration of Value Added Tax (VAT), tax accounting, and anti-money laundering regulations. You will gain a solid understanding of VAT terminology, calculation methods, taxable persons, registration requirements, and invoicing procedures. Additionally, the course covers VAT rates, exemptions, and zero-rated VAT, equipping you with the knowledge to navigate various scenarios. Furthermore, the anti-money laundering component focuses on identifying and mitigating financial risks, ensuring compliance with industry regulations. This Essentials of UK VAT at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Courses Are Included in This Bundle Course 01: Value Added Tax (VAT) Level 5 QLS Endorsed Diploma Course 02: Diploma in UK Tax Accounting at QLS Level 5 Course 03: Anti Money Laundering (AML) and KYC - QLS Endorsed Course 04: Award in Forensic Accounting at QLS Level 2 Enrol in this Forensic Accounting: VAT, Tax, AML course today and position yourself as an expert in these critical areas. Learning Outcomes of Forensic Accounting: Vat, Tax, AML Develop a comprehensive understanding of VAT terminology, calculation, and application. Master VAT registration, invoicing, and record-keeping requirements. Gain insights into VAT exemptions, zero-rated VAT, and penalties. Understand Making Tax Digital initiatives and tax accounting practices. Learn anti-money laundering regulations and risk mitigation strategies. Enhance analytical and problem-solving skills in forensic accounting. Why Choose Us? Get a free student ID card with Forensic Accounting: Vat, Tax, AML Training program (£10 postal charge will be applicable for international delivery) The Forensic Accounting: Vat, Tax, AML is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Forensic Accounting: Vat, Tax, AML course materials The Forensic Accounting: Vat, Tax, AML comes with 24/7 tutor support Value Added Tax (VAT), Tax Accounting, & Anti Money Laundering (AML) Take a step toward a brighter future with our Value Added Tax (VAT), Tax Accounting, & Anti Money Laundering (AML) bundle *** Course Curriculum*** Here is the curriculum breakdown of this course: Understanding VAT Value Added Tax Terminology and Calculation VAT Taxable Persons VAT Registration VAT Rates Invoicing and Records VAT Application in Goods, Services, and Vehicles Supply The VAT Return Tips on VAT Compliance VAT Exemptions and Zero-Rated VAT Miscellaneous VAT Issues and Penalties Making Tax Digital How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: £12.99 CPD Hard Copy Certificate: £29.99 QLS Endorsed Hard Copy Certificate: £119 CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements You will not need any prior background or expertise to enrol in this Forensic Accounting: Vat, Tax, AML course. Career path After completing this Forensic Accounting: Vat, Tax, AML course, you are to start your career or begin the next phase of your career. Forensic Accountant Tax Consultant VAT Auditor Financial Investigator Compliance Officer Fraud Analyst Certificates CPD Accredited Digital Certificate Digital certificate - £12.99 Diploma in Essentials of UK VAT at QLS Level 5 Hard copy certificate - £119 Please note that International students have to pay an additional £10 as a shipment fee.

Unleash Your Business Potential with Business Marketing Training! 🚀 Are you ready to take your business to the next level? Introducing Business Marketing Training, your gateway to mastering the art and science of effective marketing strategies! Whether you're a seasoned entrepreneur or just starting your journey in the world of business, this course is your key to unlocking unparalleled success. Why Business Marketing Training? 🎯 In today's fiercely competitive marketplace, having a solid understanding of marketing principles is non-negotiable. 🌟 Business Marketing Training empowers you with the knowledge, skills, and strategies you need to thrive in the dynamic world of modern commerce. 1. Stay Ahead of the Curve: In the ever-evolving landscape of business, staying stagnant is not an option. Business Marketing Training equips you with the latest trends, techniques, and insights to keep you steps ahead of your competitors. 2. Maximize Your Reach: Effective marketing is all about reaching the right audience at the right time. With Business Marketing Training, you'll learn how to identify your target market, craft compelling messages, and leverage various channels to maximize your reach and impact. 3. Drive Revenue Growth: At the end of the day, successful marketing boils down to one thing: driving revenue. Whether you're looking to boost sales, increase brand awareness, or expand your customer base, Business Marketing Training provides you with the tools and strategies to achieve your business goals. 4. Build Stronger Connections: In today's digital age, building meaningful connections with your audience is more important than ever. Business Marketing Training teaches you how to foster authentic relationships with your customers, driving loyalty and advocacy for your brand. Who is this for? 🤔 Entrepreneurs: Whether you're launching a startup or managing a well-established enterprise, Business Marketing Training equips you with the skills you need to navigate the complexities of modern marketing. Marketing Professionals: Are you looking to take your marketing career to the next level? Business Marketing Training provides you with the advanced knowledge and expertise you need to stand out in a crowded job market. Small Business Owners: Running a small business comes with its own unique set of challenges. Business Marketing Training gives you the tools and strategies you need to compete with larger competitors and thrive in your industry. Students and Aspiring Marketers: Just starting your journey in the world of marketing? Business Marketing Training provides you with a solid foundation in marketing principles, setting you up for success in your future endeavors. Career Path 🛣️ Upon completing Business Marketing Training, you'll be well-equipped to pursue a variety of exciting career paths, including: 1. Marketing Manager: Lead marketing initiatives, develop strategies, and drive growth for organizations across industries. 2. Digital Marketing Specialist: Master the intricacies of online marketing, including SEO, social media, email marketing, and more. 3. Brand Strategist: Craft compelling brand stories, establish brand identities, and create memorable experiences for consumers. 4. Marketing Consultant: Provide expert guidance and support to businesses seeking to enhance their marketing efforts and achieve their goals. Frequently Asked Questions (FAQ) ❓ Q: Is Business Marketing Training suitable for beginners? A: Absolutely! Business Marketing Training is designed to cater to individuals of all experience levels, from beginners to seasoned professionals. Q: How long does it take to complete the course? A: The duration of Business Marketing Training varies depending on the format and intensity of the program. However, most courses offer flexible scheduling options to accommodate your busy lifestyle. Q: Will I receive a certification upon completion? A: Yes, upon successfully completing Business Marketing Training, you'll receive a certification that demonstrates your proficiency in marketing principles and strategies. Q: Are there any prerequisites for enrolling in the course? A: While there are no strict prerequisites for enrolling in Business Marketing Training, having a basic understanding of business principles and a passion for marketing can be beneficial. Q: Can I access the course materials online? A: Many Business Marketing Training programs offer online access to course materials, allowing you to learn at your own pace from the comfort of your home or office. Enroll Today and Ignite Your Marketing Success! 🔥 Don't let your competitors steal the spotlight. Take charge of your business's future with Business Marketing Training. Enroll today and embark on a transformative journey towards marketing excellence! Course Curriculum Module 1_ Introduction to Business Marketing. Introduction to Business Marketing. 00:00 Module 2_ Market Research and Analysis. Market Research and Analysis. 00:00 Module 3_ Product Development and Positioning. Product Development and Positioning. 00:00 Module 4_ Pricing Strategies. Pricing Strategies. 00:00 Module 5_ Promotion and Advertising. Promotion and Advertising. 00:00

Introduction to Baking | Baking and Cake Decorating | Macarons Mastery | The Real and Only New York Cheesecake | Floral Buttercream Cakes | Bake a Layer Cake | Buttercream Cake Decorating | Artisan Pastry & Desserts | Sourdough Breads & Pastries Mastery | Food Safety Supervising in Catering Want to master the art of Cake Making and turn your passion into a profession? Well, look no further. With a single payment, you will gain access to our premium Cake Making Masterclass and take your cake decorating skills to a whole new level. With an understanding of the essence of cake decoration and ultimate baking, the course reveals the secrets and tricks master bakers follow to prepare delicious treats. You'll be familiar with various decorating tools, different baking styles, and ultimate cake decoration techniques to make the products even more beautiful. You'll also learn to spot the difference between a wide variety of cakes and desserts for various occasions and amaze your customers, meeting their expectations. Besides Cake Making, the course also focuses on the subject matter you need to run your own bakery business. You'll know how to start your bakery, create effective marketing strategies, and attract more customers to uplift your sales and revenue for your baking business. Finally, the course will teach you about the pastry business's ultimate food safety and personal hygiene protocols. This premium Cake Making Bundle consists of the following courses Course 01: Introduction to Baking Course 02: Cake Making Level 2 Course 03: Macarons Mastery Course Course 04: The Real and Only New York Cheesecake Course 05: Baking & Cake Decorating Online Diploma Course Course 06: Bake a Layer Cake Course 07: Artisan Pastry & Desserts - Essential Beginner Baking Course Course 08: Sourdough Breads & Pastries Mastery Course Course 09: Food Safety Supervising in Catering Diploma Course Course 10: Personal Hygiene Course 11: Complete Communication Skills Master Class for Life Gain the skills to emulate your favourite celebrity chef and make delicious cakes that delight and thrill everyone. Highlights of the Cake Making: learn how to bake cakes for different special occasions Learn how to get mix ingredients to achieve the perfect texture and colour Familiarise with various supplies and raw materials needed to bake a perfect cake Learn the basics of decorating a cake with fondant icing Get a solid understanding of hand decoration techniques Understand the process involved in transporting ordered cakes Explore presentation techniques and learn how to serve cakes professionally Understand the ins and outs of running a successful cake business Learn to make macarons from scratch, with no fancy ingredients & simple step-by-step guidance Bake French macarons with a crunchy exterior and weightless interior at home Gain a better understanding of the technical aspect of tricky macaron shells Explore experts' tips and tricks to mix, dry and bake the shells and much more Explore a wide range of design concepts, pattern designs and colour themes for creating window-display-worthy cakes Learn how to create striking flowers, stems and leaves, enhance your cake designs Understand personal hygiene and food safety policies in the UK Promote cake decorating business with effective marketing strategies Experienced tutors and mentors will be there for you whenever you need them and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Cake Making: One payment, but lifetime access to 11 CPD courses Certificates, 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 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of Cake Making Course 01: Introduction to Baking Welcome to the Course Reading a Recipe Mise en Place Choosing Ingredients Equipment Toolkit Special Notes for High Altitude What is a Butter Cake- History of Butter Cakes Important Considerations for Butter Cakes Creaming Method- Almond Butter Cake Reverse Creaming Method- Vanilla Butter Cake What is an Oil Based Cake- History of Oil Based Cakes Important Considerations for Oil Cakes Blended Method- Chocolate Olive Oil Cake Blended Method- Carrot Cake What is a Sponge Cake- History of Sponge Cakes Sponge Cake Mise en Place American Sponge Cakes American Sponge Method- Classic American Sponge European Sponge Cakes European Sponge Method- Genoise What is Simple Syrup Simple Syrup Method CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Whether you're an existing practitioner or aspiring professional, this Cake Making course will enhance your expertise and boost your CV with key skills. There is no experience or previous qualifications required for enrolment on this Cake Making course. It is available to all students, of all academic backgrounds. Requirements Our Cake Makingis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Cake Making course has been designed to be fully compatible with tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this Cake Makingcourse, it can be studied in your own time at your own pace. Career path The Cake Making course is a useful CPD certificate to possess, especially to people with careers in: Baking Expert Cake Decoration Business Owner Cake Decorator Cake Stylists Confectionery Baker Pastry Chef Professional Cake Maker Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Introduction to Baking) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

Description Explore the ways of combining various business opportunities to a cohesive successful multiple-business with the International Accredited Business Online Course course. The course teaches you the skills and strategies to put an online multi-business together. You will learn how to amalgamate diverse business opportunities to a successful and achievable 'Multi-business'. The methods of engaging your customers and the procedures of managing combined income streams will be explained in the course. Moreover, the course shows you the process of application and other formalities that you need to follow for running a multi-business without dropping balls and being overwhelmed by stress. Apart from these, the course will help you to find a profitable niche and guides you to set up your goals. The ways of producing multiple products and selling them into multiple platforms, monitoring l changes and progress, and the ways of tying up all the new income streams together into one manageable multi-business will be illustrated in the course. Finally, the system of building and promoting your multi-business using free and low costs tools will be explained. By the end of the course, you will gain a general understanding of the various structures of multiple income streams. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? International Accredited Business Online Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our International Accredited Business Online Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction to The Online Multi-Business Master Plan Course 00:03:00 Aims of this course 00:06:00 Course Structure 00:02:00 Online Business Models Online Business Models Overview 00:01:00 Business Models- Udemy 00:04:00 Business Models- Fiverr 00:04:00 Business Models- Amazon KDP 00:04:00 Business Models- Createspace 00:04:00 Business Models- Other Platforms 00:05:00 Your Multi-Business Website Your Multi-Business Website 00:04:00 Getting Started Create, Re-purpose, Repeat 00:04:00 Pick a Niche 00:12:00 Google Keyword Planner Overview 00:02:00 Pick a Platform 00:09:00 Plan, Plan & Test 00:03:00 Earn Your First Dollar 00:06:00 What if you fail- 00:02:00 Build your Systems 00:07:00 Automate and Outsource 00:03:00 Re-purpose and Repeat 00:08:00 Putting it all together 00:04:00 Promoting Your Multi-Business Promoting Your Multi-Business 00:06:00 The Complete Online Multi-Business Master Plan The Complete Online Multi-Business Master Plan 00:11:00 Essential Tools Paypal Overview 00:01:00 Fiverr Overview 00:03:00 MailChimp Overview 00:03:00 Conclusion Finally 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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