NEWCASTLE COMPUTER TRAINING

Microsoft  Excel – Intermediate (1 Day)

• Editing and Formatting Techniques

                        Finding and Replacing

                        Creating and Applying a New Style

                        Using Workbook Templates

                        Alignment Options in Format Cells Dialog Box

• Absolute Cell References
• Absolute Column and Row References
• Financial Functions
• Logical Functions (The IF Statement)
• Date/Time Functions
• Creating a Chart

                        Plotting a Basic Chart

                        Modifying and Enhancing Charts

                        Previewing and Printing Charts

                        Plotting No-Contiguous Data in a Chart

                        Plotting Pie Charts

                        Adding New Data to and Existing Chart

• Linking Worksheets within a Workbook

                        Setting up Related Worksheets

                        Navigating Between Worksheets

                        Copying Data between Worksheets

                        Editing Data on Several Worksheets

                        Using a Formula to Link Worksheet Data

                        Formatting Multiple Worksheets in One Operation

• Controlling Worksheet Display

                        Split Workbook and Freeze Panes

                        Hiding Rows and Columns

                        Adjusting Zoom Levels

• Excel and the Web

                        Accessing the Internet From Within Excel

                        Linking an Excel Workbook to a Web Page

                        Saving Excel Data as a Web Page

• Using the Paste Special Commands
• Creating and Using Drawings In Excel
• Inserting Pictures into a Worksheet
• Sending Excel Data Via Email