8142 Courses

Full Excel Course Beginner to Advanced 6hrs

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Bayfield Training and the University of Cambridge Department of Land Economy This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise. If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you. This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.  Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment. On this course you will: Become a competent model builder, building Real Estate Financial Models from scratch Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia Learn how to use Real Estate Financial Models to make informed investment decisions Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill This course is suitable for: Chartered Surveyors Asset Managers Financial Controllers Financial Analysts Investment Managers Property Managers Real Estate Students/Recent Graduates Course Outline: Module 1 - Economic Context Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Why Real Estate Asset Modelling is important Understanding the occupier, asset and development markets and the relevant modelling approaches for each Real Estate Sub-Sector Key Performance Indicators Introduction to conventional valuations and financial mathematics Understanding and minimising errors in Financial Models Module 2 - Cash Flow Fundamentals Constructing a financial model from first principles. Understanding all the components of a basic cash flow model Understand why Corporate Finance Models and Real Estate Models are different Financial Model Design Making the link between valuations, income mathematics and discounted cash flows Internal Rate of Return, Net Present Value,Worth and other metrics Features and techniques to aid fast model building Module 3 - Developing the Cash Flow Adapting financial models for different periodicities and building rent functions for different rent behaviour. Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc. Developing the concept of a Rent Function in Excel Logic mathematics and Logic functions Projecting rent to adapt to different lease contracts and growth patterns Alternative solutions to Logic functions Comparative analysis of lease structures in different jurisdictions and adapting financial models Module 4 - Real Estate Data Understanding the different sources of data, constructing basic time series models and recognising basic patterns. Key Property market indicators Characteristics and application of key input metrics for Real Estate Appraisals Understanding the eight components of Real Estate Price Dynamics Awareness of the different sources of data Reading and using general property market reports Constructing basic time series models and recognising basic patterns Module 5 - Development Appraisals Constructing a development appraisal from first principles and understanding development return metrics. Understanding the key components of a development project Understanding the difference between development and investment appraisals Residual Appraisals and Profit Calculations Cost orientated cash flows and phased sales Cumulative construction cost patterns: incidental, fixed, loaded and S-curve Development return metrics and Modified IRRs Module 6 - Multi-let Cash Flows Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions. Multi-let and portfolio model design principles Building complex date functions and date series The three multi-let rent projection techniques Perpendicular Rent Functions Incorporate advanced rent adjustments into the Rent Function Incorporate sector and period varying rental growth rates Simplifying OPEX and CAPEX projections Discounting techniques on complex and volatile cash flows Module 7 - Project Finance Constructing a flexible Real Estate Debt Finance model. Revision of the Mathematics of amortisation and debt finance Basic senior debt models and geared net cash flow LTV, IRR and Interest Rate Dynamics Flexible term, repayment options and deferred interest Loan covenant tests Understanding different tranches of debt Understanding how complex debt structures impact the returns to different parties Module 8 - Model Interpretation and Risk Analysis Learn how to read, analyse and report on real estate financial models. Understand how to read models and develop an investment narrative Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins Learn how to construct varied project scenarios in a systematic way Introduction to Monte Carlo Analysis and VBA Optimising sale dates and other parameters Create well written, attractive and persuasive reports Included in the Course Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge 64 CPD Hours 1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee Course Files Q&A Webinars and Guest Speaker Webinars Further Learning Resources (Reading, Files and Videos) Post Course Support - Two Months of Questions & Answers 2024 Cohort Dates Include: 3rd June to 29th July 5th August to 25th September 2024 30th September to 25th November For more information, please contact Sam on the Bayfield Training Sales team: E - s.musgrave@bayfieldtraining.com T - 01223 517851 W - www.bayfieldtraining.com

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Are you ready to embark on an enlightening journey of wisdom with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Functional Skills IT with Microsoft Excel, IoT & ICT Training. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: IT Administration and Networking Course 2: Microsoft Excel Course Course 3: ICT: Information and Communication Technology Course 4: Start an IT Asset Department Course 5: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 6: Recruitment: IT Basics for IT Recruiters Course 7: Web Application Penetration Testing Course Course 8: Internet of Things Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle illuminate your path to wisdom. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Functional Skills IT with Microsoft Excel, IoT & ICT Training package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Functional Skills IT with Microsoft Excel, IoT & ICT Training community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Establish robust bases across each course nestled within the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Decipher intricate concepts through the articulate content of the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Functional Skills IT with Microsoft Excel, IoT & ICT Training journey and let knowledge guide you towards a brighter future. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle. Career path Armed with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, this bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data