<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You&#39;re OK at Excel, maybe you&#39;re great, we get it. Maybe you&#39;re the person people come to in the office to fix their spreadsheets, maybe you just like tinkering in Excel.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Did you ever wonder if there was something more?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">VBA will enable you to harness the full power of your spreadsheets.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Any repetitive tasks? Automated.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Any jobs that often end up with errors due to their complexity? Not any more.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need to collect and analyse data quickly? Done.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">These VBA sessions will not only teach you great coding best practices and ensure you know your way around the Development Environment, it will give you the practical skills to automate your workflow.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We also give you the resources to take your knowledge further</p>

Alumno Consulting

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Visual Basic for Applications (VBA) in Excel (from cool to geek in less than 1 day)

Class (max 20)

Redhill

<h3><b>PC fundamentals training course description</b></h3>
      <p>A basic introductory course for those who have never worked with PCs before. The principle target audience is for those who will become PC support people. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	<li>Cable PCs.</li>
					<li>Perform preventive maintenance on PCs</li>
                    <li>Run Windows and start applications.</li>
                    <li>Use Microsoft Office applications. </li>
                    <li>Customise Windows.</li>
                  </ul>
        <h5>
        <b>PC fundamentals training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone new to PCs.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>PC fundamentals training course contents</b></h3>
      <ul>
				<li>PC hardware </li><p>
Overview of components inside a PC, cabling up a PC, preventive maintenance, cleaning mice, hardware screen controls, booting a PC.

</p><li>Windows overview </li><p>
Versions of Windows, Starting Windows, logging on, shutting down.

</p><li>Using Windows </li><p>
The desktop, the start menu and submenus, getting help, shutting down Windows, switching between applications, sizing and controlling windows, special keys on the keyboard.

</p><li>Accessing files and folders </li><p>
Folders and files, Windows explorer, IE, creating, viewing and manipulating folders, creating, viewing and manipulating files, permissions, bits and bytes, the recycle bin, undeleting and undoing, formatting floppy disks, using floppy disks

</p><li>DOS </li><p>
Accessing DOS, basic DOS commands, drives.

</p><li>Microsoft Office </li><p>
Word documents, Excel spreadsheets, emails, browsing the Internet, printing files, managing print queues.

</p><li>Printing </li><p>
Overview, printing, properties

</p><li>Customisation </li><p>
Customising the task bar, customising the start menu. The control panel, mouse and display properties, Desktop settings, setting the date and time.

</p><li>Networking overview </li><p>
Workgroups and domains, Accessing file and print resources
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

PC fundamentals

General Admission

London

<p><strong>Course Objectives</strong></p><p>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Excel Intermediate - In-company

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong><em> </em></h2>
<p>Conducted in an interactive manner, Exploration Project Management will include presentations by the course leader, syndicate and plenary exercises, and (optional) assessment of selected participants' projects. Industry case studies will be integrated into all the presentations.</p>
<p>The course material will include a course manual (handout) and a course workbook (for exercises). Participants are requested to bring a mini-poster (two PowerPoint slides) as background material for discussion during the course.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>By the end of this Virtual Instructor Led Training (VILT), participants will be able to:</p>
<ol>
<li>Improve the evaluation, execution and delivery of exploration projects, measured in terms of successful bids for new acreage, increased success rate and volume delivery from exploration drilling, and more rapid progress in appraisal of discoveries.</li>
<li>Describe concepts, simple processes, workflows and analysis tools for project execution. Tools include the expert course leader's proprietary project management framework, including project framing and after-action review methodologies, templates for strategy development, decision trees, decision quality frameworks. They also include customised Excel spreadsheets for portfolio modelling, project risk assessment (in new ventures and prospect maturation) and business planning.</li>
<li>Understand their role in (a) delivering the company's strategy, (b) contributing data and assessments to key exploration decision makers, and (c) communicating project progress and results to senior management.</li>
</ol>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>The Virtual Instructor Led Training (VILT) is aimed at exploration professionals with more than 5 to 10 years of experience in the business, who would like to develop their skills for managing exploration projects and presenting the goals and results of their project work to senior management.</p>
<ul>
<li>Exploration and engineering professionals who work in exploration project teams, across the spectrum from new ventures (exploration business development), prospect identification and maturation, and appraisal of discoveries</li>
<li>Exploration project leaders</li>
<li>Exploration managers</li>
</ul>
<p>The VILT will also benefit professionals from well engineering, petroleum engineering, finance and planning who support exploration activities.</p>
<p>Participants are requested to bring a mini-poster (two PowerPoint slides, each printed on A3 paper) as background material for discussion during the course.</p>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America.</p>
<p>Other than delivering industry training, he has worked on projects for oil &amp; gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting  firms.</p>
<p>He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences.</p>
<p>Professional Experience</p>
<ul>
<li>Management consultancy &amp; executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil &amp; gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment.</li>
<li>Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers.</li>
<li>Accountability &amp; decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations.</li>
<li>Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management).</li>
<li>Technical &amp; operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia.</li>
<li>Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record.</li>
<li>R&amp;D: Experience in the 3 key roles in R&amp;D: scientific researcher, research manager, and 'customer' for R&amp;D products. After re-defining Shell's exploration R&amp;D strategy, led the re-structuring of the R&amp;D organization, its interface with 'the business' and approaches to deployment and commercialization.</li>
<li>Strategy: Accomplished at formulating competitive strategies in business, R&amp;D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme.</li>
<li>Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development.</li>
<li>Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&amp;P contracts, with values of $5 million to $100+ million.</li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' 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 />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Exploration Project Management

Team of 10, pp

Normal Fee, pp

Improove your excel skills with Time Training Center’s advanced excel course in Abdu Dhabi. Our advanced Training can help you master the latest functions and tools in MS Excel.Acquire multiple skills, such as calculating, evaluating, organising, and coordinating data through spreadsheets.




Enroll now!
Call us: 97126713828
Mail : info@timetraining.ae
Learn more:https://www.timetraining.ae/course/advanced-excel-course-in-abu-dhabi
Address: Office 203, ADCP Tower - B,Behind City Seasons, Electra Street, Abu Dhabi United Arab Emirates



Time Training Center

Advanced Excel Course in Abu Dhabi

Harpenden

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


                </section>

The In House Training Company

Office Skills & Productivity

Office Skills

Excel Analytics

Microsoft Excel

Microsoft Office

Spreadsheet

Excel - introduction (In-House)

<p>Businesses that don't control their costs don't stay in business. How well are you doing? Is everyone in your organisation sufficiently aware of costs, managing them effectively and maximising opportunities to reduce them? If there is scope for improvement, this course will help get you back on track. It will demonstrate that cost reduction is so much more than cost control and cost cutting. True cost management is about being aware of costs, seeking to reduce them through good design and efficient operating practices whilst taking continuing action on overspending.</p>This course will develop the participants' skills in:<ul><li>Being aware of costs at all times</li><li>Seeking cost reduction from the start (including life-cycle costing)</li><li>Appraising projects / production to identify and take out risk</li><li>Understanding real budgeting</li><li>Using techniques such as ZBB and ABC where appropriate</li><li>Ensuring cost reports lead to action</li><li>Managing a cost reduction process that delivers</li></ul><p>Benefits to the organisation will include:</p><ul><li>Identification of cost reduction and business improvement opportunities</li><li>Better reporting and ownership of costs</li><li>Greater awareness and control of everyday costs</li></ul><section>
                    <h3>1 Introduction - the cost management process</h3><ul><li>The risks of poor cost control</li><li>Capital and revenue costs</li><li>The importance of cost awareness</li><li><em>The importance of cost reduction</em></li><li>Cost management - the key aspects</li><li>How to build a cost management and control process checklist for your areas of responsibility</li></ul> <h3>2 Cost removal - taking out costs</h3><ul><li>Cost awareness</li><li>Costs of poor design / poor processes</li><li>Value engineering</li><li>Removing redundant costs</li></ul> <h3>3 The need for commercial, technical and financial appraisals</h3><ul><li>Understand the problems before cash is committed and costs incurred</li><li>Making the effort to identify commercial and technical risk</li><li>The time value of money - DCF techniques for long term projects</li><li>Cost models for production processes and projects</li><li>Costing models - project appraisals</li><li>The use of spreadsheets to identify sensitivity and risk</li><li>How to focus on risk management</li></ul> <h3>4 Budgeting - proper budgeting challenges costs</h3><ul><li>The philosophy of the business - are costs an issue?</li><li>The importance of having the right culture</li><li>The need for detailed business objectives</li><li>Budgetary control measures</li><li>Designing budget reports - for action</li></ul> <h3>5 Zero-based budgeting (ZBB) - the principles</h3><ul><li>Much more than starting with a clean sheet of paper</li><li>What ZBB can achieve</li><li>The concept of decision packages - to challenge business methods and costs</li><li>Only necessary costs should be incurred</li><li>A review of an operating budget - demonstrating what ZBB challenges and the costs it may lead to being taken out</li></ul> <h3>6 Awareness of overheads and other costs</h3><ul><li>Definitions of cost - direct and indirect</li><li>Dealing with overheads - what is meant by allocation, absorption or apportionment?</li><li>The apparent and real problems with overheads</li><li>Different ways of dealing with overheads</li><li>Review of overhead allocation methods and accounting and reporting issues</li></ul> <h3>7 Overheads and product costing</h3><ul><li>Activity-based costing (ABC) - the principles</li><li>Where and how the ABC approach may be helpful</li><li>Know the 'true' cost of a product or a project</li><li>Should you be in business? Will you stay in business?</li><li>Identifying weaknesses in a traditional overhead allocation</li><li>How ABC will help improve product or service costing</li><li>Identifying which products and activities should be developed and which abandoned</li></ul> <h3>8 Cost reduction culture</h3><ul><li>The need for cost reports</li><li>What measures can be used to identify over-spends as early as possible</li><li>Cost control performance measures and ratios</li></ul> <h3>9 Design of cost control reports</h3><ul><li>Reports should lead to action and deliver</li><li>Selecting cost control measures which can be acted upon</li><li>Practice in designing action reports</li></ul> <h3>10 Course summary - developing your own cost action plan</h3><ul><li>Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs</li></ul> 


                </section>

Business Analysis

Business Case Development

Manager Training

Finance For Non Finance Managers

Management Skills

Practical Accounting

Cost reduction (In-House)



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

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Professional Development

Continuous Professional Development (CPD)

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.</p>Overview<p>Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.</p><p>This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</p></div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

Nexus Human

Excel - Excel Essentials and Formulas

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>

				</div>
				<div>
				<div>
					<div><p><span>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Link Access Tables to Excel Spreadsheets </span><span> has been specially designed to help learners gain a good command of Link Access Tables to Excel Spreadsheets</span><span>, providing them with a solid foundation of knowledge to become a qualified professional.</span></p><p><span>Through this Link Access Tables to Excel Spreadsheets</span><span>, you will gain both practical and theoretical understanding of Link Access Tables to Excel Spreadsheets</span><span> that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</span></p><p><span>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</span></p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Learning outcome</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Get a deep understanding of the Link Access Tables to Excel Spreadsheets just in hours not years</span>
									</li>
								<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical and practical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span> Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want </span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Requirements</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to any internet-enabled smart device.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<h2>Why should I take this course?</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>2+ hours of on-demand video lectures and downloadable resources.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful salespeople to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various practical sales techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Link Access Tables to Excel Spreadsheets</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Autoforms</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Form Wizard</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Changing a form with design view</td><td><span>🕐 00:26:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding controls to your form</td><td><span>🕐 00:21:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Subforms</td><td><span>🕐 00:15:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Using Autoreport to create a report</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Using the Report Wizard to create a report</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Changing a report in design view</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding Calculations to your report</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding Groups, Sorts and Totals to reports</td><td><span>🕐 00:16:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Making labels with the Label Wizard</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Form and Report Properties</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Exporting a report to Excel</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Creating a menu with the Switchboard Manager</td><td><span>🕐 00:17:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Finalizing the Application</td><td><span>🕐 00:08:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Online Course Marketing

Online Course Creation

Computer Skills

Microsoft Access

Trainers Course

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Link Access Tables to Excel Spreadsheets

<strong>Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board</strong>
        <p>Group site project with Google Script - Google Site and Web apps - Spreadsheet
Do you want to connect Google Apps Together and make some really amazing things happen?  Course will provide you the foundation to work with Google Script to build a Web App that can be embedded in Google Sites. Within the course we show you how to use Google Spreadsheet as a source for retrieving and storing data.  Power up what you do online, bringing together built in functionality in your Google Suite. JavaScript developers extend your knowledge and learn how you can use your skills to develop apps script bringing together all the power of Google's Apps. 
Course Covers
- Basics of Google Script - how to use the online editor and overview of the functionality
- How to create a bound script to your Google Sheet
- Add new rows and get contents from Google Spreadsheet
- Sort and update Google Sheet data
- How to select sheet contents
- How to use HTTP service to output an HTML file within Google Web apps
- Use web apps to create interactive content
- Use JavaScript within Google Apps and Google client-side pages
- Setup a Google site and embed your Google script
- Use session values and other powerful built-in script methods
- Fine tune and tweak debug web apps
All this and more
Build a nice interactive project from scratch alongside the lessons within the course. Practice JavaScript and data handling, JSON, JavaScript objects, Array and more
Google Apps Script : is based on JavaScript 1.6 with some portions of 1.7 and 1.8 and provides subset of ECMAScript 5 API however instead of running on the client, it gets executed in the Google Cloud. According to Google, Apps Script "provides easy ways to automate tasks across Google products and third party services."Apps Script is also the tool that powers the add-ons for Google Docs, Sheets and Slides."
If you haven't tried it yet, I guarantee you will be BLOWN AWAY at how powerful Google Script can be, and at how easy it is to write.  With just a few lines of code, you can DO A WHOLE LOT!!! Don't take my word for it try it and see.
Taught by an instructor with over 20 years of web development experience, ready to help you learn. What are you waiting for this course is perfect to start writing Google Script and to practice writing Google Script, you have nothing to lose.
All the code and supporting files for this course are available at: https://github.com/PacktPublishing/Google-Apps-Script---A-Project-Based-Exercise-Using-Spreadsheets-and-Web-Apps</p>
        <h2>What You Will Learn</h2><p>?? Create web apps with Google Script<br>?? Build your own post application<br>?? Add Google Scripts apps to Google Sites<br>?? Update and use Spreadsheet data within Google Sites</p>
        <h2>Audience</h2><p>This course is for application developers, anyone who wants to learn about Google Apps Script or wants to create web apps with Google Apps Script and JavaScript developers who want to extend their knowledge.</p>
        <h2>Approach</h2><p>The course will provide you with the foundation to work with Google Script to build a Web App that can be embedded in Google Sites.</p>
        <h2>Key Features</h2><p>You only need JavaScript knowledge. * Perfect course to learn and practice Google Apps Script * Source Code is included so you can build the same app we build in the course, but even better.</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/google-apps-script---a-project-based-exercise-using-spreadsheets-and-web-apps</p>
        <h2>About the Author</h2><h3>Laurence Lars Svekis</h3><p>Laurence Svekis is an experienced web application developer. He has worked on multiple enterprise-level applications, hundreds of websites, business solutions, and many unique and innovative web applications. He has expertise in HTML, CSS, JavaScript, jQuery, Bootstrap, PHP, and MySQL and is also passionate about web technologies, web application development, programming, and online marketing with a strong focus on social media and SEO. He is always willing to help his students experience what technology has to offer and looks forward to sharing his knowledge and experiences with the world.</p>
        <h2>Course Outline</h2><h4>1. Introduction to Building Web Apps with Google Script</h4><p></p><br><h4>2. Bonus Section</h4><p></p>

Packt

Google Apps Script

Programming

Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board

Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps

Own Your Success

Learning & Development

Leadership

Business Leadership

Administrative Assistant

Career Development

Leadership Skills

Personal Assistant

Leadership Development

Executive Assistant

Corporate Learning & Development

Ethical Leadership

Discover how to elevate your career as an executive assistant or personal assistant with our comprehensive EA Mastery Workshop. Gain new skills, strategies, and tools to maximize your impact and achieve success.

EA/PA Excellence Workshop Virtual

Early release

General release

<p style="color: rgb(80, 54, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Are you self-taught in Excel? Our "Fundamentals of Excel" course provides you with a good refresher of the tricks of the trade and some quick easy wins. Making time spent on spreadsheets efficient, effective and painless!</p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Entering text, numbers and Autofill</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Navigating Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Selecting and editing</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Using the Sum function</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Basic formulae</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Rows, columns and borders</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Freezing panes</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Printing from Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Custom use</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 weeks - 2 sessions a week (2hrs live online)</p><ul type="disc" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">11 June , 13 June, 18 June and 20 June</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tuesdays &amp; Thursdays 09:30 - 11:30</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;275+VAT per person</p><h2 style="color: rgb(35, 73, 109); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 73, 109);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course is also available as in-house training at a fixed cost for up to 8 delegates.&nbsp;</span><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Email us for more information. <a href="mailto:admin@sterlingtraining.org" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">admin@sterlingtraining.org</a>.uk</span></h2>

Sterling Training

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

Fundamentals of Excel

<p dir="ltr" id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Whetstone Communications, in association with comms2point0, are delighted to bring you the Data Bites series of five <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">free</strong> webinars.</p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Our aim is to boost interest and levels of data literacy among not-for-profit communicators.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">By taking part, you will gain:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Confidence in using some basic data techniques</span></li><li dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Examples and ideas for using data in your daily work</span></li><li dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Insight into using the power of AI for powerful insights</span></li><li dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">New knowledge and skills to help you stand out from the crowd - and even win awards&nbsp;</span></li></ul><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Now Booking: SESSION 4:&nbsp;</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Smashing spreadsheets - five great functions for comms pros (30 mins) - FREE</strong></span></div><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn about five functions in Excel that&#39;ll help you start getting more from data</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sort<br fr-original-style="" style="box-sizing: border-box;">Filter<br fr-original-style="" style="box-sizing: border-box;">Correlate<br fr-original-style="" style="box-sizing: border-box;">Pivot<br fr-original-style="" style="box-sizing: border-box;">Import</p>

Alex Waddington

Communication

Digital Communication

Public Relations (PR)

Data Analysis

Whetstone Communications and comms2point0 are pleased to bring you the Data Bites series of free webinars. Our aim is to boost interest and levels of data literacy among not-for-profit communicators.

[Data Bites for Comms Pros] #4 Smashing spreadsheets - five great functions for insight (30 mins) 

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn the basic formatting techniques necessary to enhance the way data displays on a worksheet and in print. You will learn how to:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Adjust column width and row height</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Format text, change alignment of data, format numbers</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Copy formatting to other cells</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create conditional formatting rules</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create and apply styles</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Use Page Layout and Page Break Preview</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Set up column and row headings to print on each page</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Insert page breaks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Scale your data to fit on pages</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Show/hide gridlines</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Insert a header and footer&nbsp;</span></li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This class is:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">90 minutes</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</span></li></ul>

AXIOM Learning Solutions

Microsoft Excel - Formatting Spreadsheets

<h2><strong>Course Overview:</strong></h2>

<p>About 87% of global consumers use at least one device to access the internet daily. Understanding the intricate workings of computers and the internet is indispensable. The "Learning Computers and Internet Level 2" course delves deep into the core elements of computer systems, the internet, and software applications, providing learners with an enriched understanding to navigate the digital age with confidence.</p>



<p>This course delves into a broad spectrum of computer-related topics, from operating systems and hardware fundamentals to advanced concepts such as cybersecurity and data protection. With engaging content, you'll embark on a journey of exploration and skill development that will undoubtedly shape your digital competence.</p>



<p>Discover the digital realm like never before. Start your journey with "Learning Computers and Internet Level 2" today!</p>

<hr />

<h2><strong>Key Features of the Course:</strong></h2>

<ul>
<li>Earn a CPD certificate upon course completion.</li>



<li>Always have access to academic support any time you need it.</li>



<li>Contemporary and engaging learning materials that make mastering the content enjoyable.</li>
</ul>


<hr />

<h2><strong>Who is This Course For?</strong></h2>
<p>This course is designed for individuals seeking to build upon foundational knowledge of computers and the internet. Whether a student, professional, or enthusiast, this course will elevate your proficiency.</p>

<hr />

<h2><strong>Learning Outcome</strong></h2>

<ul>
<li>Grasp the intricacies of various operating systems and their configurations.</li>



<li>Understand the diverse range of applications and their functionalities.</li>



<li>Navigate through storage solutions, network components, and software tools.</li>



<li>Comprehend the concept of licensing and its implications.</li>



<li>Become adept in word processing, spreadsheets, and creating presentations.</li>



<li>Learn the terminologies of networking, ensuring smooth connectivity.</li>



<li>Safeguard yourself online and understand the fundamentals of digital security.</li>



<li>Acquire skills to use browsers, e-mails, and collaborative platforms effectively.</li>
</ul>

<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>
<p>Enrolling in "Learning Computers and Internet Level 2" is your gateway to a world of opportunities and possibilities. You will develop essential skills in high demand across various industries, making you a valuable asset in the job market. Our course is top-reviewed, recently updated to reflect the latest trends, and aligns with the evolving digital landscape, ensuring you stay ahead in the digital race.</p>
<hr />

<h2><strong>Requirements:</strong></h2>
<p>Enrolling in this Learning Computers and Internet Level 2 course requires a basic understanding of computer usage. No prior technical knowledge is needed, making it accessible to beginners and those looking to refresh their skills.</p>
<hr />

<h2><strong>Career Path:</strong></h2>

<p>Upon completing this Learning Computers and Internet Level 2 course, you'll be well-equipped to pursue various professions in the digital domain. Here are seven course-related professions in the UK, along with their average salaries:</p>



<ul>
<li>IT Support Specialist: £25,000 - £40,000 per year</li>



<li>Data Entry Clerk: £18,000 - £25,000 per year</li>



<li>Digital Marketing Assistant: £20,000 - £30,000 per year</li>



<li>Office Administrator: £18,000 - £25,000 per year</li>



<li>Cybersecurity Analyst: £30,000 - £50,000 per year</li>



<li>Web Developer: £25,000 - £45,000 per year</li>



<li>Database Administrator: £30,000 - £50,000 per year</li>
</ul>





<hr />

<h2><strong>Certification:</strong></h2>
<p>Upon completing the Learning Computers and Internet Level 2 course, learners will be awarded a CPD certificate, validating their enhanced knowledge of computers and the Internet.</p>
<hr /> <h3>Course Curriculum</h3><div><p>6 sections • 81 lectures • 22:23:00 total length</p></div><div><div><div><div><div><div><div><p>•What is an Operating System: 00:48:00</p></div><div><div><p>•Configuring the Operating System: 00:06:00</p></div><div><div><p>•What is an Application: 00:10:00</p></div><div><div><p>•Using Control Panel: 00:18:00</p></div><div><div><p>•Hardware and Peripherals: 00:07:00</p></div><div><div><p>•Storage: 00:12:00</p></div><div><div><p>•Connectivity Devices: 00:05:00</p></div><div><div><p>•Network Components: 00:09:00</p></div><div><div><p>•Software and Concepts: 00:11:00</p></div><div><div><p>•Licensing: 00:06:00</p></div><div><div><p>•Using Software: 00:07:00</p></div><div><div><p>•Software Tools: 00:10:00</p></div><div><div><p>•Software: 00:14:00</p></div><div><div><p>•Hardware, Devices, and Peripherals: 00:05:00</p></div><div><div><p>•Backup and Restore: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Application Features: 01:21:00</p></div><div><div><p>•Working with Word Processing: 00:44:00</p></div><div><div><p>•Working with Spreadsheets: 00:49:00</p></div><div><div><p>•Making a Presentation: 01:08:00</p></div><div><div><p>•Databases: 00:34:00</p></div><div><div><p>•Collaboration: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Course Introduction: 00:02:00</p></div><div><div><p>•Web Browsers: 00:46:00</p></div><div><div><p>•Networking Terminology: 00:35:00</p></div><div><div><p>•E-mail: 00:38:00</p></div><div><div><p>•Communicating in the Modern World: 00:14:00</p></div><div><div><p>•Protecting Yourself: 00:15:00</p></div><div><div><p>•Web Searching: 00:31:00</p></div><div><div><p>•Protecting Yourself: 00:31:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Identify Components of a Personal Computer IPU: 00:08:00</p></div><div><div><p>•Sign In to Windows 8: 00:07:00</p></div><div><div><p>•Signing In to Windows 8 and Managing Tiles: 00:08:00</p></div><div><div><p>•Navigate the Start Screen: 00:18:00</p></div><div><div><p>•Using the Account ID Menu: 00:02:00</p></div><div><div><p>•Access and Identify the Charms: 00:03:00</p></div><div><div><p>•Viewing the Charms: 00:02:00</p></div><div><div><p>•Modern Apps and Common Navigation Features: 00:03:00</p></div><div><div><p>•Navigating a Modern App: 00:07:00</p></div><div><div><p>•Multitasking with Apps: 00:05:00</p></div><div><div><p>•Working with Multiple Apps: 00:05:00</p></div><div><div><p>•Navigate the Desktop IPU: 00:07:00</p></div><div><div><p>•Navigating The desktop: 00:07:00</p></div><div><div><p>•Manage Files and Folders with File Explorer IPU: 00:09:00</p></div><div><div><p>•Managing Files and Folders: 00:15:00</p></div><div><div><p>•Elements of a Desktop Window: 00:12:00</p></div><div><div><p>•Working with the Elements of a Desktop Window: 00:10:00</p></div><div><div><p>•Creating and Modifying Files with Wordpad: 00:14:00</p></div><div><div><p>•Printing a Document: 00:05:00</p></div><div><div><p>•Navigate Internet Explorer 10: 00:08:00</p></div><div><div><p>•Navigating Internet Explorer 10: 00:09:00</p></div><div><div><p>•Browse the Web: 00:12:00</p></div><div><div><p>•Using Internet Explorer and Share: 00:08:00</p></div><div><div><p>•Customize the Start Screen: 00:07:00</p></div><div><div><p>•Creating Groups on the Start Screen: 00:03:00</p></div><div><div><p>•Changing PC Setting: 00:07:00</p></div><div><div><p>•Customize the Desktop IPU: 00:09:00</p></div><div><div><p>•Personalizing the Desktop: 00:11:00</p></div><div><div><p>•Set Privacy Levels and Passwords: 00:05:00</p></div><div><div><p>•Changing Your Password: 00:05:00</p></div><div><div><p>•Use Windows Defender IPU: 00:05:00</p></div><div><div><p>•Changing Windows Defender Settings: 00:06:00</p></div><div><div><p>•Store and Share Files with SkyDrive: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•What Makes Windows 10 Different?: 00:14:00</p></div><div><div><p>•Primary Feature Overview: 00:14:00</p></div><div><div><p>•Navigating and Using Windows 10: 00:36:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Course Overview: 00:13:00</p></div><div><div><p>•Types of Security Threats: 00:29:00</p></div><div><div><p>•Social Engineering: 00:30:00</p></div><div><div><p>•Identity Theft: 00:29:00</p></div><div><div><p>•Data Classification: 00:28:00</p></div><div><div><p>•Types of Classifications: 00:18:00</p></div><div><div><p>•Protecting Your Digital Information: 00:45:00</p></div><div><div><p>•Password Management: 00:13:00</p></div><div><div><p>•Malware: 00:17:00</p></div><div><div><p>•Software Detection: 00:28:00</p></div><div><div><p>•Security from End-to-End: 00:26:00</p></div><div><div><p>•Secure E-mail Use: 00:21:00</p></div><div><div><p>•Secure Web Browsing: 00:29:00</p></div><div><div><p>•Piracy: 00:16:00</p></div><div><div><p>•Security Policies: 00:18:00</p></div><div><div><p>•Moving Forward: 00:12: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>

Course Overview:
About 87% of global consumers use at least one computer or device to access the internet daily. Mastering the essentials of computer and the internet is crucial in today’s digital age. The Learning Computer and Internet Level 2 course provides an in-depth exploration of computer systems, internet functionalities, and software applications, offering you the knowledge to navigate the digital world with ease.
This course covers a wide range of computer-related topics, from fundamental operating systems and hardware to advanced concepts like cybersecurity and data protection. With engaging, interactive content, you’ll gain practical skills and insights that enhance your computer proficiency and digital competence.
Embark on an enlightening journey through the digital landscape. Enrol in Learning Computer and Internet Level 2 today and elevate your computer skills to thrive in a connected world!



Key Features of the Course:
FREE Learning Computer and Internet Level 2 CPD-accredited certificate
Get a free student ID card with Learning Computer and Internet Level 2 training (£10 applicable for international delivery)
Lifetime access to the Learning Computer and Internet Level 2 course materials
The Learning Computer and Internet Level 2 program comes with 24/7 tutor support
Get instant access to this Learning Computer and Internet Level 2 course
Learn Learning Computer and Internet Level 2 training from anywhere in the world
The Learning Computer and Internet Level 2 training is affordable and simple to understand
The Learning Computer and Internet Level 2 training is entirely online



Who is This Course For?
This course is designed for individuals seeking to build upon foundational knowledge of computer and the internet. Whether a student, professional, or enthusiast, this course will elevate your proficiency.



Learning Outcome
Grasp the intricacies of various operating systems and their configurations.
Understand the diverse range of applications and their functionalities.
Navigate through storage solutions, network components, and software tools.
Comprehend the concept of licensing and its implications.
Become adept in word processing, spreadsheets, and creating presentations.
Learn the terminologies of networking, ensuring smooth connectivity.
Safeguard yourself online and understand the fundamentals of digital security.
Acquire skills to use browsers, e-mails, and collaborative platforms effectively.



Why Enrol in This Course:
Enrolling in "Learning Computer and Internet Level 2" is your gateway to a world of opportunities and possibilities. You will develop essential skills in high demand across various industries, making you a valuable asset in the job market. Our course is top-reviewed, recently updated to reflect the latest trends, and aligns with the evolving digital landscape, ensuring you stay ahead in the digital race.



Requirements:
Enrolling in this Learning Computer and Internet Level 2 course requires a basic understanding of computer usage. No prior technical knowledge is needed, making it accessible to beginners and those looking to refresh their skills.



Career Path:
Upon completing this Learning Computer and Internet Level 2 course, you'll be well-equipped to pursue various professions in the digital domain. Here are seven course-related professions in the UK, along with their average salaries:
IT Support Specialist: £25,000 - £40,000 per year
Data Entry Clerk: £18,000 - £25,000 per year
Digital Marketing Assistant: £20,000 - £30,000 per year
Office Administrator: £18,000 - £25,000 per year
Cybersecurity Analyst: £30,000 - £50,000 per year
Web Developer: £25,000 - £45,000 per year
Database Administrator: £30,000 - £50,000 per year



Certification:
Upon completing the Learning Computer and Internet Level 2 course, learners will be awarded a CPD certificate, validating their enhanced knowledge of computer and the Internet.



Course Curriculum
6 sections • 81 lectures • 22:23:00 total length
•What is an Operating System: 00:48:00
•Configuring the Operating System: 00:06:00
•What is an Application: 00:10:00
•Using Control Panel: 00:18:00
•Hardware and Peripherals: 00:07:00
•Storage: 00:12:00
•Connectivity Devices: 00:05:00
•Network Components: 00:09:00
•Software and Concepts: 00:11:00
•Licensing: 00:06:00
•Using Software: 00:07:00
•Software Tools: 00:10:00
•Software: 00:14:00
•Hardware, Devices, and Peripherals: 00:05:00
•Backup and Restore: 00:03:00
•Application Features: 01:21:00
•Working with Word Processing: 00:44:00
•Working with Spreadsheets: 00:49:00
•Making a Presentation: 01:08:00
•Databases: 00:34:00
•Collaboration: 00:03:00
•Course Introduction: 00:02:00
•Web Browsers: 00:46:00
•Networking Terminology: 00:35:00
•E-mail: 00:38:00
•Communicating in the Modern World: 00:14:00
•Protecting Yourself: 00:15:00
•Web Searching: 00:31:00
•Protecting Yourself: 00:31:00
•Identify Components of a Personal Computer IPU: 00:08:00
•Sign In to Windows 8: 00:07:00
•Signing In to Windows 8 and Managing Tiles: 00:08:00
•Navigate the Start Screen: 00:18:00
•Using the Account ID Menu: 00:02:00
•Access and Identify the Charms: 00:03:00
•Viewing the Charms: 00:02:00
•Modern Apps and Common Navigation Features: 00:03:00
•Navigating a Modern App: 00:07:00
•Multitasking with Apps: 00:05:00
•Working with Multiple Apps: 00:05:00
•Navigate the Desktop IPU: 00:07:00
•Navigating The desktop: 00:07:00
•Manage Files and Folders with File Explorer IPU: 00:09:00
•Managing Files and Folders: 00:15:00
•Elements of a Desktop Window: 00:12:00
•Working with the Elements of a Desktop Window: 00:10:00
•Creating and Modifying Files with Wordpad: 00:14:00
•Printing a Document: 00:05:00
•Navigate Internet Explorer 10: 00:08:00
•Navigating Internet Explorer 10: 00:09:00
•Browse the Web: 00:12:00
•Using Internet Explorer and Share: 00:08:00
•Customize the Start Screen: 00:07:00
•Creating Groups on the Start Screen: 00:03:00
•Changing PC Setting: 00:07:00
•Customize the Desktop IPU: 00:09:00
•Personalizing the Desktop: 00:11:00
•Set Privacy Levels and Passwords: 00:05:00
•Changing Your Password: 00:05:00
•Use Windows Defender IPU: 00:05:00
•Changing Windows Defender Settings: 00:06:00
•Store and Share Files with SkyDrive: 00:03:00
•What Makes Windows 10 Different?: 00:14:00
•Primary Feature Overview: 00:14:00
•Navigating and Using Windows 10: 00:36:00
•Course Overview: 00:13:00
•Types of Security Threats: 00:29:00
•Social Engineering: 00:30:00
•Identity Theft: 00:29:00
•Data Classification: 00:28:00
•Types of Classifications: 00:18:00
•Protecting Your Digital Information: 00:45:00
•Password Management: 00:13:00
•Malware: 00:17:00
•Software Detection: 00:28:00
•Security from End-to-End: 00:26:00
•Secure E-mail Use: 00:21:00
•Secure Web Browsing: 00:29:00
•Piracy: 00:16:00
•Security Policies: 00:18:00
•Moving Forward: 00:12:00

7 Courses in Coventry

Visual Basic for Applications (VBA) in Excel (from cool to geek in less than 1 day)

By Alumno Consulting

PC fundamentals

By Systems & Network Training

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Exploration Project Management

By EnergyEdge - Training for a Sustainable Energy Future

Advanced Excel Course in Abu Dhabi

By Time Training Center

Excel - introduction (In-House)

By The In House Training Company

Cost reduction (In-House)

By The In House Training Company

Search By Location