Details
Who Should Do This Course?
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
Students should have already completed Excel 2010 Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.
About The Course:
This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data..
Learning Outcomes:
Upon successful completion of this course, students will be able to:
1) use the fill operations available to fill a data series 2)understand and use formula cell referencing to createmore complex formulas 3) use a range of logical functions 4) apply conditional formatting to ranges in a worksheet 5)create and use labels in a workbook
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
Students should have already completed Excel 2010 Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.
About The Course:
This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data..
Learning Outcomes:
Upon successful completion of this course, students will be able to:
1) use the fill operations available to fill a data series 2)understand and use formula cell referencing to createmore complex formulas 3) use a range of logical functions 4) apply conditional formatting to ranges in a worksheet 5)create and use labels in a workbook
Outline
Advanced Excel Course Outline
1) work with various elements of a worksheet
2) use a range of techniques to work with worksheets
3)use a range of find and replace techniques
4) apply a variety of page setup techniques
5)sort data in a list in a worksheet
6) filter data in a table
7) create effective charts in Microsoft Excel
8) use a range of techniques to enhance charts
9) apply formatting techniques to text on charts
1) work with various elements of a worksheet
2) use a range of techniques to work with worksheets
3)use a range of find and replace techniques
4) apply a variety of page setup techniques
5)sort data in a list in a worksheet
6) filter data in a table
7) create effective charts in Microsoft Excel
8) use a range of techniques to enhance charts
9) apply formatting techniques to text on charts
Special Offer
Avail Special Discounts if you come in a batch of 4+ trainees/participants/attendees
Reviews
Be the first to write a review about this course.
Write a Review
ABOUT OUR COMPANY
At Evanson Training, we believe that our progress is born from our clients’ success. To accomplish this mission, we employ cutting-edge research, modern and rigorous course materials and expert professional trainers who make learning an enjoyable, rewarding process.
We offer a diverse and ever-expanding range of courses and subjects, approved by the KHDA; ranging from introductory courses through to certificates and professional qualifications.
In today’s dynamic and hyper competitive business environment, companies need to focus more than ever on learning and innovation to survive and thrive. After all, learning is the key to a successful future.
Let us help you tackle these challenges.
At Evanson Training, we believe that our progress is born from our clients’ success. To accomplish this mission, we employ cutting-edge research, modern and rigorous course materials and expert professional trainers who make learning an enjoyable, rewarding process.
We offer a diverse and ever-expanding range of courses and subjects, approved by the KHDA; ranging from introductory courses through to certificates and professional qualifications.
In today’s dynamic and hyper competitive business environment, companies need to focus more than ever on learning and innovation to survive and thrive. After all, learning is the key to a successful future.
Let us help you tackle these challenges.
Related Courses
Rolla Academy
PAC Dubai
Vidhyaarun360
MAKHARIA INSTITUTE
