Overview
This 1 day course covers the features to manage data, worksheets, and workbooks. It includes tasks such as using large worksheets; working with multiple worksheets, and managing data, worksheets and files. The student will also learn how to use ranges, other functions, and filter data in a list. This course covers working with charts, graphics and files. It includes tasks to create and format charts; draw an object; use additional effects and objects; and use AutoShapes and diagrams. The student will also learn how to use HTML files and work with comments.
Learning objectives
With excel being used so regularly within modern businesses for multiple purposes, this course will be of interest to delegates of all fields and levels who use excel on a regular basis and wish to expand their knowledge on the programme.
Course outline
-
Using Large Worksheets
-
Managing Worksheets
-
Managing Data
-
Using Formulas
-
Using AutoFilter
-
Managing Files
-
Using Name Ranges
-
Creating & Formatting Charts
-
Drawing an Object
-
Using Additional Objects & Effects
-
Using AutoShapes & Diagrams
-
Using HTML Files
Trainer's profile
The instructor for this Excel for engineers course will be John McGrath from Productive Solutions Ltd.
John has over 12 years training experience specialising in Microsoft applications has delivered in excess of 3,000 training courses. Prior to this, John worked as university Project Management.
John's aim is to teach you more about Excel in a day than you might learn in years with software documentation or any self-help tutorial. With John's guidance you'll discover how to use Excel as it was meant to be used: as a problem-solver, a time-saver and a streamlined means to an impressive end.