- Location: Griffith College Dublin, South Circular Road, Dublin 8, Dublin.
- Duration: 1 Day
Course details
If you have attended or understand the concepts covered at introductory level, this course may be your next step. Its main focus is to introduce users to more functions and formulae writing and look at the interaction between Microsoft products. It covers Excel Database utility and looks at some of the easy to use Wizard features in Excel.
The course is designed to introduce new features of Excel that will enable users to be more exploitative of Excel 's features. It provides participants with some experience of Microsoft Excel the opportunity to learn new Excel features in order to achieve more complex tasks.
Viewing Worksheets
- Customising View Options
- Displaying and Customising Toolbars
- Hiding Workbooks And Worksheets
- Freezing Panes
- Grouping And Ungrouping Worksheets
More Formatting Techniques
- Using Styles
- Conditional Formatting
- Using The Format Painter
- Using Guidelines
- Hiding And Displaying Cells
More Formulas and Functions
- Using The Series Command
- Using The Insert Function Wizard
- Using The Excel Function Categories
- Correcting Formulae
- Using The Formula Error Checker
- Using The Formula Auditing Toolbar
- Using The Watch Window
Database and List Management
- Using Databases
- Creating And Editing A Database
- Sorting A Database
- Using AutoFilters
- Advanced Filters
- Working With Filtered Data
- Using Data Forms
Charts
- Chart Wizard
- Chart Toolbar
- Working With Charts
- Formatting The Chart
Drawing and Picture Objects
- Drawing Toolbar
- Working With AutoShapes
- Creating Text Boxes
- Adding Pictures
- Layering Objects
- Grouping And Ungrouping Objects
Excel and Other Applications
- Converting Files from other Applications
- Copying Data from Another Application
- Embedding and Linking Objects
- Hyperlinks
- Managing Links
About Griffith College Dublin
Griffith Halls of Residence is purpose-built student accommodation located on the grounds of Griffith College Dublin.
About Griffith Halls of Residence
Griffith Halls of Residence is purpose-built student accommodation located on the grounds of Griffith College Dublin. Just 15 minutes' walk from Dublin city centre, Griffith Halls of Residence boasts an enviable central location that makes us ideal not just for Griffith students, but also students attending any of Dublin's universities or other third level institutions.
A message from the President of Griffith College.
I am delighted to welcome you to the Griffith College website. Founded in 1974, Griffith College is Ireland’s largest independent college with 7,000 students from Ireland and across the world and their mission is to be a core of the community and a highly reputed center of education.
At Griffith College their purpose is to set students on a course of change in their lives, leading them towards achieving their optimum potential. Education should lead to a deep understanding of the subjects being studied as well as excellent exam results; the courses in Griffith College are taught with this in mind. The College delivers internationally recognized undergraduate and postgraduate degree courses in a vibrant setting. Their record of prize winning students across a wide range of disciplines is testament to the dedication and professionalism of their lecturing and administrative teams. I would encourage you to explore their website to discover the wide choice of opportunities they have to offer.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel : VLOOKUP Formula Course LineAED 90
AED 1,763Duration: Upto 2 Hours - Microsoft Powerpoint Level 3 Advanced Diploma Course LineAED 89Duration: Upto 6 Hours
