Course details
This course is designed to follow-on from MS Excel Level Two (Intermediate). Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate topics, it is now time to build on that knowledge. A large proportion of the course is dedicated to using the Database Features in MS Excel this is a very powerful side to Excel that not many people utilise to its fullest potential. Useful functions such as IF and Lookups are covered in addition to automating tasks using Macros etc. It is highly recommended that you firstly attend Level Two (Intermediate) prior to attending Level Three as some of the topics covered in Level Two are essential for successful completion of Level Three.
Named Ranges
- Creating a named range
- Redefining a named range
- Users for named ranges
Database Features
- Sorting Records
- Using AutoFilter
- Advanced Filtering
- Creating an Automatic Outline
- Subtotalling lists
- Database Functions
Outlining and Grouping Data
- Using Grouping and Outlines
- Expanding/Collapsing an outline
- Removing an outline
Working with Pivot Tables
- Pivot Table Concepts
- Setting up the Pivot Table Layout
- Refreshing Pivot Table Data
- Using PivotTable AutoFormat
- Filtering PivotTable Data
- Calculations in a Pivot Table
More on Functions
- Using the COUNT Functions
- Using LOOKUP Functions
- Using the IF Function
- Using IS Functions
- Using the SUMIF Function / COUNTIF
- Creating Formulae with Nested Functions
- PMT Function
- Using Goal Seek
- Scenario Manager
Using Auditing Tools
- Using the Auditing Toolbar
- Tracing Precedents & Dependents
Consolidating Data
- Opening & Closing Multiple Workbooks
- Creating / Saving a Workspace
- Consolidating Data
Macros
- Recording & Running Macros
- Editing a Macro
- Assigning a Macro to a Tool
- Resetting / Deleting Toolbars
Protecting Worksheets and Workbooks
- Protecting Workbook Access
- Assigning Password Protection
- Removing a Password
- Preventing Changes to a Workbook
- Protecting Worksheets
Others
- Conditional Formatting
- Data Validation
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 Excel : Top 50 Formulas Course DriveEUR 22
EUR 149Duration: Upto 1 Hour - Microsoft Office 2016 Complete Diploma The Teachers TrainingEUR 12
EUR 243Duration: Upto 7 Hours