Course details
This course covers aspects of Excel beyond building basic workbooks. It deals with workbook automation, productivity features, data analysis tools and automating workbook operations using macros.
Course Outline Summary
Section One: Working with Data
- Outlining and Grouping Data
- Exploring Scenarios
- Using Data Analysis Tools
- Using Solver
- Using Hyperlinks
Section Two: Pivoting Data
- Getting Started with PivotTables
- Working with PivotTable Data
- Formatting a PivotTable
- Advanced PivotTable Tasks
- Using the PivotChart Tools Tabs
Section Three: Advanced Excel Tasks
- Using Advanced Functions
- Using the VLOOKUP Function
- Using Custom AutoFill Lists
- Linking, Consolidating, and Combining Data
Section Four: Macros
- Recording a Macro
- Assigning a Macro to the QAT
- Viewing a Macro
- Deleting a Macro
Course Location
About Positive2Work Skillnet
The Positive2Work Skillnet is made up of small, medium & large companies from all sectors of the Irish Economy. The member companies of Positive2Work Skillnet have come together to explore how the intervention of effective strategies, supported by training solutions and people development, can positively impact on the quality of employees working lives and the competitive environment within which network member companies operate. The aim of the project is to create a Positive2Work environment for all employees within the member companies of the Skillnet.
To date the Skillnet has delivered training that support the areas of:
- Building Resilience / Stress Management
- Conflict Management / Building Constructive Relations
- Change Management / People Management
While also working directly with member companies to deliver training that both incorporates the Positive2Work objective and meets their individual needs.
Positive2Work has approved funding until the end of 2013.
Positive2Work Skillnet provides subsidised training to member companies and offers free training for job-seekers. Members can also influence what courses are provided by the network.
See all Positive2Work Skillnet courses Are you from Positive2Work Skillnet ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Excel Data Analysis Academy for Health & FitnessEUR 12
EUR 607Duration: Upto 2 Hours - Microsoft Office 2016 Excel Beginners John AcademyEUR 57
EUR 1,233Duration: Upto 4 Hours
