Product Description
Our Microsoft Excel On-site Training Courses can be delivered anywhere in the United Kingdom or Ireland and can be customized to match our clients’ specific requirements. Our Introduction to Excel assumes no prior knowledge of the program and allows users to grasp key spreadsheet concepts as well as getting to grips with the powerful time-saving features unique to Excel.
Basics
Excel Ribbon overview, Ribbon Tabs, Context Tabs, Data entry , Block selection , Copying data, Moving data, Inserting cells, rows and columns, Deleting cells, rows and columns, Resizing rows and columns, Using the AutoFit facility, Undoing and redoing operations, Spell checking, Printing a spreadsheet
Formatting
Setting alignment, Using cell shading, Adding borders to cells, Using Autoformat, Number and date Formats, Creating styles , Applying styles, Modifying Styles , Using conditional formatting
Formulas
Formulas , How formulas work, About cell references, About Excel ranges, Overview of functions , Using the AutoSum facility, Using the formula palette, Using conditionals, Statistical functions, Financial functions, Creating external references
Charts
Creating a chart, Setting chart options, Editing chart elements , Editing chart data, Adding logos and graphics, Printing charts
Productivity
Creating reports, Setting print options, Creating custom lists, AutoCorrect , Password protecting documents, Protecting worksheets