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.
-
- 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.
-
- 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
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
-
Exploring the Microsoft Excel environmentExploring the user interface
Exploring the ribbon
Obtaining help
Customising the quick access toolbar -
Understanding Workbooks and WorksheetsCreating 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 DataEntering 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 FormatsCell Formats options
Understanding the General Format
Date and Time Formats
Currency and Accounting Formats
Text Formats
Clearing and Resetting Formats
-
RangesSelecting a range of cells
Selecting more than one range
Selecting an entire column and row
Highlighting the entire worksheet -
AutoFillUsing Autofill to automate data entry
Text AutoFill
Number Autofill
Date AutoFill
Custom Lists
FlashFill -
Columns and rowsInserting 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 workbookFormatting worksheet tabs
Repositioning worksheets in a workbook
Inserting and deleting worksheets
Copying and pasting worksheets -
Formatting a worksheetModifying 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 PasteCut, Copy and Paste
Shortcuts
Copying and Pasting to different sheets
Paste Options -
Performing calculationsAdding and Subtracting Numbers
Multiplication and Division
BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT
-
Basic Sorting and Filtering DataSorting data
Filtering data -
Basic ChartsChart types
Simple Chart Customisations
-
Spelling and PrintingSpell checker
Print preview
Printing the spreadsheet
Printing a section of a worksheet
Clearing a print area
M.C. Sheard Packaging, Excel Level 1 - Essentials
M.D. Public course, Excel Level 1 - Essentials
M.D. Public course, Excel Level 1 - Essentials
M.W. CMR, Excel Level 1 - Essentials
J.C. , Excel Level 1 - Essentials
J. Lincolnshire Housing Partnership, Excel Level 1 - Essentials
K.W. James Jones and Sons, Excel Level 1 - Essentials
L.G. James Jones and Sons Ltd, Excel Level 1 - Essentials
L.G. James Jones and Sons Ltd, Excel Level 1 - Essentials
J.R. James Jones and Sons Ltd, Excel Level 1 - Essentials
D.B. NHS South Tyneside and Sunderland, Excel Level 1 - Essentials
S.B. , Excel Level 1 - Essentials
N.C. Cembre Ltd, Excel Level 1 - Essentials
J.B. Nexus, Excel Level 1 - Essentials
N. Schlegel, Excel Level 1 - Essentials
L.H. SchlegelGiesse, Excel Level 1 - Essentials
H.M. , Excel Level 1 - Essentials
A.S. Hitachi CMUK, Excel Level 1 - Essentials
W.F. , Excel Level 1 - Essentials
L.M. Blue Phoenix, Excel Level 1 - Essentials
C.M. Nexus, Excel Level 1 - Essentials
L.D. , Excel Level 1 - Essentials
L.H. Hitachi, Excel Level 1 - Essentials
S.S.G. Lighthouse, Excel Level 1 - Essentials
H.S. Dartmouth Global Trading Co Ltd, Excel Level 1 - Essentials
G.H. universal wolf, Excel Level 1 - Essentials
J. LHP, Excel Level 1 - Essentials
D.S. LHP, Excel Level 1 - Essentials
S. , Excel Level 1 - Essentials
R.B. LYHA, Excel Level 1 - Essentials
S.D. Bang & Olfsen, Excel Level 1 - Essentials
H.L. Hoults Ltd, Excel Level 1 - Essentials
H.A. Relate, Excel Level 1 - Essentials
G.H. Capstone Foster Care, Excel Level 1 - Essentials
G.H. Capstone Foster Care, Excel Level 1 - Essentials
J.B. Tharsus, Excel Level 1 - Essentials
H.P. Labour Party, Excel Level 1 - Essentials
E.J. AESICA Pharmaceuticals, Excel Level 1 - Essentials
R.S. ENGIE Fabricom, Excel Level 1 - Essentials
H.B. ENGIE Fabricom, Excel Level 1 - Essentials
G.S. Egger (UK) Ltd, Excel Level 1 - Essentials
S.K. Egger (UK) Ltd, Excel Level 1 - Essentials
B.S. Egger (UK) Ltd, Excel Level 1 - Essentials
N.A. Egger (UK) Ltd, Excel Level 1 - Essentials
D.G. Stobart rail, Excel Level 1 - Essentials
M.W. Litterboss Ground Control, Excel Level 1 - Essentials
M.Q. Nissan, Excel Level 1 - Essentials
W.M. Gestamp UK Ltd, Excel Level 1 - Essentials
D.G. SPIE UK, Excel Level 1 - Essentials
M.N. MAN Diesel & Turbo UK Ltd, Excel Level 1 - Essentials
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!PrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.BespokeBespokeBespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/28/2024 1:24:40 PM