Introduction to Excel Full Details and Booking
Upskill yourself and/or your team in this valuable and versatile product.
Thursay 27th Jan, 1000 - 1600, £75 (was £150 - 50% discount)
Take advantage of a great 50% discount offer from BuildYourSkill and learn all the ways Excel can help your business.
Introduction to Excel
This course is designed for new or existing basic users of Microsoft Excel. You will get the opportunity explore the many features of Excel, learn basic formulas and functions, how to format data and cells and use conditional formatting to analyse information. You will find out how to sort and filter data and manage worksheets effectively.
This course content includes:
Exploring Excel
• Creating a new workbook
• The Ribbon & features of the sheet
Basic Workbook Skills
• Selecting Cells & Ranges
• Closing and Saving Workbooks
Basic Formulas
• Basic Formula – getting started
• Adding, Subtracting, Multiplying & Dividing Formulas
Basic Functions
• Autosum, Average, Count, Max, Min
Formatting Data and Cells
• Formatting Numbers & Text
• Colouring Data and Cells
• Wrapping, Shrinking & Merging Cells & Using Indents
• The Format Painter & Cell Styles / Applying borders
Basic Conditional Formatting
• Highlight Cell Rules & Top / Bottom Rules
• Data Bars / Colour Scales / Icon Sets
Copying and Moving Data
• Copy and Paste
• Cut and Paste
• Working with Data Series
• Autofill / Using the Fill Button
• Drag and Drop / Undo and Redo
• Find and Replace
Printing
• Accessing print options & Choosing what to print
• Previewing and printing
• Page Setup / Orientation / Scaling / Margins
Working with Columns and Rows
• Selecting Columns and Rows
• Changing Column width and row height / Unit Measurements
• Changing Unit Measurements
• Hiding and Unhiding & Inserting and Deleting Columns and Rows
Using Large Spreadsheets
• Changing the magnification
• Full Screen View / Freezing Panes / Splitting the Window
Working with Data
• Sorting Data
o Alphabetically (A-Z, Z-A)
o Sorting two fields
o Sorting text and dates
• Filtering & Auto Filter
Named Ranges
• Naming a range of cells & Jumping to a named range
• Using range names in formulas
• Re-defining and deleting range names
Managing Worksheets
• Naming and shading sheets
• Copying and Moving Sheets
• Adding and Deleting Worksheets
Grouping Worksheets
• Creating 3-D Formulas
Working with Percentages (%)
• Increasing by a %
• Decreasing by a %
• Difference in values as a %
BOOK HERE (by email to events@perthshirechaamber.co.uk)
News Articles
- Diesel prices reach record of over £1.80 a litre
- UK Global Screen Fund receives £21m extra funding for three-year extension
- Energy bills shake-up plans to avoid price shocks
- Land and Property Market Survey
- Here’s The Plan…to a realistic, affordable sustainable future
- Rental market at its ‘most competitive’ ever
- Support for fishing and coastal communities
- Public encouraged to take part in National Parks consultation
- Global Business Dinner to showcase the best of Scotland
- Travelknowhow Scotland are delighted to be able to extend their FREE consultancy support package throughout 2022/23
- It’s the people of Perth’s chance to have their say on BBC Debate Night
- New Digital Skills Academy - applications open
- Perth Festival of the Arts
- Auto Services Perth Ltd sponsor Perth Racecourse for the 2022 season
- Electric models drive second-hand car sales higher
- Morrisons rescues McColl's taking on all 16,000 staff
- Inflationary pressure poses huge risk to Scottish businesses
- Focus on tackling the cost of living in Queen's Speech
- New UK sanctions for Russia and Belarus
- UK Capital Allowance Regime - Consultation
- Additional £4 million for the Young Person’s Guarantee
- Latest FPMC funding round announced
- SCC Quarterly Economic Indicator Survey Q2 2022
- Azets global SME leaders growth conference - 12th May