Name: Advanced Excel Course (Formula, VLOOKUP & Power Query)
Price: 12 GBP
Availability: InStock

<h3><strong>Overview</strong></h3>
Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work.

This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it.

You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent.
<h3><strong>How will I get my certificate?</strong></h3>
At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.
<h3><strong>Who is this course for?</strong></h3>
There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds.
<h3><strong>Requirements</strong></h3>
Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>21 sections • 90 lectures • 22:14:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction to Microsoft Excel 2019 New Features: 00:07:00</p></div><div><div><p>•CONCAT: 00:02:00</p></div><div><div><p>•IFS: 00:01:00</p></div><div><div><p>•MAXIFS: 00:01:00</p></div><div><div><p>•MINIFS: 00:01:00</p></div><div><div><p>•SWITCH: 00:02:00</p></div><div><div><p>•TEXTJOIN: 00:01:00</p></div><div><div><p>•Map Chart: 00:02:00</p></div><div><div><p>•Funnel Chart: 00:01:00</p></div><div><div><p>•Better Visuals: 00:06:00</p></div><div><div><p>•Pivot Table Enhancements: 00:02:00</p></div><div><div><p>•Power Pivot Updates: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the Excel User Interface: 00:28:00</p></div><div><div><p>•Use Excel Commands: 00:10:00</p></div><div><div><p>•Create and Save a Basic Workbook: 00:19:00</p></div><div><div><p>•Enter Cell Data: 00:12:00</p></div><div><div><p>•Use Excel Help: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Worksheet Formulas: 00:15:00</p></div><div><div><p>•Insert Functions: 00:17:00</p></div><div><div><p>•Reuse Formulas and Functions: 00:17:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Text Formats: 00:16:00</p></div><div><div><p>•Apply Number Format: 00:08:00</p></div><div><div><p>•Align Cell Contents: 00:09:00</p></div><div><div><p>•Apply Styles and Themes: 00:12:00</p></div><div><div><p>•Apply Basic Conditional Formatting: 00:11:00</p></div><div><div><p>•Create and Use Templates: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preview and Print a Workbook: 00:10:00</p></div><div><div><p>•Set Up the Page Layout: 00:09:00</p></div><div><div><p>•Configure Headers and Footers: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Manage Worksheets: 00:05:00</p></div><div><div><p>•Manage Workbook and Worksheet Views: 00:07:00</p></div><div><div><p>•Manage Workbook Properties: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Work with Ranges: 00:18:00</p></div><div><div><p>•Use Specialized Functions: 00:11:00</p></div><div><div><p>•Work with Logical Functions: 00:23:00</p></div><div><div><p>•Work with Date &amp; Time Functions: 00:08:00</p></div><div><div><p>•Work with Text Functions: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort Data: 00:10:00</p></div><div><div><p>•Filter Data: 00:10:00</p></div><div><div><p>•Query Data with Database Functions: 00:09:00</p></div><div><div><p>•Outline and Subtotal Data: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Intermediate Conditional Formatting: 00:07:00</p></div><div><div><p>•Apply Advanced Conditional Formatting: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Charts: 00:13:00</p></div><div><div><p>•Modify and Format Charts: 00:12:00</p></div><div><div><p>•Use Advanced Chart Features: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a PivotTable: 00:13:00</p></div><div><div><p>•Analyze PivotTable Data: 00:12:00</p></div><div><div><p>•Present Data with PivotCharts: 00:07:00</p></div><div><div><p>•Filter Data by Using Timelines and Slicers: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Links and External References: 00:12:00</p></div><div><div><p>•Use 3-D References: 00:06:00</p></div><div><div><p>•Consolidate Data: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Lookup Functions: 00:12:00</p></div><div><div><p>•Trace Cells: 00:09:00</p></div><div><div><p>•Watch and Evaluate Formulas: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Collaborate on a Workbook: 00:19:00</p></div><div><div><p>•Protect Worksheets and Workbooks: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Data Validation: 00:13:00</p></div><div><div><p>•Search for Invalid Data and Formulas with Errors: 00:04:00</p></div><div><div><p>•Work with Macros: 00:18:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Sparklines: 00:07:00</p></div><div><div><p>•MapData: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Determine Potential Outcomes Using Data Tables: 00:08:00</p></div><div><div><p>•Determine Potential Outcomes Using Scenarios: 00:09:00</p></div><div><div><p>•Use the Goal Seek Feature: 00:04:00</p></div><div><div><p>•Forecasting Data Trends: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Macro Using the Macro Recorder: 01:00:00</p></div><div><div><p>•Edit a Macro: 01:00:00</p></div><div><div><p>•Debug a Macro: 00:30:00</p></div><div><div><p>•Customize the Quick Access Toolbar and Hotkeys: 00:30:00</p></div><div><div><p>•Set Macro Security: 01:00:00</p></div><div><div><p>•Insert Text: 00:30:00</p></div><div><div><p>•Format Text: 00:30:00</p></div><div><div><p>•Sort Data: 00:30:00</p></div><div><div><p>•Duplicate Data: 01:00:00</p></div><div><div><p>•Generate a Report: 01:00:00</p></div><div><div><p>•Determine the Dialog Box Type: 00:15:00</p></div><div><div><p>•Capture User Input: 01:00:00</p></div><div><div><p>•Insert, Copy, and Delete Worksheets: 00:30:00</p></div><div><div><p>•Rename Worksheets: 00:30:00</p></div><div><div><p>•Modify the Order of Worksheets: 00:15:00</p></div><div><div><p>•Print Worksheets: 00:30:00</p></div><div><div><p>•Create User-Defined Functions: 00:30:00</p></div><div><div><p>•Automate SUM Functions: 00:30:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Advanced Diploma in MS Excel: 00:05:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Microsoft Certification

Finance Cert & Exam Prep

Computer Skills

Microsoft Excel

Microsoft Office

European Computer Driving Licence (ECDL)

Advanced Diploma in MS Excel

General Admission

<p><strong> All in One Bundle </strong></p><p><strong> Special Discount Offer </strong></p><p>Are you looking to enhance your Office Skills for Admin, Secretarial, PA (Executive PA)? If yes, then you have come to the right place. Our comprehensive courses on Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) will assist you in producing the best possible outcome by learning the Office Skills for Admin, Secretarial, PA (Executive PA).</p><p><strong>Course 01: This Microsoft Office Bundle</strong></p><ul><li>Microsoft Excel 2019</li><li>Microsoft Word 2019</li><li>Microsoft PowerPoint 2019</li><li>Microsoft Access 2019</li></ul><p><strong>Course 02: Admin, Secretarial, PA</strong></p><p>The Office Skills for Admin, Secretarial, PA (Executive PA) bundle is for those who want to be successful. In the Office Skills for Admin, Secretarial, PA (Executive PA) bundle, you will learn the essential knowledge needed to become well versed in Office Skills for Admin, Secretarial, PA (Executive PA).</p><p>Our Office Skills for Admin, Secretarial, PA (Executive PA) bundle starts with the basics of Office Skills for Admin, Secretarial, PA (Executive PA) and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) is intuitive and easy to understand.</p><p><strong>Why would you choose the course from Compliance Central:</strong></p><ul><li>Lifetime access to courses materials</li><li>Full tutor support is available from Monday to Friday</li><li>Learn at your own pace from the comfort of your home</li><li>Accessible, informative learning modules designed by expert instructors</li><li>Get 24/7 help or advice from our email and live chat teams with the bundle</li><li>Study in your own time through your computer, tablet or mobile device</li></ul><p><strong>Curriculum Breakdown of the Microsoft Office Skills for Admin, Secretarial, PA (Executive PA)</strong></p><p><strong>Microsoft Excel 2019</strong></p><ul><li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li></ul><p><strong>Microsoft Word 2019</strong></p><ul><li>Microsoft Word 2019 New Features</li><li>Getting Started with Word</li><li>Formatting Text and Paragraphs</li><li>Working More Efficiently</li><li>Managing Lists</li><li>Adding Tables</li><li>Inserting Graphic Objects</li><li>Controlling Page Appearance</li><li>Preparing to Publish a Document</li></ul><p><strong>Microsoft PowerPoint 2019</strong></p><ul><li>Microsoft PowerPoint 2019 New Features</li><li>PowerPoint Interface</li><li>Presentation Basics</li><li>Formatting</li><li>Inserting Options</li><li>Working with Objects</li><li>Table</li><li>Charts</li><li>Review and Presentation</li></ul><p><strong>Microsoft Access 2019</strong></p><ul><li>Microsoft Access 2019 New Features</li><li>Introduction to Access</li><li>Modify Data</li><li>Working with Queries</li><li>Access Forms</li><li>Working with Reports</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        25 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills for Admin, Secretarial, PA (Executive PA).</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To enrol in this Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) course, all you need is a basic understanding of the English Language and an internet connection.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Skills for Admin, Secretarial, PA (Executive PA).</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>2 CPD Accredited PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>2 CPD Accredited PDF Certificate for Free</p></div>
        <h4>CDP Accerdited Hardcopy Certificate</h4>
        <p>
            Hard copy certificate -
            £10.79
        </p>
            <div><p><strong>Delivery Charge:</strong></p><ul><li>Inside the UK: Free</li><li>Outside of the UK: £9.99 each</li></ul></div>

                        </div>

Compliance Central

Microsoft Office Skills for Admin, Secretarial, PA (Executive PA)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Familiarise yourself with the basic to advanced level excel tools</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn the process of managing and modifying Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enrich your knowledge of Pivot Tables and Pivot Charts</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Develop your skills in data analysis</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about lookup functions and formula editing</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Grasp the principles of data mapping and forecasting</span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Microsoft Office 2016 Excel Beginner to Advanced Course Description</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now!</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certificate of Achievement</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for &pound;119. An extra &pound;10 postage charge will be required for students leaving overseas.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD Accredited Certificate</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Method of Assessment</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career path</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Data Analyst</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Receptionist</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Office Admin</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Data entry Officer</span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"></span><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Microsoft Excel Beginners</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Getting Started with Microsoft Office Excel 2016</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performing Calculations</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modifying a Worksheet</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Formatting a Worksheet</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Printing Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Microsoft Excel Intermediate</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Functions</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Lists</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analyzing Data</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Visualizing Data with Charts</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using PivotTables and PivotCharts</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Microsoft Excel Advanced</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Multiple Worksheets and Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using Lookup Functions and Formula Auditing</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sharing and Protecting Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Automating Workbook Functionality</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Creating Sparklines and Mapping Data</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Forecasting Data</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Resources</span></li></ul><div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">
                                    </h2></div></div></div></div></div></div></div></section></div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">
                                </div>
                            </div>
                        </div>

Janets

Microsoft 365

Microsoft Word

Microsoft Office 2016 Excel Beginner to Advanced

<p>Are you looking to enhance your Microsoft Office skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office will assist you in producing the best possible outcome by mastering the Microsoft Office skills.</p><p>The Microsoft Office course is for those who want to be successful. In the Microsoft Office course, you will learn the essential knowledge needed to become well versed in Microsoft Office.</p><p>Our Microsoft Office course starts with the basics of Microsoft Office and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office course is intuitive and easy to understand.</p><p><strong>Why would you choose the course:</strong></p><ul><li>Lifetime access to the Microsoft Office course materials</li><li>Full tutor support is available from Monday to Friday with the Microsoft Office course</li><li>Gain a complete understanding of the Microsoft Office course</li><li>Accessible, informative Microsoft Office learning modules designed by experts</li><li>Get 24/7 help or advice from our email and live chat teams with the Microsoft Office course</li><li>Study Microsoft Office in your own time through your computer, tablet or mobile device</li><li>A 100% learning satisfaction guarantee with your Microsoft Office course</li></ul><p><strong>Mastering Microsoft Office 2019 (Excel, Word, PowerPoint, Access)</strong></p><p><strong>Microsoft Excel 2019</strong></p><ul><li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li></ul><p><strong>Microsoft Word 2019</strong></p><ul><li>Microsoft Word 2019 New Features</li><li>Getting Started with Word</li><li>Formatting Text and Paragraphs</li><li>Working More Efficiently</li><li>Managing Lists</li><li>Adding Tables</li><li>Inserting Graphic Objects</li><li>Controlling Page Appearance</li><li>Preparing to Publish a Document</li><li>Workbooks - Microsoft Word 2016 (Beginner)</li></ul><p><strong>Microsoft PowerPoint 2019</strong></p><ul><li>Microsoft PowerPoint 2019 New Features</li><li>PowerPoint Interface</li><li>Presentation Basics</li><li>Formatting</li><li>Inserting Options</li><li>Working with Objects</li><li>Table</li><li>Charts</li><li>Review and Presentation</li></ul><p><strong>Microsoft Access 2019</strong></p><ul><li>Microsoft Access 2019 New Features</li><li>Introduction to Access</li><li>Modify Data</li><li>Working with Queries</li><li>Access Forms</li><li>Working with Reports</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>The Microsoft Office course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office. It is also great for professionals who are already working in Microsoft Office and want to get promoted at work.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To enrol in this Microsoft Office course, all you need is a basic understanding of the English Language and an internet connection.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Office Administrator: £18,000 to £25,000 per year</li><li>Data Entry Clerk: £18,000 to £25,000 per year</li><li>Document Controller: £22,000 to £30,000 per year</li><li>Executive Assistant: £25,000 to £40,000 per year</li><li>Technical Writer: £25,000 to £45,000 per year</li><li>Content Editor: £25,000 to £35,000 per year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p><strong>CPD Accredited PDF Certificate</strong></p></div>
        <h4>CPD Accredited Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            £10.79
        </p>
            <div><p><strong>CPD Accredited Hard Copy Certificate</strong></p><p><strong>Delivery Charge:</strong></p><p>Inside the UK: Free</p><p>Outside of the UK: £9.99 each</p></div>

                        </div>

Mastering Microsoft Office 2019 (Excel, Word, PowerPoint, Access)

<p>In the UK, the starting <strong>salary for jobs involving data entry is normally between £25,000 and £28,000</strong> annually. But in a junior position, <strong>you might make between £40,000 and £50,000 if you have some experience</strong>. Furthermore, if you work in <strong>a senior job and have a lot of expertise, you may make over £65,000</strong>. Our Data Entry training equips you with precise knowledge and abilities to become a Data Entry specialist.</p><p>If you have a strong knack for accuracy, the ability to work under pressure, and outstanding keyboarding skills, you might want to choose a job in data entry. A job in data entry can lead you into many other areas because companies from a variety of industries hire for these Data Entry Administrator roles.</p><p>You will have improved your employability and equipped yourself with the skills you need to keep ahead of the competition by the time you finish this Data Entry course. Additionally, by making your resume stand out to potential employers, the course will offer it a little extra edge over the competition. Thus, why do you delay? Enroll right now in the course!</p><p><strong>Key Features:</strong></p><ul><li>This Data Entry Clerk Course is CPD Certified</li><li>Free Certificate from Reed</li><li>CIQ Approved Data Entry Clerk Course</li><li>Developed by Specialist</li><li>Lifetime Access</li></ul><p><strong><strong>Course Curriculum:</strong></strong></p><p><strong><strong>Data Entry Clerk Level 3 Advanced Diploma</strong></strong></p><ul><li><strong>Module 01:</strong> Basic Data Input and Key Tools</li><li><strong>Module 02:</strong> Entering Data Using Microsoft Word</li><li><strong>Module 03:</strong> Data Input with Microsoft Excel</li><li><strong>Module 04:</strong> Enhanced Data Input Methods and Tools</li><li><strong>Module 05:</strong> Best Practices for Data Input Accuracy</li><li><strong>Module 06:</strong> Developing Your Data Input Career and Portfolio</li></ul><p><strong>Learning Outcomes:</strong></p><p><strong>Data Entry Clerk Level 3 Advanced Diploma</strong></p><ul><li>Understand data entry fundamentals and essential tools for efficiency.</li><li>Demonstrate proficient data entry skills using Microsoft Word.</li><li>Apply advanced data entry techniques proficiently in Microsoft Excel.</li><li>Utilize advanced tools for efficient and accurate data entry tasks.</li><li>Implement best practices to ensure accuracy in data entry work.</li><li>Develop a professional portfolio and strategies for advancing data entry career.</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><li>
                                        <h3>
                                            
                                                Data Entry Clerk Level 3 Advanced Diploma <span>1:40:13</span>
                                                <span></span>
                                            
                                        </h3>
                                        <ul id="section1">
                                                <li>
                                                        
                                                    <span>1: Module 01: Basic Data Input and Key Tools</span>

                                                        <span>Preview</span>
                                                    
                                                    <span>15:16</span>

                                                        
                                                                                                                                                                                                            </li>
                                                <li>
                                                    <span>2: Module 02: Entering Data Using Microsoft Word</span>

                                                    <span>12:59</span>

                                                        
                                                                                                                                                                                                            </li>
                                                <li>
                                                    <span>3: Module 03: Data Input with Microsoft Excel</span>

                                                    <span>15:54</span>

                                                        
                                                                                                                                                                                                            </li>
                                                <li>
                                                    <span>4: Module 04: Enhanced Data Input Methods and Tools</span>

                                                    <span>16:55</span>

                                                        
                                                                                                                                                                                                            </li>
                                                <li>
                                                    <span>5: Module 05: Best Practices for Data Input Accuracy</span>

                                                    <span>13:23</span>

                                                        
                                                                                                                                                                                                            </li>
                                                <li>
                                                    <span>6: Module 06: Developing Your Data Input Career and Portfolio</span>

                                                    <span>23:46</span>

                                                        
                                                                                                                                                                                                            </li>
                                                <li>
                                                    <span>7: CPD Certificate - Free</span>

                                                    <span>01:00</span>

                                                                                                                                                                
                                                                                                    </li>
                                                <li>
                                                    <span>8: Leave A Review</span>

                                                    <span>01:00</span>

                                                                                                                                                                
                                                                                                    </li>
                                        </ul>
                                    </li><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Data Entry Clerk Level 3 Advanced Diploma course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Data Entry Clerk Level 3 Advanced Diploma. Moreover, this course is ideal for:</p><ul><li>Individuals seeking advanced data entry skills.</li><li>Professionals aiming to enhance data entry proficiency.</li><li>Students aspiring to pursue a career in data entry.</li><li>Anyone interested in improving data entry accuracy and efficiency.</li><li>Individuals looking to build a career in administrative roles.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no requirements needed to enrol into this Data Entry Clerk Level 3 Advanced Diploma course. We welcome individuals from all backgrounds and levels of experience to enrol into this Data Entry Clerk Level 3 Advanced Diploma course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After finishing this Data Entry Clerk course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Data Entry Clerk are: </p><ul><li>Database Administrator - £25K to £35K/year</li><li>Data Entry Clerk - £18K to £25K/year</li><li>Administrative Assistant - £18K to £23K/year</li><li>Office Administrator - £20K to £25K/year</li><li>Data Analyst - £22K to £30K/year</li><li>Executive Assistant - £25K to £35K/yr</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Reed Courses Certificate of Completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Will be downloadable when all lectures have been completed.</p></div>

                        </div>

Online Training Academy

Data Entry Clerk Level 3 Advanced Diploma

<p>There's a tool that can help you quickly explore, analyse raw data, and reveal powerful insights or trends all in one place, that tool is called MS Excel. Excel is Installed in almost every computer at the present time however very few understand its true use of it. Now, you have the golden opportunity to master Microsoft Excel skills for Data Analysis.</p><p>Data is now crucial in every work, thus every company searches for Microsoft Excel abilities in possible candidates who can assist them in data analysis. Our Data Analysis In Excel course is designed for those potential candidates who are seeking to lure a job in a demanding organisation to achieve a lucrative career. We will offer interactive lessons and rich learning experiences throughout this course to develop a solid base from scratch to give an edge over others in this competitive job market.</p><p>Enrol in this course to create a solid base of excel skills by gaining the necessary tips and tricks from this specialised Data Analysis In Excel course.</p><p><strong>Learning Outcome:</strong></p><ul><li>Master the tips and tricks of MS Excel.</li><li>Analyse and visualise data using MS Excel in a quick time.</li><li>Understand the use of the Pivot table and how beneficial it can be.</li><li>Learn to create and modify a worksheet.</li><li>Learn to use maths, statistics, logic and text functions in Microsoft Excel.</li><li>Create dynamic reports via Excel.</li></ul><p><strong>Key Features </strong></p><ul><li>Accredited by CPD</li><li>Instant e-certificate</li><li>Fully online, interactive Data Analysis In Excel course with audio voiceover</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Free Gifts</strong></p><ul><li>Life Coaching Course</li></ul><p><strong>Enrol now in this </strong><strong>Data Analysis In Excel course to excel! </strong></p><p>To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Data Analysis In Excel training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge &amp; skills.</p><p>The curriculum of the Data Analysis In Excel course has been designed by experts with years of experience behind them which is extremely dynamic and well-paced to help you understand the subject matter with ease.</p><p><strong>Course Curriculum :</strong></p><p><strong>Data Analysis In Excel</strong></p><ul><li><strong>Module 01:</strong> Modifying a Worksheet</li><li><strong>Module 02:</strong> Working with Lists</li><li><strong>Module 03: </strong>Analyzing Data</li><li><strong>Module 04: </strong>Visualizing Data with Charts</li><li><strong>Module 05: </strong>Using PivotTables and PivotCharts</li><li><strong>Module 06: </strong>Working with Multiple Worksheets and Workbooks</li><li><strong>Module 07: </strong>Using Lookup Functions and Formula Auditing</li><li><strong>Module 08: </strong>Automating Workbook Functionality</li><li><strong>Module 09: </strong>Creating Sparklines and Mapping Data</li><li><strong>Module 10: </strong>Forecasting Data</li></ul><p><strong>Life Coaching</strong></p><ul><li><strong>Module 01:</strong> Life Coaching: The Purpose and Fundamentals</li><li><strong>Module 02: </strong>Develop Your Self-Awareness</li><li><strong>Module 03</strong>: The Development of Core Beliefs and Managing Fears</li><li><strong>Module 04:</strong> Life Coaching Types and Key Attributes of a Life Coach</li><li><strong>Module 05:</strong> Understanding Emotional Intelligence</li><li><strong>Module 06:</strong> Body Language and Communication Techniques</li><li><strong>Module 07:</strong> A Structure for Client Work and Goal Setting</li><li><strong>Module 08:</strong> Basic Principles for Business Development and Growth</li><li><strong>Module 09:</strong> The Ethical Coach: Protect Yourself and Your Clients</li></ul><p><strong>Accreditation</strong></p><p>All of our courses are fully accredited, including this Data Analysis In Excel course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Data Analysis In Excel course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is ideal for anyone who wants to develop Microsft Office skills. But, we strongly recommend this course to:</p><ul><li>Students</li><li>Recent graduates</li><li>Job Seekers</li><li>People already working in a company.</li><li>Individuals who are looking to efficiently analyse large data sets and create dynamic dashboard reports</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No prior degree or experience is required to enrol in this course. You only need to have a stable internet connection to get the best learning experience.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon completion, you can also explore some relevant jobs, such as -</p><ul><li>HR Admin</li><li>Office Administrator</li><li>Data Analyst</li><li>Bookkeeper</li><li>Customer Support Administrator</li><li>Admin, Secretary and PA</li><li>Sales and marketing analyst</li></ul><p>In the UK, these job positions are getting the amount between £22,000 per annum - £22,000 per annum.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p> </div>

                        </div>

Training Express

Data Analysis In Excel Course

<p>Embark on a journey into the heart of productivity with our "<strong>Diploma in Microsoft Office - An Introduction</strong>" course. In an increasingly digital world, proficiency in Microsoft Office is not just desirable but essential for success. Delve into the realms of Excel, Word, PowerPoint, and Access, mastering each module with precision. </p><p>Discover the power of <strong>data manipulation in Excel</strong>, the art of <strong>document creation in</strong><strong>Word</strong>, the allure of dynamic <strong>presentations in PowerPoint</strong>, and the intricacies of database management in Access. With the UK's reliance on digital tools growing exponentially, proficiency in Microsoft Office opens doors to a myriad of opportunities. </p><p>From administrative roles to project management positions, employers seek individuals adept at harnessing the full potential of these ubiquitous software suites. Join us and unlock a world of endless possibilities, where efficiency meets innovation, and success knows no bounds. </p><p><strong>Enroll today and take the first step towards a future brimming with promise and opportunity.</strong></p><p><strong>Key Features:</strong></p><ul><li>CPD Certified</li><li>Instant e-certificate and hard copy dispatch by next working day</li><li>Fully online, interactive course with audio voiceover</li><li>Developed by qualified professionals in the field</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Microsoft Office</strong></p><ul><li><strong>Module 01:</strong>Microsoft Excel 2019</li><li><strong>Module 02:</strong>Microsoft Excel 2019 New Features</li><li><strong>Module 03:</strong>Getting Started with Microsoft Excel</li><li><strong>Module 04:</strong>Performing Calculations</li><li><strong>Module 05:</strong>Modifying a Worksheet</li><li><strong>Module 06:</strong>Formatting a Worksheet</li><li><strong>Module 07:</strong>Printing Workbooks</li><li><strong>Module 08:</strong>Managing Workbooks</li><li><strong>Module 09:</strong>Microsoft Word 2019</li><li><strong>Module 10:</strong>Microsoft Word 2019 New Features</li><li><strong>Module 11:</strong>Getting Started with Word</li><li><strong>Module 12:</strong>Formatting Text and Paragraphs</li><li><strong>Module 13:</strong>Working More Efficiently</li><li><strong>Module 14:</strong>Managing Lists</li><li><strong>Module 15:</strong>Adding Tables</li><li><strong>Module 16:</strong>Inserting Graphic Objects</li><li><strong>Module 17:</strong>Controlling Page Appearance</li><li><strong>Module 18:</strong>Preparing to Publish a Document</li><li><strong>Module 19:</strong>Microsoft PowerPoint 2019</li><li><strong>Module 20:</strong>Microsoft PowerPoint 2019 New Features</li><li><strong>Module 21:</strong>PowerPoint Interface</li><li><strong>Module 22:</strong>Presentation Basics</li><li><strong>Module 23:</strong>Formatting</li><li><strong>Module 24:</strong>Inserting Options</li><li><strong>Module 25:</strong>Working with Objects</li><li><strong>Module 26:</strong>Table</li><li><strong>Module 27:</strong>Charts</li><li><strong>Module 28:</strong>Review and Presentation</li><li><strong>Module 29:</strong>Microsoft Access 2019</li><li><strong>Module 30:</strong>Microsoft Access 2019 New Features</li><li><strong>Module 31:</strong>Introduction to Access</li><li><strong>Module 32:</strong>Modify Data</li><li><strong>Module 33:</strong>Working with Queries</li><li><strong>Module 34:</strong>Access Forms</li><li><strong>Module 35:Working with Reports</strong></li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Master essential features of Microsoft Office applications efficiently.</li><li>Perform calculations and manipulate data effectively using Excel.</li><li>Create professional documents with advanced formatting in Word.</li><li>Develop captivating presentations with multimedia elements in PowerPoint.</li><li>Manage and organize data efficiently using Access.</li><li>Demonstrate proficiency in using Microsoft Office for diverse tasks.</li></ul><p><strong>Accreditation</strong></p><p>All of our courses are fully accredited, including this Diploma in Microsoft Office - An Introduction Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Microsoft Office - An Introduction.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Diploma in Microsoft Office - An Introduction Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Diploma in Microsoft Office - An Introduction Course certification has no expiry dates, although we do recommend that you renew them every 12 months.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        20 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Diploma in Microsoft Office - An Introduction Course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Diploma in Microsoft Office - An Introduction Course is ideal for:</p><ul><li>Students seeking foundational skills in Microsoft Office.</li><li>Professionals aiming to enhance their digital proficiency.</li><li>Job seekers looking to bolster their CVs with essential software skills.</li><li>Entrepreneurs aiming to streamline their business processes.</li><li>Individuals keen on staying ahead in today's digital landscape.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Learners do not require any prior qualifications to enrol on this Diploma in Microsoft Office - An Introduction Course. You just need to have an interest in Diploma in Microsoft Office - An Introduction Course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After completing this Diploma in Microsoft Office - An Introduction Course you will have a variety of careers to choose from. The following job sectors of this Course are:</p><ul><li>Administrative Assistant - £18K to £25K/year.</li><li>Data Entry Clerk - £16K to £23K/year.</li><li>Office Manager - £22K to £35K/year.</li><li>Project Coordinator - £24K to £40K/year.</li><li>Database Administrator - £26K to £45K/year.</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Diploma in Microsoft Office - An Introduction Course

<h3><b>Overview</b></h3>
<span>Develop your leadership skills and understand what is needed to become an effective manager in your workplace.       </span>

<span>This <strong>Management for Managers</strong></span><b> </b><span>course provides the full set of skills and insight that will empower you to be a respected and aspirational leader of a team. </span>

<span>The course has been written with the assistance of industry professionals and contains details for proven managerial styles and techniques that can be put to practical use. You will also learn how to make crucial decisions quickly and accurately, alongside hints and tips for keeping stakeholders invested in your continued success and career progression. </span>
<h3><b>How will I get my certificate?</b></h3>
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.
<h3><b>Who is this course for?</b></h3>
<span>There is no experience or previous qualifications required for enrolment on this Management for Managers</span><span>. It is available to all students, of all academic backgrounds.</span>
<h3><b>Requirements</b></h3>
<span>Our Management for Managers </span><span>is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</span>

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span> <h3>Course Curriculum</h3><div><p>21 sections • 23 lectures • 05:08:00 total length</p></div><div><div><div><div><div><div><div><p>•Understanding Management and Leadership: 00:40:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Leadership Theories: 00:25:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Improving Management and Leadership Performance: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•High Performance Teams: 00:32:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Motivating Employees: 00:26:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Organisational Skills: 00:26:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Talent Management: 00:37:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Succession Planning: 00:24:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Business Process Management: 00:28:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Communication Skills: 00:27:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Negotiation Techniques: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Managing Meetings and Giving Feedback: 00:21:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Managing Change: 00:22:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Time Management: 00:37:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Stress Management: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Emotional Intelligence in Leadership: 00:32:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Managing Conflict: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dealing with Office Politics: 00:34:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Risk Management: 00:35:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Corporate Responsibility and Ethics: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Microsoft Word: 08:06:00</p></div><div><div><p>•Microsoft Excel: 03:59:00</p></div><div><div><p>•Microsoft PowerPoint: 08:24:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Office Management

Diploma in Management Studies (DMS)

Manager Training

Business & Management

Institute of Leadership & Management (ILM)

Management Skills

Management for Managers

<h3><b>Overview</b></h3>
<b>This Management Level 5 course meticulously delves into understanding the complexities and nuances of modern leadership, catering to those keen on mastering the art of effective management. </b><b></b>

<span>This course has been curated meticulously to offer insights into various facets of management and leadership. From </span><b>understanding the fundamental theories that govern administration to honing skills like negotiation and communication, the curriculum is a comprehensive voyage through the disciplines that develop a proficient manager.</b><span> One would also find a detailed </span><b>exploration of contemporary issues like corporate responsibility and the nuances of navigating office politics, promising a well-rounded educational experience.</b><b></b>

<span>In addition to managerial theories and practices, the Management Level 5 course is robustly equipped to </span><b>impart essential technological skills. With extensive modules on Microsoft Word, Excel, and PowerPoint, learners are primed to excel in the modern digital workspace, harnessing the power of these tools </b><span>to augment their managerial prowess.</span>
<h3><b>How will I get my certificate?</b></h3>
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.
<h3><b>Who is this course for?</b></h3>
<span>There is no experience or previous qualifications required for enrolment on this Management Level 5</span><span>. It is available to all students, of all academic backgrounds.</span>
<h3><b>Requirements</b></h3>
<span>Our Management Level 5 </span><span>is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</span>

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span> <h3>Course Curriculum</h3><div><p>22 sections • 23 lectures • 04:37:00 total length</p></div><div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Understanding Management and Leadership: 00:40:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Leadership Theories: 00:25:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Improving Management and Leadership Performance: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•High Performance Teams: 00:32:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Motivating Employees: 00:26:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Organisational Skills: 00:26:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Talent Management: 00:37:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Succession Planning: 00:24:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Business Process Management: 00:28:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Communication Skills: 00:27:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Negotiation Techniques: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Managing Meetings and Giving Feedback: 00:21:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Managing Change: 00:22:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Time Management: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Stress Management: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Emotional Intelligence in Leadership: 00:32:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Managing Conflict: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dealing with Office Politics: 00:34:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Risk Management: 00:35:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Corporate Responsibility and Ethics: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Microsoft Word: 08:06:00</p></div><div><div><p>•Microsoft Excel: 03:59:00</p></div><div><div><p>•Microsoft PowerPoint: 08:24:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Commercial & Contract Management Certification Program (CCM)

FA Level 1

Management Level 5

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> will deepen your understanding on this topic. <span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>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.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> 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. <span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>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-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p><p> </p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>5 sections • 41 lectures • 02:56:00 total length</p></div><div><div><div><div><div><div><div><p>•How to Get the most of the course: 00:01:00</p></div><div><div><p>•Text formulas in Excel: 00:08:00</p></div><div><div><p>•Text Formulas Exercise: 00:01:00</p></div><div><div><p>•Text Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Mathematical Formulas In Excel: 00:04:00</p></div><div><div><p>•Mathematical Formulas Exercise: 00:01:00</p></div><div><div><p>•Mathematical Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Date and Time Formulas In Excel: 00:05:00</p></div><div><div><p>•Date and Time Formulas Exercise: 00:01:00</p></div><div><div><p>•Date and Time Exercise Formulas (answers): 00:01:00</p></div><div><div><p>•Logic Formulas In Excel: 00:12:00</p></div><div><div><p>•Logic Formula Exercise: 00:01:00</p></div><div><div><p>•Logic Formula Exercise (answers): 00:01:00</p></div><div><div><p>•Financial Formula In Excel: 00:06:00</p></div><div><div><p>•Financial Formula Exercise: 00:01:00</p></div><div><div><p>•Financial Formula Exercise (answers): 00:02:00</p></div><div><div><p>•Informational Formula In Excel: 00:04:00</p></div><div><div><p>•Informational Formula Exercise: 00:01:00</p></div><div><div><p>•Informational Formula Exercise (answers): 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Menu Example with Excel Vlookup: 00:08:00</p></div><div><div><p>•Wildcard Search with Excel Vlookup: 00:09:00</p></div><div><div><p>•Looking to the Left with Excel Vlookup: 00:17:00</p></div><div><div><p>•2-Way Lookup: 00:14:00</p></div><div><div><p>•Comparing Lists with Excel Vlookup: 00:03:00</p></div><div><div><p>•Microsoft Excel Vlookup Tips and Tricks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Power Query Intro and Excel version: 00:03:00</p></div><div><div><p>•Excel Power Query - Introduction: 00:03:00</p></div><div><div><p>•Enabling M in Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Trim in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Format Dates and Values in Excel Power Query: 00:02:00</p></div><div><div><p>•Simple Expressions: 00:08:00</p></div><div><div><p>•Simple Expressions - Nested Expressions: 00:03:00</p></div><div><div><p>•Transform Data - Parsing URLs in Excel Power Query: 00:05:00</p></div><div><div><p>•Variables: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Formatting Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Table Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Editing Excel Keyboard Shortcuts: 00:05:00</p></div><div><div><p>•Formula Excel Keyboard Shortcuts: 00:03:00</p></div><div><div><p>•Workbook Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Advanced Excel Course (Formula, VLOOKUP &amp; Power Query): 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Online Course Creation

Computing Skills

Trainers Course

Advanced Excel Course (Formula, VLOOKUP & Power Query)

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Financial Modeling and Analysis are highly respected skills in the business world and are hugely sought after in the job marketplace.</span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Financial Modelling is a powerful communication tool to clearly and effectively tell the story of a company to management and stakeholders. It is a critical decision-making tool used by management to make accurate and informed financial decisions about a company or project.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is multidisciplinary, requiring expertise in Accounting, Finance, Financial Analysis, Valuation, and Microsoft Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has been developed to cover the entire body of knowledge issued by the Financial Modeling Institute for Level One; Advanced Financial Modeler Designation.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(35, 35, 51);">This course is certified by the CFA Society Nigeria with 40 PL Credits and CPD UK with 40 CPD Credits.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">In this course, you will learn 3 Statement Modeling from Scratch to Mastery using a real Company&#39;s Audited Financial Statement. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">The course includes</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions (with over 200+ step-by-step videos).&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;1 Technical Session to confirm your connectivity and solve any technical issues you may have).&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;10 intensive instructor-led live virtual sessions. Each session is 2 hours&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;9 compulsory intersession assignments you will need to complete and submit on www.OfficeTrainingHub.com&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;Intermittent tests and quizzes to gauge your assimilation.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;1 Capstone Project</span></p></span>

dbrownconsulting

Financial Modelling & Analysis

Financial Modelling

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

Advanced Financial Modeler Certificate Course

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.</p><p></p><p></p><p>This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.</p><p></p></div><div id="course-pills-2"><h3>1 - Get started with Microsoft Power Platform for app makers</h3> <ul> <li>Identify components</li> <li>Create apps</li> <li>Get started with Microsoft Dataverse</li> <li>Work with Copilot in Microsoft Power Platform</li> </ul> <h3>2 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>3 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>4 - Load/export data and create data views in Dataverse</h3> <ul> <li>View data in a table</li> <li>Create or edit views of data in a table</li> <li>Dataverse data import options</li> <li>Load data into a table</li> <li>Dataverse data export options</li> <li>Export</li> <li>Add, update, or delete data in a table by using Excel</li> <li>Import data using Power Query</li> </ul> <h3>5 - Export data from Dataverse and use Microsoft Excel to edit records</h3> <ul> <li>Export data to Excel</li> <li>Edit and update data in Excel</li> </ul> <h3>6 - Get started with Microsoft Dataverse for Teams</h3> <ul> <li>Dataverse for Teams vs Dataverse</li> <li>Provision your first Dataverse environment</li> <li>Create your first table to store data</li> </ul> <h3>7 - Build your first app with Power Apps and Dataverse for Teams</h3> <ul> <li>Create your first app with the hero template</li> <li>Customize your app with Power Apps Studio</li> <li>Publish your app</li> <li>Install template apps</li> </ul> <h3>8 - Build your first workflow with Power Automate and Dataverse for Teams</h3> <ul> <li>Types of workflows that Power Automate can build in Dataverse</li> <li>Schedule a flow</li> </ul> <h3>9 - Create reports with Power BI and Dataverse for Teams</h3> <ul> <li>Connect to and transform Dataverse for Teams data from Power BI</li> <li>Create a Power BI report</li> <li>Publish the report</li> <li>Share the data</li> </ul> <h3>10 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>11 - Explore what Power BI can do for you</h3> <ul> <li>What can I do with the Power BI service as a consumer?</li> <li>View content in the Power BI service</li> <li>Collaborate and share in Power BI</li> <li>Find and view dashboards and reports</li> </ul> <h3>12 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>13 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>14 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>15 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Secure, publish, and share data in Power BI</h3> <ul> <li>Share and use reports in Power BI</li> <li>Row-level security</li> <li>Publish a report to a Power BI workspace</li> <li>Share reports and user experience</li> <li>Protect data in Power BI</li> <li>Data refresh and alerts</li> </ul> <h3>18 - Embed Power BI content</h3> <ul> <li>Embed Power BI reports</li> <li>Embed other Power BI content types</li> <li>Optimize the embedding experience</li> </ul> <h3>19 - How to build your first model-driven app with Dataverse</h3> <ul> <li>Model-driven apps, powered by Microsoft Dataverse</li> <li>Explore sample apps</li> </ul> <h3>20 - Get started with model-driven apps in Power Apps</h3> <ul> <li>Introducing model-driven apps</li> <li>Components of model-driven apps</li> <li>Design model-driven apps</li> <li>Incorporate business process flows</li> </ul> <h3>21 - Configure forms, charts, and dashboards in model-driven apps</h3> <ul> <li>Forms overview</li> <li>Form elements</li> <li>Configure multiple forms</li> <li>Use specialized form components</li> <li>Configure views overview</li> <li>Configure grids</li> <li>Create and edit views</li> <li>Configure charts overview</li> <li>Dashboards overview</li> <li>Use interactive streams and tiles</li> </ul> <h3>22 - Manage Dynamics 365 model-driven app settings and security</h3> <ul> <li>Configure role-based security</li> <li>Manage teams and business units</li> <li>Explore settings and customizations</li> </ul> <h3>23 - Use specialized components in a model-driven form</h3> <ul> <li>Create business process flows</li> <li>Embed a canvas app in a model-driven form</li> <li>Add a timeline in a model-driven form</li> <li>Create a report in a model-driven form</li> </ul> <h3>24 - Get started with Power Apps canvas apps</h3> <ul> <li>Start Power Apps</li> <li>Power Apps data sources</li> <li>Use Power Apps with Power Automate and Power BI</li> <li>Designing a Power Apps app</li> </ul> <h3>25 - Customize a canvas app in Power Apps</h3> <ul> <li>Improve your app by making basic customizations</li> <li>Explore controls and screens in canvas apps</li> </ul> <h3>26 - How to build the User Interface in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Brand a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Build for phones or tablets</li> </ul> <h3>27 - Navigation in a canvas app in Power Apps</h3> <ul> <li>Understanding navigation</li> <li>The Navigate and Back functions</li> <li>More ways to use the Navigate function</li> </ul> <h3>28 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>29 - Build a mobile-optimized app from Power Apps</h3> <ul> <li>Learn about mobile-optimized apps</li> <li>Identify components to make a canvas app mobile-optimized</li> <li>Create a mobile-optimized app that uses responsive designs</li> <li>Identify performance considerations for a mobile-optimized canvas app</li> </ul> <h3>30 - Use and understand Controls in a canvas app in Power Apps</h3> <ul> <li>Core properties of controls</li> <li>Entering and displaying data with text controls</li> <li>Additional controls for enhancing your app's usability</li> <li>Media</li> <li>Modern controls</li> <li>Work with component libraries</li> </ul> <h3>31 - Create formulas to change properties in a Power Apps canvas app</h3> <ul> <li>Formulas overview</li> <li>Use a formula to modify the format of controls</li> <li>Use formulas to perform calculations</li> <li>Use a control to modify the property of other controls</li> <li>Conditional formatting</li> <li>Functions for validating data</li> </ul> <h3>32 - Use imperative development techniques for canvas apps in Power Apps</h3> <ul> <li>Imperative versus declarative development</li> <li>The three types of variables in Power Apps</li> <li>Global variables</li> <li>Contextual variables</li> <li>Collections</li> <li>Additional variable concepts</li> </ul> <h3>33 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>34 - Create formulas to change properties in a Power Apps canvas app</h3> <ul> <li>Formulas overview</li> <li>Use a formula to modify the format of controls</li> <li>Use formulas to perform calculations</li> <li>Use a control to modify the property of other controls</li> <li>Conditional formatting</li> <li>Functions for validating data</li> </ul> <h3>35 - Create formulas to change behaviors in a Power Apps canvas app</h3> <ul> <li>Formulas and functionality</li> <li>Understanding true and false</li> <li>Understanding control behaviors and actions</li> <li>Performing multiple actions in a formula</li> <li>Control the display mode through a formula</li> <li>Use controls and functions to create a dynamic formula</li> </ul> <h3>36 - Author a basic formula that uses tables and records in a Power Apps canvas app</h3> <ul> <li>Records and tables</li> <li>Using the Table function</li> <li>Store a table</li> <li>Filter your table</li> <li>Use the lookup function to return a record</li> <li>Additional table functions</li> </ul> <h3>37 - Build a canvas app for a real estate solution with Copilot in Power Apps</h3><h3>38 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Create your first flow</li> <li>Troubleshoot flows</li> </ul> <h3>39 - Build approval flows with Power Automate</h3> <ul> <li>Provide solutions to real-world scenarios.</li> </ul> <h3>40 - Build flows to manage user information</h3><h3>41 - Power Automate's deep integration across multiple data sources</h3><h3>42 - Use the Admin center to manage environments and data policies in Power Automate</h3> <ul> <li>Administer flows</li> <li>Export and import flows</li> <li>Learn how to distribute button flows</li> </ul> <h3>43 - Use AI Builder in Power Automate</h3> <ul> <li>AI Builder in Power Automate saves time</li> <li>Advanced usage of AI Builder in Power Automate</li> </ul> <h3>44 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>45 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>46 - Build flows for a real estate solution using Copilot in Power Automate</h3> <ul> <li>When to use Copilot in Power Automate</li> </ul> <h3>47 - Use Dataverse triggers and actions in Power Automate</h3> <ul> <li>Dataverse triggers</li> <li>Query data</li> <li>Create, update, delete, and relate actions</li> </ul> <h3>48 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>49 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>50 - Get started with Power Apps canvas apps</h3> <ul> <li>Start Power Apps</li> <li>Power Apps data sources</li> <li>Use Power Apps with Power Automate and Power BI</li> <li>Designing a Power Apps app</li> </ul> <h3>51 - How to build the User Interface in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Brand a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Build for phones or tablets</li> </ul> <h3>52 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Create your first flow</li> <li>Troubleshoot flows</li> </ul> <h3>53 - Challenge Project - Build a booking requests app with Power Apps and Power Automate</h3> <ul> <li>Prepare</li> </ul></div>

Nexus Human

Microsoft Power Apps

Power Apps

Microsoft Power BI

Microsoft Power Platform

Power Automate

Microsoft Power Automate

PL-100T00 Microsoft Power Platform App Maker

<h2>Microsoft Excel® in Depth (Virtual)</h2>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you will Learn</h3>
 <p>You'll learn how to:</p>
 <ul>
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li>
 <li>Create meaningful charts</li>
 <li>Use pivot tables</li>
 <li>Use Conditional Formatting, Data Validation</li>
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li>
 </ul>

IIL Europe Ltd

Microsoft Excel in Depth (Virtual)

London

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


                </section>

Microsoft Excel in Depth: In-House Training

<p><strong>***Offer Ends Today***</strong></p><p><strong>Earn up to 40K as a 'DATA ANALYST' or Your 100% Money Back</strong></p><p>Do you know that entry-level data analysts earn an average of <strong>£40,000 </strong>annually, with the potential to quickly earn six figures with experience and expertise? Are you looking to join the high-demand field of data analytics and earn a handsome salary? Our <strong>Data Analyst Job Ready Program</strong> is here to guide you all the way until you get the job you want.</p><p>Our Data Analyst Job Ready Program is your all-in-one solution to learn data analytics from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in data analytics. By choosing our Data Analyst Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner.</p><p><strong>Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.</strong></p><p>Enrol Now and Kickstart Your Data Analytics Career. Don't miss this opportunity to transform your career with the Data Analyst Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of data analysts!</p><p>In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts, so we can help you get the job you want.</p><p>If you are not happy with our service, we also offer a <strong>100% money-back guarantee</strong>. So what are you waiting for? Enrol in our Data Analyst Job Ready Program today and start your journey to becoming a successful Data Analyst!</p><p><strong>Why Choose Us?</strong></p><p>So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst Job Ready Program:</p><ul><li><strong>Personalised Guidance: </strong>Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis.<br /><br /></li><li><strong>One-On-One Consultation Sessions with Experts: </strong>Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field.<br /><br /></li><li><strong>Extensive Job Opportunities:</strong> We have established partnerships with numerous companies actively seeking Data analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere.<br /><br /></li><li><strong>Interview Preparation:</strong> We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress.<br /><br /></li><li><strong>100% Money-Back Guarantee: </strong>Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee.</li></ul><p><strong>Courses we will provide once you enrol in the program:</strong></p><ul><li><strong>Course 01: </strong>Introduction to Data Analysis</li><li><strong>Course 02: </strong>Business and Data Analytics for Beginners</li><li><strong>Course 03: </strong>Data Analytics with Tableau</li><li><strong>Course 04: </strong>Quick Data Science Approach from Scratch</li><li><strong>Course 05: </strong>Learn MySQL from Scratch for Data Science and Analytics</li><li><strong>Course 06: </strong>SQL for Data Science, Data Analytics and Data Visualization</li><li><strong>Course 07: </strong>Statistics &amp; Probability for Data Science &amp; Machine Learning</li><li><strong>Course 08: </strong>Basic Google Data Studio</li><li><strong>Course 09: </strong>R Programming for Data Science</li><li><strong>Course 10: </strong>Python Data Science with Numpy, Pandas and Matplotlib</li><li><strong>Course 11: </strong>Complete Python Machine Learning &amp; Data Science Fundamentals</li><li><strong>Course 12: </strong>2021 Data Science &amp; Machine Learning with R from A-Z</li><li><strong>Course 13: </strong>Microsoft Excel Complete Course</li><li><strong>Course 14: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 15: </strong>Data Center Training Essentials: General Introduction</li><li><strong>Course 16: </strong>Excel Data Analysis</li><li><strong>Course 17: </strong>Data Entry Administrator Training</li><li><strong>Course 18: </strong>SQL Masterclass: SQL For Data Analytics</li><li><strong>Course 19: </strong>Business Data Analysis</li><li><strong>Course 20: </strong>Master JavaScript with Data Visualization</li></ul><p><strong>How Can We Offer Job Guarantees?</strong></p><p>HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector.</p> <p><strong>The Data Analyst Job Ready Program with Career Support &amp; Money Back Guarantee is completed in 9 easy steps:</strong></p><p><strong>Step 1: Enrol in the Programme</strong></p><p>Begin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied.</p><p>After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing!</p><p><strong>Step 2: Initial One-On-One Counselling Session</strong></p><p>Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path.</p><p><strong>Step 3: Certification upon Course Completion</strong></p><p>After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject.</p><p><strong>Step 4: CV Revamping</strong></p><p>Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently.</p><p><strong>Step 5: Building Network and Submitting CV</strong></p><p>We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile.</p><p><strong>Step 6: Interview Preparation</strong></p><p>With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills.</p><p><strong>Step 7: Securing Job Interviews</strong></p><p>Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want.</p><p><strong>Step 8: Post-Interview Support</strong></p><p>Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job.</p><p><strong>Step 9: Celebrate Your New Job!</strong></p><p>Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role.</p><p>We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        1000 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>This Data Analyst Job Ready Program is perfect for:</strong></p><ul><li>Beginners eager to break into the field of data analytics and get a job.</li><li>Professionals looking to move their career towards data science.</li><li>Individuals seeking a comprehensive understanding of data analysis tools and techniques.</li><li>Those aiming for a career upgrade with advanced analytics skills.</li><li>Anyone interested in gaining practical, job-ready skills in data analytics and machine learning.</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Data Analyst Job Ready Program will help you get a job in different roles, such as:</p><ul><li>Entry-Level Data Analyst: £25,000 - £35,000</li><li>Mid-Level Data Analyst: £35,000 - £60,000</li><li>Senior Data Analyst: £50,000 - £80,000</li><li>Data Scientist: £40,000 - £100,000</li><li>Data Analytics Manager: £60,000 - £100,000</li><li>Business Intelligence Analyst: £30,000 - £75,000</li><li>Machine Learning Engineer: £45,000 - £80,000</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited e-Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPD Accredited Framed (Hardcopy) Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>Enrolment Letter</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>QLS Endorsed Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>Student ID Card</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

***Offer Ends Today***
Earn up to 40K as a 'DATA ANALYST' or Your 100% Money Back
Do you know that entry-level data analysts earn an average of £40,000 annually, with the potential to quickly earn six figures with experience and expertise? Are you looking to join the high-demand field of data analytics and earn a handsome salary? Our Data Analyst Job Ready Program is here to guide you all the way until you get the job you want.
Our Data Analyst Job Ready Program is your all-in-one solution to learn data analytics from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in data analytics. By choosing our Data Analyst Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner.
Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.
Enrol Now and Kickstart Your Data Analytics Career. Don't miss this opportunity to transform your career with the Data Analyst Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of data analysts!
In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts, so we can help you get the job you want.
If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Data Analyst Job Ready Program today and start your journey to becoming a successful Data Analyst!
Why Choose Us?
So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst Job Ready Program:
Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis.
One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field.
Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Data analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere.
Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress.
100% Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee.
Courses we will provide once you enrol in the program:
Course 01: Introduction to Data Analysis
Course 02: Business and Data Analytics for Beginners
Course 03: Data Analytics with Tableau
Course 04: Quick Data Science Approach from Scratch
Course 05: Learn MySQL from Scratch for Data Science and Analytics
Course 06: SQL for Data Science, Data Analytics and Data Visualization
Course 07: Statistics & Probability for Data Science & Machine Learning
Course 08: Basic Google Data Studio
Course 09: R Programming for Data Science
Course 10: Python Data Science with Numpy, Pandas and Matplotlib
Course 11: Complete Python Machine Learning & Data Science Fundamentals
Course 12: 2021 Data Science & Machine Learning with R from A-Z
Course 13: Microsoft Excel Complete Course
Course 14: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 15: Data Center Training Essentials: General Introduction
Course 16: Excel Data Analysis
Course 17: Data Entry Administrator Training
Course 18: SQL Masterclass: SQL For Data Analytics
Course 19: Business Data Analysis
Course 20: Master JavaScript with Data Visualization
How Can We Offer Job Guarantees?
HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector.
The Data Analyst Job Ready Program with Career Support & Money Back Guarantee is completed in 9 easy steps:
Step 1: Enrol in the Programme
Begin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied.
After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing!
Step 2: Initial One-On-One Counselling Session
Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path.
Step 3: Certification upon Course Completion
After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject.
Step 4: CV Revamping
Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently.
Step 5: Building Network and Submitting CV
We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile.
Step 6: Interview Preparation
With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills.
Step 7: Securing Job Interviews
Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want.
Step 8: Post-Interview Support
Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job.
Step 9: Celebrate Your New Job!
Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role.
We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us.
 CPD 
1000 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This Data Analyst Job Ready Program is perfect for:
Beginners eager to break into the field of data analytics and get a job.
Professionals looking to move their career towards data science.
Individuals seeking a comprehensive understanding of data analysis tools and techniques.
Those aiming for a career upgrade with advanced analytics skills.
Anyone interested in gaining practical, job-ready skills in data analytics and machine learning.
 Career path 
This Data Analyst Job Ready Program will help you get a job in different roles, such as:
Entry-Level Data Analyst: £25,000 - £35,000
Mid-Level Data Analyst: £35,000 - £60,000
Senior Data Analyst: £50,000 - £80,000
Data Scientist: £40,000 - £100,000
Data Analytics Manager: £60,000 - £100,000
Business Intelligence Analyst: £30,000 - £75,000
Machine Learning Engineer: £45,000 - £80,000
 Certificates 
CPD Accredited e-Certificate
 Digital certificate - Included 
CPD Accredited Framed (Hardcopy) Certificate
 Hard copy certificate - Included 
Enrolment Letter
 Digital certificate - Included 
QLS Endorsed Hard Copy Certificate
 Hard copy certificate - Included 
Student ID Card
 Digital certificate - Included 

Academy for Health and Fitness

Business Analytics & Intelligence

Data Engineering

Big Data Analytics

Data Science

HR Analytics

Data Analyst

Data Analyst Job Guarantee Program with Career Support & Money Back Guarantee

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


                </section>

Microsoft Excel in Depth: Virtual In-House Training

<p fr-original-style=" color: rgb(98, 98, 98);" id="isPasted" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The eight 1/2 day Support Manager course is uniquely created to provide training on the fundamentals of management relative to the support environment, and to enhance the inherent skills and knowledge of the support manager. This course focuses specifically on the most common management elements that occur in the technical support centre including, managing customer satisfaction, operations and team performance management and facilitating a team while managing a dynamic service product. This course offers support managers the opportunity to develop and refine their technology support leadership skills enabling them to effectively manage the challenges of the most complex support centres.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Attend</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The Support Manager course is for managers who have at least six months management experience and have received some basic management training.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The course begins with a review and quiz on a set of pre-class reading materials. These materials are sent to each participant two weeks prior to the class start date. Participants are strongly encouraged to register at least two weeks in advance to allow time to complete these pre-class assignments.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">Each participant is required to bring the pre-class reading materials as well as a notebook computer with a USB port and with Microsoft Excel, Word and PowerPoint installed. These will be used as tools during the course. All other materials and tools will be provided.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">Homework is assigned for most evenings of the course. Please plan for study time outside of class.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Some of the training objectives&hellip;</b></p><ul fr-original-style=" color: rgb(115, 126, 134);" style="color: rgb(115, 126, 134); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Manage dynamics of change within the support centre</li><li fr-original-style="" style="box-sizing: border-box;">Enhance leadership skills</li><li fr-original-style="" style="box-sizing: border-box;">Effective staff utilisation</li><li fr-original-style="" style="box-sizing: border-box;">Increase support centre morale and retention</li></ul>

SGSA Limited

Support Manager

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.</p>Overview<p>Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance.</p><p>VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.</p>Prerequisites<p>To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.</p></div><div id="course-pills-2"><h3>1. Using VBA to Solve Business Problems</h3><ul> <li>Use Macros to Automate Tasks in Excel</li> <li>Identify Components of Macro-Enabled Workbooks</li> <li>Configure the Excel VBA Environment</li></ul>  <h3>2. Recording a Macro</h3><ul> <li>Use the Macro Recorder to Create a VBA Macro</li> <li>Record a Macro with Relative Addressing</li> <li>Delete Macros and Modules</li> <li>Identify Strategies for Using the Macro Recorder</li></ul>  <h3>3. Writing VBA Code Directly</h3><ul> <li>Write VBA Code</li> <li>Discover Objects You Can Use</li> <li>Create a Custom Function</li></ul>  <h3>4. Solving Problems through Code</h3><ul> <li>Make Decisions in Code</li> <li>Work with Variables</li> <li>Perform Repetitive Tasks</li></ul>  <h3>5. Improving Your VBA Code</h3><ul> <li>Debug VBA Errors</li> <li>Deal with Errors</li> <li>Improve Macro Performance</li></ul>  <h3>6.  Controlling How and When Macros Run</h3><ul> <li>Prompt the User for Information</li> <li>Configure Macros to Run Automatically</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Visual Basic

Access VBA

Visual Basic Analysis

Microsoft Virtual Academy (MVA)

VBA with Microsoft Excel

<p>Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel courses. At <strong>UKHF Online</strong>, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel. Whether you're a student, recent graduate, or job seeker, our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition.</p><p><strong>Key Features of the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel Bundle:</strong></p><ul><li><strong>3 QLS-Endorsed Courses:</strong> We proudly offer 3 QLS-endorsed courses within our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle, providing you with industry-recognized qualifications. Plus, you'll receive a <strong>free hardcopy certificate</strong> for each of these courses.</li><ul><li><strong>QLS Course 01: </strong>Microsoft Teams - Master Microsoft Teams</li><li><strong> QLS Course 02:</strong> The Complete Microsoft Outlook Masterclass</li><li><strong> QLS Course 03: </strong>New Functions in Microsoft Excel 2021</li></ul></ul><ul><li><strong>5 CPD QS Accredited Courses</strong>: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices.</li><ul><li><strong>Course 01: </strong>Microsoft Excel Complete Course 2019</li><li><strong>Course 02: </strong>Microsoft Office 2016 Advanced</li><li><strong>Course 03:</strong> Microsoft Access Databases Forms and Reports</li><li><strong>Course 04: </strong>Microsoft Word Advanced</li><li><strong>Course 05: </strong>Outlook Tips and tricks</li></ul></ul><ul><li>In Addition, you'll get <strong>Five Career Boosting Courses</strong> absolutely FREE with this Bundle.</li><ul><li><strong>Course 01: </strong>Professional CV Writing</li><li><strong>Course 02: </strong>Job Search Skills</li><li><strong>Course 03:</strong> Self Esteem &amp; Confidence Building</li><li><strong>Course 04: </strong>Professional Diploma in Stress Management</li><li><strong>Course 05: </strong>Complete Communication Skills Master Class</li></ul></ul><ul><li>Convenient Online Learning: Our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home.</li></ul><p><strong>Learning Outcomes of the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel Bundle:</strong></p><ul><li>Master the foundational principles and techniques of Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Develop advanced proficiency in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel methodologies and strategies.</li><li>Acquire in-depth knowledge of the latest trends and advancements in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Enhance your problem-solving and critical thinking abilities within the context of Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Cultivate strong communication and collaboration skills essential for success in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li></ul> <p>The Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle, giving you the recognition you deserve.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        250 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Professionals who want to improve their skills in Microsoft Office applications</li><li>Individuals who want to enhance their problem-solving and analytical skills</li><li>Anyone looking to develop their career in a business or administrative role</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Administrative Assistant: £17,000 - £30,000 per year</li><li>Business Analyst: £25,000 - £60,000 per year</li><li>Data Analyst: £22,000 - £48,000 per year</li><li>Operations Manager: £24,000 - £70,000 per year</li><li>Project Manager: £25,000 - £70,000 per year</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>

                        </div>

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Microsoft Teams, Microsoft Outlook & Microsoft Excel courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Microsoft Teams, Microsoft Outlook & Microsoft Excel. Whether you're a student, recent graduate, or job seeker, our Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition.
Key Features of the Microsoft Teams, Microsoft Outlook & Microsoft Excel Bundle:
3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses.
QLS Course 01: Microsoft Teams - Master Microsoft Teams
QLS Course 02: The Complete Microsoft Outlook Masterclass
QLS Course 03: New Functions in Microsoft Excel 2021
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: Microsoft Excel Complete Course 2019
Course 02: Microsoft Office 2016 Advanced
Course 03: Microsoft Access Databases Forms and Reports
Course 04: Microsoft Word Advanced
Course 05: Outlook Tips and tricks
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 Microsoft Teams, Microsoft Outlook & Microsoft Excel courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home.
Learning Outcomes of the Microsoft Teams, Microsoft Outlook & Microsoft Excel Bundle:
Master the foundational principles and techniques of Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Develop advanced proficiency in Microsoft Teams, Microsoft Outlook & Microsoft Excel methodologies and strategies.
Acquire in-depth knowledge of the latest trends and advancements in Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Enhance your problem-solving and critical thinking abilities within the context of Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Cultivate strong communication and collaboration skills essential for success in Microsoft Teams, Microsoft Outlook & Microsoft Excel.
The Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Microsoft Teams, Microsoft Outlook & Microsoft Excel. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle, giving you the recognition you deserve.
 CPD 
250 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
Professionals who want to improve their skills in Microsoft Office applications
Individuals who want to enhance their problem-solving and analytical skills
Anyone looking to develop their career in a business or administrative role
 Career path 
Administrative Assistant: £17,000 - £30,000 per year
Business Analyst: £25,000 - £60,000 per year
Data Analyst: £22,000 - £48,000 per year
Operations Manager: £24,000 - £70,000 per year
Project Manager: £25,000 - £70,000 per year
 Certificates 
Digital certificate
 Digital certificate - Included 
Hard copy certificate
 Hard copy certificate - Included 

Microsoft Teams

Office Skills & Productivity

Microsoft AZ-303

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Microsoft Teams, Microsoft Outlook & Microsoft Excel

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Virtual Instructor Led Training (VILT)</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">intermediate level 5 half-day Virtual Instructor Led Training (VILT) course</strong>&nbsp;is a comprehensive course that explains the technology of shell and tube heat exchangers as these robust types of heat exchangers are the most commonly used in the process and refinery industries where they provide flexibility and are easy to maintain.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The VILT course will provide details on the thermal and mechanical design, fabrication, inspection and maintenance in relation with international standards such as TEMA, API and ISO. For this heat exchanger type, the focus is on the mechanical and practical aspects.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Many case studies will be presented to demonstrate failures and mismatches. The thermal and mechanical design is conducted using sophisticated computer software and this VILT course is intended to complement thermal design training based on HTRI software. Participants will be offered problem case studies in order to reach solutions on their own.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To get a full picture of proven (advanced) heat transfer technologies, a basic training module for other types of heat exchangers is included. Besides Air Cooled, there will be a discussion on compact heat exchangers in more detail with all their pros and cons.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants are advised to bring a scientific calculator and laptop with Microsoft Excel installed.</p></section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING OBJECTIVES</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this VILT course, participants will be equipped on the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">For engineers, this VILT course will provide a broad understanding of the technology and an excellent base for further learning.</li><li fr-original-style="" style="box-sizing: border-box;">For those responsible for thermal design, TEMA type selection, the training is intended to illustrate the interaction between the thermal and mechanical design, the understanding of which will lead to more reliable design outcomes.</li><li fr-original-style="" style="box-sizing: border-box;">For those coming from an operating environment, the VILT course will lead to a greater knowledge of the maintenance, inspection and repair needs of shell and tube heat exchangers, including information on common causes of failure. Solutions will be offered using the latest &ldquo;state of art&rdquo; technologies used to prevent fouling, tube vibration and throughput limitations.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TARGET AUDIENCE</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This VILT course is intended for professionals who want to improve the performance of heat exchanger in their company for shell and tube and compact types and include:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Mechanical Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Design Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Maintenance Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Instrument Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Project Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Process Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Heat Transfer Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Plant Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Operation Engineers</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">COURSE LEVEL</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseThree" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING METHODS</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This VILT course will be delivered online in&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 half-day sessions comprising 4 hours per day</strong>, with 2 breaks of 10 minutes per day.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total).</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINER</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has almost 40 years of experience in Heat Exchanger Technologies. He is an international expert in heat exchanger type selection, special thermal/hydraulic design and latest enhanced heat transfer technologies. He conducts many training courses in this area and more than 1,000 employees, representing more than 250 companies, have attended his courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional Positions &amp; Credentials</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Former Chairman and Founder of HTRI&rsquo;s first Communication Committee: CC-Holland</li><li fr-original-style="" style="box-sizing: border-box;">CC-Holland (Chairman 1994 &ndash; 1997; Member 2004 &ndash; Present)</li><li fr-original-style="" style="box-sizing: border-box;">Chairman of NLAHX SenterNovem Working Party (1999 &ndash; 2010)</li><li fr-original-style="" style="box-sizing: border-box;">Member of ESDU Crude Oil Fouling Working Party (1999 &ndash; 2003)</li><li fr-original-style="" style="box-sizing: border-box;">Guest Lecturer Technical University Twente &amp; Eindhoven, The Netherlands</li><li fr-original-style="" style="box-sizing: border-box;">Guest Lecturer HTRI European Seminar October (2004 &amp; 2005)</li><li fr-original-style="" style="box-sizing: border-box;">Member of the Tasc-Force Committee ISO 16812</li><li fr-original-style="" style="box-sizing: border-box;">HTRI&rsquo;s Representative for The Netherlands (2008 &ndash; 2013)</li><li fr-original-style="" style="box-sizing: border-box;">Senior Fellow Heat Exchangers at BECHT</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Publications</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Reduced Total Life Cycle Costs Using Helixchanger Heat Exchangers and Enhancement Technology for the Process Industries (Co-Author, Davos, Switzerland July, 2001)</li><li fr-original-style="" style="box-sizing: border-box;">Reduced Total Life Cycle Costs Using Helixchanger Heat Exchangers (Co-Author, Hamilton, Canada, October, 2003)</li><li fr-original-style="" style="box-sizing: border-box;">Most frequently used Heat Exchangers from pioneering research to application worldwide (Co-Author, Prague, Czech Republic, October, 2004)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Previous Clients Include:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">BP</li><li fr-original-style="" style="box-sizing: border-box;">TOTAL</li><li fr-original-style="" style="box-sizing: border-box;">ExxonMobil</li><li fr-original-style="" style="box-sizing: border-box;">Shell Global Solutions</li><li fr-original-style="" style="box-sizing: border-box;">BASF</li><li fr-original-style="" style="box-sizing: border-box;">Technip</li><li fr-original-style="" style="box-sizing: border-box;">Aker Kvaerner</li><li fr-original-style="" style="box-sizing: border-box;">AKZO</li><li fr-original-style="" style="box-sizing: border-box;">Stamicarbon</li><li fr-original-style="" style="box-sizing: border-box;">FLUOR</li><li fr-original-style="" style="box-sizing: border-box;">Worley</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" rel="noopener" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information about post training coaching support</a>&nbsp;and fees applicable for this.</p></div></section>

EnergyEdge - Training for a Sustainable Energy Future

Maintenance

Acquire in-depth knowledge of heat exchanger design and cost-saving management with EnergyEdge's TEM & HTRI course. Join our virtual instructor-led training to stay ahead in the industry.

844 Courses

Advanced Diploma in MS Excel

By Apex Learning

Microsoft Office Skills for Admin, Secretarial, PA (Executive PA)

By Compliance Central

Microsoft Office 2016 Excel Beginner to Advanced

By Janets

Mastering Microsoft Office 2019 (Excel, Word, PowerPoint, Access)

By Compliance Central

Data Entry Clerk Level 3 Advanced Diploma

By Online Training Academy

Data Analysis In Excel Course

By Training Express

Diploma in Microsoft Office - An Introduction Course

By Training Express

Management for Managers

By Apex Learning

Management Level 5

By Apex Learning

Advanced Excel Course (Formula, VLOOKUP & Power Query)

By Apex Learning

Search By Location