Course details
This course demonstrates how to work more efficiently with workbooks, enhance the appearance of data and worksheets, and use the tables and filtering features to manage and analyse data.
Assumed Knowledge
It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction course or have obtained comparable knowledge from the workplace.
Section One: Advanced File Tasks
- Using Windows Explorer within Excel
- Saving your Files
- Using File Management Tools
Section Two: Working with Functions and Formulas
- Using Formulas in Excel
- Exploring Excel Functions
- Using Functions in Excel
- Working with Names and Ranges
- Working with Array Formulas
Section Three: Managing Tables
- Working with Tables
- Working with Records and Fields
- Working with Tables and Filters
- Using Excel as a Database
Section Four: Adding the Finishing Touches
- Research Tools
- Using Themes
- Adding Text Boxes
- Inserting Pictures and ClipArt
- Using Screenshot tool
Section Five: Showing Data as a Graphic
- Inserting SmartArt
- Formatting SmartArt
- Adding Symbols, Equations, and Shapes
- Adding Sparklines
- Editing Sparklines
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
- Microsoft Office 2016 Excel for Beginners Adams AcademyEUR 49
EUR 494Duration: Upto 4 Hours - Advanced Microsoft Data Analysis Course GateEUR 12
EUR 261Duration: Upto 21 Hours
