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
- BRCGS Global Standard for Food Safety Issue 9 Lead Auditor
- Internal Food Safety Auditor
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
Safe training in Salford
We provide Safe in Salford , our Safe training can be available as scheduled or private , meaning that you can benefit from training that fits your exact requirements. If you are unsure which Safe training 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 training in Salford
Private training 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 training
Scheduled training, 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 Safe in Salford , we can provide private, onsite or virtual for you in Salford . One way or another, contact us to let us know how we can help or to book your .
About Safe
SAFe (Scaled Agile Framework) is a comprehensive operating system that integrates Lean, Agile, and DevOps practices. It helps enterprises thrive in the digital age by delivering innovative products and services faster, more predictably, and with higher quality¹. SAFe addresses critical questions such as aligning technology development with strategic business goals, improving solution quality, scaling Agile practices across value streams, fostering collaboration, and creating a culture of continuous learning. It's been adopted by over 20,000 enterprises worldwide, making it the world's leading framework for Business Agility.
Our experienced instructors bring a wealth of industry knowledge and hands-on experience to the classroom, providing you with valuable insights and guidance throughout your learning journey. You will have the opportunity to engage in interactive sessions, participate in group discussions, and work on case studies that mirror the complexities of agile methodologies. By the end of the course, you will have a solid understanding of SAFe principles and be ready to implement them in your organization.
Join us in Salford and take the first step towards becoming proficient in SAFe. Our state-of-the-art training facilities and supportive learning environment will ensure that you have a rewarding and enriching experience. We look forward to welcoming you to our SAFe training and helping you achieve your career goals.
About Salford
Salford, a city in Greater Manchester, is famous for its MediaCityUK, a hub for media organizations, and the Salford Quays. The city is well-connected by Salford Crescent railway station, with services to Manchester and Bolton. The Lowry arts center and the nearby Imperial War Museum North offer cultural and historical experiences.
Salford, a city of intriguing contrasts, offers a blend of historical, cultural, and modern attractions. From the architectural splendor of Salford Cathedral to the contemporary art exhibitions at the Salford Museum and Art Gallery, there's something for every visitor. The city's industrial past is showcased at the Salford Quays, where once bustling docks have been transformed into a vibrant cultural destination, featuring the Lowry Theatre and the Imperial War Museum North.
For nature enthusiasts, the Worsley Woods provide a serene escape, while sports fans can catch a game at the AJ Bell Stadium, home to the Salford Red Devils rugby team. The MediaCityUK complex is a must-visit for those interested in television and radio, offering tours of the BBC and ITV studios.
Transportation in Salford is convenient, with options ranging from the well-connected Salford Crescent rail station to frequent bus services along the A6 Broad Street. For those arriving by car, Technology House offers a barrier-controlled car park with an exit token system provided by the reception. Whether you're exploring its rich heritage or enjoying its modern amenities, Salford is a city that welcomes all with open arms and plenty to discover.
Welcome to Salford, a city that seamlessly combines its rich industrial heritage with modern vibrancy. As you visit for your training course, you'll find a wealth of tourist attractions to explore in your downtime. Marvel at the Salford Cathedral's historical architecture or immerse yourself in the arts at the Salford Museum and Art Gallery. Salford Quays, the reimagined docklands, now host the Lowry Theatre and the striking Imperial War Museum North, offering cultural experiences alongside stunning waterfront views.
Nature lovers can unwind in the tranquility of Worsley Woods, while sports enthusiasts might catch a game at the AJ Bell Stadium. MediaCityUK invites those curious about television and radio to tour the BBC and ITV studios, providing a behind-the-scenes glimpse into broadcasting.
Navigating Salford is a breeze, with Salford Crescent rail station offering extensive connections, and frequent bus services running along the A6 Broad Street. For those driving, Technology House provides a barrier-controlled car park, ensuring a hassle-free visit.
Salford's blend of historical charm and contemporary flair makes it an ideal backdrop for learning and leisure. Enjoy your training and the opportunity to discover all that Salford has to offer.
Please note that the specific transport details and attractions are based on general information and may have evolved since our last update. It's always best to check the latest details before planning your visit.
Payroll Training in Salford Carbon Footprint Training in Salford SAFe Training in Alford Payroll training throughout the UK Carbon Footprint Training in Alford Carbon Footprint Training in Alfreton SAFe training throughout the UK SAFe Training in Alfreton Payroll Training in Alford SAFe Training in Salford Carbon Footprint training throughout the UK