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
- Excel Level 1
- Excel Level 2
- Excel Level 3
- Excel Analysing and Presenting Data with Dashboards and Pivot Tables
- Excel Advanced Macros
- Excel Business Intelligence using Excel Power Tools
- Excel Formulas and Functions Indepth
- VBA Essentials using Microsoft Excel
- Microsoft Power Apps and Power Automate Essentials
- Office 365 Introduction - 365 Small Business or Enterprises
- Office 365 User Essentials
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
Excel courses in London
We provide Excel in London , our Excel 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 Excel 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 in London
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 Excel in London , we can provide private, onsite or virtual for you in London . One way or another, contact us to let us know how we can help or to book your .
About Excel
Microsoft Excel is widely recognized for its powerful spreadsheet capabilities. Many people who need to handle mathematical problems easily turn to Excel in order to lighten their work load. You can use Excel to organize, format, and calculate data with formulas, using rows and columns. Excel an help you perform complex calculations, analyze data, and view the data with charts and charts and graphs. Using Excel to visualize your data can help you really get to grips with the information you are working with. Excel is especially useful when you need to analyse and organise financial and other mathematical data and create reports.
Excel's features include pivot tables for data summarization, the ability to implement and run VBA (Visual Basic for Applications) scripts for automation, and various data analysis tools to help make informed decisions based on data trends. Whether you're managing a household budget, performing statistical analysis, or handling large datasets for business, Excel provides the functionality to assist you in managing your tasks.
For those looking to enhance their Excel skills, there are courses available that cover everything from basic functionalities to advanced data analysis. These courses are designed to help users navigate the complexities of Excel and utilize its full potential to meet their personal or professional needs. Please call us on 0191 377 8377 to discuss your Excel training.
Whether you're a business executive, a data analyst, or an operations manager, our courses cover a wide range of topics from fundamental Excel skills to advanced data visualization and automation techniques.
Our instructors are industry experts with extensive experience in using Excel. They bring a wealth of knowledge and practical insights to the classroom, ensuring that you receive the highest quality education. Through interactive sessions, group discussions, and hands-on exercises, you will gain a deeper understanding of Excel concepts and learn how to apply them in real-world scenarios.
Join us in London and take your Excel expertise to the next level. Our specialized courses are designed to provide you with the skills and confidence needed to excel in your career. We look forward to welcoming you to our courses and supporting your professional growth.
About London
London, the capital city of the United Kingdom, is a global hub of culture, politics, and commerce. The city is accessible by several major railway stations, including King's Cross and Victoria, and by international airports like Heathrow and Gatwick. The West End theatres and the South Bank cultural precinct offer endless entertainment and artistic expression.
London, the bustling capital of the United Kingdom, is a vibrant city that offers a blend of historical grandeur and modern dynamism, making it an ideal destination for business tourists. The city's extensive transport network, including the iconic red double-decker buses, the Underground (Tube), black cabs, and even Barclays Cycle Hire, ensures that navigating the city is convenient and efficient. Business travelers can easily reach key areas such as the Islington Business Design Centre, located just one stop on the Tube from Kings Cross/St. Pancras and outside the congestion charging zone, offering paid parking and proximity to Angel tube station 1.
For those looking to explore London's rich cultural heritage and attractions, the city does not disappoint. From the historic Tower of London and the majestic Buckingham Palace to the modern heights of the Shard, there is much to see and experience. Art enthusiasts can visit world-renowned institutions like the British Museum and the National Gallery, while those interested in performing arts can enjoy a show in the West End, London's equivalent to Broadway.
For a more serene experience, business tourists can stroll through the Royal Parks, such as Hyde Park or Regent's Park, offering a peaceful retreat from the city's hustle and bustle. The River Thames also provides a picturesque backdrop for walks or river cruises, presenting a unique perspective of the city's landmarks.
In summary, London caters to the business tourist with its efficient transport system, diverse attractions, and a multitude of experiences that can fit into any schedule, ensuring a visit that is both productive and enriching. Whether it's between meetings or after a training course, there's always something to discover in the historic yet ever-evolving city of London.
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.
Windows courses throughout the UK Windows Server Courses in Longridge Windows Server courses throughout the UK Excel courses throughout the UK Excel Courses in Long eaton Windows Server Courses in London Windows Server Courses in Long eaton Excel Courses in Longridge Windows Courses in Longridge Windows Courses in Long eaton Windows Courses in London Excel Courses in London