5333 Courses in Cardiff delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Discover a holistic approach to understanding the world of coding with the enriching bundle: "C# Coding, Java and Python Programming." This remarkable course package promises an engaging blend of two prestigious QLS-endorsed programmes and five CPD QS-accredited offerings. As a testament to your efforts, every successful participant will be rewarded with hardcopy certificates, providing a tangible representation of their coding prowess. Diving into this treasure trove of knowledge, participants will uncover the intricacies of C#, Java, and Python through our QLS-endorsed courses. Each class has been meticulously structured to enhance comprehension and ensure a rewarding learning journey. Furthermore, five CPD QS-accredited courses extend the learning experience beyond, covering JavaScript, ASP.Net, Data Visualization, and Scratch. Key Features of the C# Coding, Java and Python Programming Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our C# Coding, Java and Python Programming bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Basic C# Coding QLS Course 02: Introduction to Java QLS Course 03: Diploma in Python Programming 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML Course 02: Master JavaScript with Data Visualization Course 03: Python from Scratch Course 04: Coding with Scratch Course 05: Mastering Java for Beginners & Experts In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our C# Coding, Java and Python Programming courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcome: Develop a comprehensive understanding of C#, Java, and Python programming languages. Gain insights into JavaScript and ASP.Net through CPD QS-accredited courses. Uncover the techniques of Data Visualization using JavaScript. Understand the fundamentals of coding with Scratch. Master the art of Java for both beginners and experts. Learn how to build projects from scratch using Python. Become proficient in the use of coding essentials, including HTML. Embark on an enriching journey into the realm of coding with the "C# Coding, Java and Python Programming" bundle. This carefully curated package equips learners with the fundamentals and advanced aspects of three critical programming languages. The offering also extends to five other relevant courses, all of which are CPD QS-accredited, presenting a comprehensive coding landscape. These add-on subjects dive deeper into JavaScript, ASP.Net, Data Visualization, and Scratch, making this bundle a powerhouse of coding knowledge. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring coders who aim to grasp the fundamentals and advanced techniques of key programming languages. Professionals seeking to diversify their skill set with a comprehensive understanding of coding. Students of computer science desire to deepen their understanding of critical programming languages. Existing coders looking to bolster their resumes with QLS-endorsed and CPD QS-accredited courses. Career path C# Developer: £30,000 - £45,000 Java Developer: £35,000 - £55,000 Python Programmer: £45,000 - £65,000 JavaScript Developer: £30,000 - £50,000 ASP.Net Developer: £35,000 - £55,000 Data Analyst (specialising in data visualisation): £30,000 - £60,000 (Note: Salary estimates are based on the average UK salaries as of 2023.) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

If you want to enhance your problem-solving and decision-making abilities with ChatGPT's predictive capabilities, streamline your communication, and improve efficiency in professional/personal settings, this course is for you. Acquire the skills to train and fine-tune ChatGPT for specific applications and industries.

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

CPD Certified | 8 in 1 Premium Bundle | Free PDF Certificate | Tutor Support| Lifetime Access

Recent statistics indicate a growing demand for skilled professionals in administrative, secretarial, and personal assistant roles, underlining the indispensable nature of these positions across industries. In response to this trend, our comprehensive Admin, Secretarial & PA with Office Management & Minute Taking QLS Endorsed Diploma bundle offers a strategic blend of QLS endorsed courses and CPD QS accredited modules designed to elevate your proficiency and advance your career in the administrative realm. With a holistic approach encompassing technical expertise and personal development, this Admin, Secretarial & PA with Office Management & Minute Taking bundle equips you with the essential tools to excel in diverse administrative environments. In today's dynamic workplace landscape, adaptability and multifaceted competencies are paramount. This Admin, Secretarial & PA with Office Management & Minute Taking bundle empowers you with the knowledge and skills necessary to navigate the complexities of office management, minute taking, and administrative support roles efficiently. Whether you're aspiring to enter the field or aiming to enhance your existing capabilities, this curated collection of courses provides a robust foundation for professional growth and success. Bundle Include includes: QLS Endorsed Courses: Course 01: Advance Certificate in Office Management & Administration at QLS Level 3 Course 02: Diploma in Minute Taking at QLS Level 5 Course 03: Diploma in Admin, Secretarial & PA at QLS Level 5 CPD QS Accredited Courses: Course 04: Online Meeting Management Course 05: UK Employment Law Course 06: HR and Leadership Management Course 07: Report Writing Course 08: Document Control Course 09: Delegation Skills Course 10: Paralegal Training Course 11: Process Improvement: How to Reduce Waste Take your career to the next level with our bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive bundle, endorsed by the prestigious QLS and accredited by CPD.Admin, Secretarial & PA with Office Management & Minute Taking QLS Endorsed Diploma. Learning Outcomes: Upon completion of this Admin, Secretarial & PA with Office Management & Minute Taking bundle, participants will: Demonstrate advanced proficiency in office management and administration techniques. Execute effective minute taking procedures in various organizational settings. Implement administrative best practices in secretarial and personal assistant roles. Apply UK employment law principles to ensure compliance within the workplace. Cultivate leadership and HR management skills essential for effective team coordination. Employ critical thinking and decision-making strategies to enhance problem-solving abilities. Embark on a transformative journey towards professional excellence with our comprehensive Admin, Secretarial & PA with Office Management & Minute Taking course bundle designed to elevate your administrative prowess and career trajectory. Dive into the intricacies of office management and administration, gaining proficiency in essential tasks ranging from scheduling and budgeting to team coordination and facility management. Explore the art of minute taking, mastering techniques to capture vital meeting discussions accurately and succinctly, ensuring effective communication and documentation within your organization. Moreover, immerse yourself in the dynamic landscape of UK employment law, equipping yourself with the knowledge and insights necessary to navigate legal frameworks and safeguard organizational compliance. Harness the power of HR and leadership management, honing your abilities to foster a cohesive and productive work environment while nurturing talent and driving strategic initiatives. From enhancing your report writing skills to implementing efficient document control processes, each module is meticulously crafted to equip you with the tools and techniques needed to thrive in today's competitive administrative arena. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to pursue careers in administrative, secretarial, or personal assistant roles. Professionals seeking to enhance their skill set and advance their career prospects. Graduates looking to augment their theoretical knowledge with practical administrative expertise. Entrepreneurs or small business owners aiming to streamline administrative processes within their organizations. HR professionals interested in bolstering their leadership capabilities and strategic decision-making skills. Anyone keen on refining their networking abilities and maximizing personal success in the professional arena. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Administrative Assistant Executive Assistant Office Manager HR Coordinator Legal Secretary Personal Assistant Business Administrator Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificate Hard copy certificate - Included