Instructor Led Worksheets Training Classes

Dive Into Microsoft Excel Spreadsheets and Workbooks Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze more...

Dive Into Microsoft Excel Worksheet Intermediate Editing a Spreadsheet Tips, Tricks and Shortcuts Enter and format your data, and write formulas Develop Formulas using Built-in Functions Use charts and graphs to predict trends and understand relationships Create a template to speed up your work Using the AutoFill and Custom Fill Create and Edit Forms Consolidate data from several worksheets into one Find and organize information by filtering, more...

Excel training courses (1 day) Introduction in Bristol, Bracknell or Solihull ...el file types Excel environment Toolbars Workbooks and worksheets Creating and opening workbooks Working with workbooks and worksheets Working with cells Navigating within a worksheet Spreadsheet Data Entering data Using time saving features Formatting and Customising Data Selecting in Excel Formatting text Formatting numbers Formatting columns and rows Formatting cells with more...

ADVANCED MICROSOFT EXCEL For Power Users ...plex tasks Develop more user-friendly and professional worksheets, reports and workbooks Learn 3 ways to create shared workbooks, then track individual changes, read comments and combine data from multiple users Add professional polish with dialog boxes complete with text, check-boxes, radio buttons and drop-downs Discover how to easily link to important data on the Internet  more...

Microsoft Excel Intermediate ...pleting this course, you will know how to: Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets. Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarise data by using the Consolidate command. Change the View, General, and Calculation settings of Excel; and customise more...

Microsoft Excel Advanced ...os, advance custom views and pivot tables to manage large worksheets. Run and record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas and array formulas in Data Tables to determine outcomes. Prerequisites: This course is designed for students who have completed the Excel Intermediate or have equivalent knowledge. It is more...

Financial Modelling Fundamentals ...e. Day one The Excel environment * Workbooks * Worksheets * Toolbars * Menus Working with files * Creating/Opening * Naming convention * Back-ups Excel formulas * SUM * IF * AND/OR * CHOOSE * Fixed/Relative anchoring ($/F4) Formatting * Borders/Patterns * Fonts/Colours * Alignment/Number Formats More efficient keyboard more...

Excel Training - Chicago ...w To Select Non-Adjacent Ranges How To Select Multiple Worksheets Entering Data into Worksheet How To Enter Text (Label) Into A Cell How To Edit Cell Content How To Edit Contents Using Formula Bar How To Replace Contents In A Cell How To Delete Contents In A Cell How To Undo And Redo How To Enter Number As A Value Into A Cell How To Enter Number As A Label Into more...

Microsoft Excel This course is an introduction to spreadsheets, databases and charting using Excel. Students will learn how to enter and edit data, labels, and formulas, work with functions, format cells, print worksheets, create charts, and save a workbook as a Web page. Part II course also offered, and also offered on the Mac - see Web site. more...

Word 2003 Level III ...System, students should have a basic understanding of how worksheets and presentations work. To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge: Microsoft Office Word 2003: Level 1 Microsoft Office Word 2003: Level 2 . Performance-Based Objectives Upon successful completion of this course, students will be able to: Use more...

Excel 2003 Level I ...u will create and edit basic Microsoft Office Excel 2003 worksheets and workbooks. Who Should Attend: This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic more...

Excel 2003 Level II ...l, including how to create, edit, format, and print basic worksheets. Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft Excel 2003. Students can obtain this level of skill by taking the following Element K course: Microsoft Excel 2003: Level 1 In addition, Web browsing more...

Excel 2003 Level III ...ysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things. Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.  more...

Excel PowerUser Level ...others using shared workbooks. You will also enhance your worksheets using charts and graphic objects. Upon successful completion of this course, students will be able to: work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export Excel data into XML, import XML data into Excel, and create a Web query. collaborate with other Excel users by more...

Excel Expert Level This course is the second in a three-course series that satisfies the requirements for the Microsoft Office User Specialist (MOUS) certification. This course will expand upon the skills you learned in the Excel 2002 Level 1 course and give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas; more...

Excel Level 1 ...e you the skills to create, edit, format, and print basic worksheets and charts in Excel. You will create basic worksheets and charts. Upon successful completion of this course, students will be able to: work with cells and cell data by using a variety of moving and copying techniques. perform calculations on data by using formulas, including functions. change the appearance of more...

Excel (classroom training) in San Francisco at AcademyX ...e you the skills to create, edit, format, and print basic worksheets and charts in Excel. Course Objective: You will create basic worksheets and charts. Target Student: Persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of Microsoft Windows 98 or above operating system, and desire to gain the skills necessary to more...

Your Perfect Business a Matchless Unique Strategy to customize the elements of your business What would you have in your perfect business? Who would work with you? What would you be focused on work-wise? How would you spend your time? Where would you work? How would you work? Who would you be? Who could you become? Going for and having A Perfect Business is a valid, exciting and do-able target for each of us. This hands-on six-week class is designed to help you craft and implement more...

Assertiveness Assertivess is a two-day course that raises your level of self-confidence and self-esteem while you learn to understand the terms passive, assertive and aggressive. We discuss use worksheets and activities along with a video to understand the subject and the effect our level of assertiveness has in all areas of our lives. For those with a supervisory role we learn how assertiveness relates to more...