تفاصيل الدورة
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
الموقع
نبذة عن معهد 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.
عرض الجميع دورات Positive2Work Skillnet Are you from Positive2Work Skillnet ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Office ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office 2010 Access Advanced Alpha Academy23 EUR
440 EURمدة الدورة التدريبية: Upto 3 Hours - Microsoft Outlook 2016 Inspire London College21 EUR
380 EURمدة الدورة التدريبية: Upto 1 Week
