J.W. Durham Darlington Fire Rescue, Excel Level 3
L.B. Greggs, Excel Analysing and Presenting Data with Dashboards and Pivot Tables
A.R. NIHR Clinical Research Network North East and Nort, Adobe Photoshop Level 1
- Personal Effectiveness and Communication Skills with Clarity 4D Personality Profile
- APM Fundamentals of Project Management (PFQ)
- Appraisals and PDRs - Managing Performance
- Assertiveness Skills
- BCS Agile Foundation Certificate
- Building an Effective Team
- Business and Report Writing Skills
- Certified Information Systems Security Professional (CISSP)
- Conflict Management
- Customer Care
- Customer Care Dealing with Difficult and Aggressive Behaviour
- Delegation - The Art of Effective Delegation
- Introduction to Supervisory Management
- Leadership and Management Development Programme
- Managing Employee Mental Well-being - Managing Stress in Others
- Motivating Employees
- Negotiating and Influencing Skills
- Office 365 Introduction - 365 Small Business or Enterprises
- Presentation Skills
- Stepping up to Management
- Team Day
Excel Level 1
Course Overview
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
Course Objectives
-
- Create a spreadsheet containing data, navigate using keyboard shortcuts, add new columns and rows and save the spreadsheet.
- Create and format a spreadsheet using the main features of the formatting tools,
- Perform the following calculations on a range of numbers: addition, subtraction, multiplication and division.
- Use: sum, average, count, min and max on a range of numbers.
- Present the data in a chart and print the spreadsheet
Course Content
-
Exploring the Microsoft Excel environment
Exploring the user interface
Exploring the ribbon
Obtaining help
Customising the quick access toolbar -
Understanding Workbooks and Worksheets
Creating a new workbook
Saving a workbook
Opening a workbook already created
Navigating in Microsoft Excel
Selecting and entering data
Saving a workbook -
Entering and Editing Specific Data
Entering text and numbers
Entering numbers as text
Inputting dates and times
Editing the contents of a cell
Manipulating data
Undo and redo buttons -
Using and Understanding Cell Formats
Cell Formats options
Understanding the General Format
Date and Time Formats
Currency and Accounting Formats
Text Formats
Clearing and Resetting Formats -
Ranges
Selecting a range of cells
Selecting more than one range
Selecting an entire column and row
Highlighting the entire worksheet -
AutoFill
Using Autofill to automate data entry
Text AutoFill
Number Autofill
Date AutoFill
Custom Lists
FlashFill -
Columns and rows
Inserting and deleting cells, columns and rows
Changing column widths and row heights
Auto-fitting a column to its contents
Changing back to standard widths
Hiding and un-hiding a column or row
Searching for data in a worksheet
Freezing and unfreezing rows and columns -
Developing a workbook
Formatting worksheet tabs
Repositioning worksheets in a workbook
Inserting and deleting worksheets
Copying and pasting worksheets -
Formatting a worksheet
Modifying fonts
Merging cells
Aligning cell contents
Finding and replacing formats
Applying borders to a selection
Deleting borders around a selection of cells
Changing the alignment of the contents of a cell
Using the format painter
Clearing cells (removing formats) -
Cut, Copy and Paste
Cut, Copy and Paste
Shortcuts
Copying and Pasting to different sheets
Paste Options -
Performing calculations
Adding and Subtracting Numbers
Multiplication and Division
BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT -
Basic Sorting and Filtering Data
Sorting data
Filtering data -
Basic Charts
Chart types
Simple Chart Customisations -
Spelling and Printing
Spell checker
Print preview
Printing the spreadsheet
Printing a section of a worksheet
Clearing a print area
Prerequisites
-
- Delegates should be familiar with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.
Public Scheduled Course Dates
M.C. Sheard Packaging, Excel Level 1
C.G. Northumbria University, Microsoft Power BI Desktop
S.F. Nissan, Excel Level 2
Communication courses
We provide Communication , our Communication courses can be available as scheduled or private , meaning that you can benefit from training that fits your exact requirements. If you are unsure which Communication courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.
Private courses
Private courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.
Public Scheduled courses
Scheduled courses, easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend. If a public scheduled course is not available for Communication , we can provide private, onsite or virtual for you . One way or another, contact us to let us know how we can help or to book your .
About Communication
Effective communication skills are vital for users, as they facilitate successful interactions within and outside the organization. Good communication can lead to better team collaboration, clearer understanding between parties, and more persuasive sales and negotiation tactics.
For professionals, communication skills encompass a range of abilities, including:
- Active Listening: Paying close attention to what others are saying, asking clarifying questions, and rephrasing what the speaker has said to ensure understanding.
- Clarity and Conciseness: Getting your point across in as few words as possible without sacrificing the other elements of good communication.
- Confidence: Delivering your message assertively and with self-assurance to instill trust and convey authority.
- Empathy: Understanding and sharing the feelings of others, which can help in resolving conflicts and in customer service scenarios.
- Feedback: Being open to receiving feedback and using it constructively, as well as providing meaningful feedback to others.
- Persuasion: Influencing others to understand and accept your point of view or to convince them to take a certain action.
Whether it's through face-to-face meetings, email correspondence, or virtual conferencing, honing these skills can significantly enhance the effectiveness of business operations and relationships. Remember, communication is a two-way street, and being an effective communicator means not only conveying your own messages clearly but also understanding the messages sent by others.
Whether you're a business executive, a team leader, or an employee, our courses cover an extensive range of topics from the basics of communication to advanced techniques in public speaking, negotiation, and conflict resolution. You'll learn how to convey your message effectively, engage with your audience, and utilize communication strategies to improve your workplace relationships.
Join us for hands-on training sessions led by industry experts. Our interactive courses are tailored to meet the needs of professionals, offering practical insights and real-world applications. Elevate your communication skills and drive your business forward with our extensive communication courses.
compassion courses throughout the UK communication courses throughout the UK CompTIA courses throughout the UK