Course details
This course is suitable for anyone new to Microsoft Excel and also for those who may currently use Excel from time to time but have a limited working knowledge of the application.
Excel Basics
- Introduction
- The Excel Screen
- Creating a Workbook
- Saving a Wordbook
- Closing a Workbook
- Opening a Workbook
- Preview & Print a Workbook / Worksheet
Entering / Editing Data
- Moving around the worksheet
- Different Data Types
- Entering Data
- Editing Data
- Selecting Cells
- Deleting cell contents
Excel Essentials
- Moving and Copying Cells
- Using Cut, Copy Paste
- Drag and Drop
- Fill Handle
- Resizing Columns / Rows
- Inserting Columns / Rows
Formatting
- The Formatting Toolbar
- Changing Font Attributes
- Changing the Alignment
- Working with Background Colours & Borders
- Formatting Numbers
- Using the Format Painter
- Deleting Formats
- Using AutoFormat
Viewing and Modifying Worksheets
- Zoom Setting
- Splitting a Worksheet
- Freezing Panes
- Print Titles
- Hiding and Un-hiding Columns and Rows
- Displaying Gridlines
Formulae and Functions
- Formula Basics
- Use of brackets in multiple calculations
Functions
- Sum
- Min
- Max
- Average
- Count / Counta
- AutoSum – Expanded AutoSum
- Copying Formulae
- Relative vs. Absolute cell addressing
Custom Lists
- Lists in Excel
- Using AutoComplete
- Creating Custom Lists
- Using Custom Lists
Getting Help
- Using the Help Facility
- Printing a Help Topic
About Pharmachem Skillnet
The We_They is an ever growing network of companies that offer Pharmaceutical training courses as well as Chemical and Medical Device training in the Munster and Leinster regions.
The network was established in 2006 being formed to avail of subsidised training and networking under the Skillnets training programme, with the aim of fostering a climate of whole company development in the provision of industry specific technical training and Soft skills in companies large and small nationally, consistent with the goals of member companies.
The network operates as a business resource for organisations nationally and has been formed in response to a real need in the workplace for “best in class” training and development at a realistic and very affordable price.
The Network Manager is Ms Susan Costello. Her role is to facilitate the running of the network, organise training & networking events, source and vet trainers.
Susan is also there to work with member organisations in regard to their training needs and act as liaison between the Skillnets organisation, We_They and other networks nationally.
The network also has a steering group drawn from member companies and it is their role to ensure that the network operates in line with the contracted objectives agreed with Skillnets Ltd. The steering group work in close alignment with the Network Management in developing the strategy of the Network. Membership of the steering group is open to any members of the network and is rotated on an annual basis to ensure the network remains fresh and dynamic.
See all Pharmachem Skillnet courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office 2016 Study 365EUR 35Duration: Upto 40 Hours
- Microsoft Office Complete Diploma Alpha AcademyEUR 24
EUR 317Duration: Upto 2 Days
