DATA MANAGEMENT AND ANALYSIS WITH ADVANCE EXCEL

EXCEL

PROGRAM DETAILS

Microsoft Excel 2007 is Microsoft Corp.’s latest version of its very popular business productivity application for the management and manipulation of data. Microsoft Excel is often packaged as part of Microsoft Office that includes other applications such as Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. Other desktop applications such as Microsoft Publisher and Microsoft Tools have also been added in recent releases of Office.

 Since its launch in 1985, Microsoft has released 24 Excel application versions for Windows, Macintosh, and OS/2 based computer systems. Each successive release incorporated new functions and features that allowed the user to customize how data was displayed, and to do more and better data management. However, Excel 2007 is by far the most powerful and versatile of them all!

In addition to a whole new look and feel, Excel 2007 has modified its underlying technical foundation that enables businesses to expand the uses, integration and reach of Excel. Microsoft has also has continued to improve security, plug security gaps, and address functional issues. All this has helped to make Excel a very stable and reliable business application.

With the right training and understanding of Excel 2007, businesses and individual users can unlock the world of opportunities that this powerful business application offers. This Excel 2007 Training Course does just that and more! It assumes users have no prior experience with Excel or other spreadsheet programs. We start with the basics, and move up from there. So join us today, and lets learn the fundamentals of Excel 2007!

We reviewed Excel’s 500 functions, ruthlessly stripping out all non-essentials, to arrive at our highly refined syllabus. Our diagnostic tool then focuses your time on those parts of that syllabus that will be most valuable to you. Our regularly updated course consists of a carefully balanced combination of text, illustrations AND videos.

Program Contents :
SECTION 1- GETTING ACQUAINTED WITH EXCEL
1.1- About Excel
1.2- The Excel Environment
1.3- The Title Bar
1.4- The Ribbon
1.5- Scroll Bars
1.6- The Microsoft Office Button
1.7- The Quick Access Toolbar
1.8- The Formula Bar
1.9- The Workbook Window
1.10- The Status Bar
1.11- The Workbook View Buttons
1.12- The Zoom Slider
1.13- The Mini Toolbar
1.14- Keyboard Shortcuts

SECTION 2- CREATING BASIC WORKBOOKS
2.1- Creating New Workbooks
2.2- Saving Workbooks
2.3- Closing Workbooks
2.4- Opening Workbooks
2.5- Selecting Cells
2.6- Entering Text into Cells
2.7- Entering Numbers into Cells
2.8- AutoComplete
2.9- Pick from Drop-Down List
2.10- Using the “Window” Command Group
2.11- Switching to Full Screen View
2.12- Renaming Workbooks
2.13- Working with Excel File Formats

SECTION 3- USING RANGES
3.1- Selecting Ranges
3.2- Ranged Data Entry
3.3- Using AutoFill

SECTION 4- CREATING FORMULAS
4.1- Ranged Formula Syntax
4.2- Simple Formula Syntax
4.3- Writing Formulas
4.4- Using AutoSum
4.5- Inserting Functions
4.6- Editing a Range
4.7- Formula AutoCorrect
4.8- AutoCalculate

SECTION 5- COPYING & PASTING FORMULAS
5.1- Relative References and Absolute References
5.2- Cutting, Copying & Pasting Data
5.3- AutoFilling Cells
5.4- The Undo Button
5.5- The Redo Button

SECTION 6- COLUMNS & ROWS
6.1- Selecting Columns and Rows
6.2- Adjusting Column Width and Row Height
6.3- Hiding and Unhiding Columns and Rows
6.4- Inserting and Deleting Columns and Rows

SECTION 7- FORMATTING WORKSHEETS
7.1- Formatting Cells
7.2- The Format Cells Dialog Box
7.3- Clearing All Formatting from Cells
7.4- Copying All Formatting from Cells to Another Area

SECTION 8- WORKSHEET TOOLS
8.1- Moving between Worksheets
8.2- Selecting Multiple Worksheets
8.3- Inserting and Deleting Worksheets
8.4- Renaming Worksheets
8.5- Coloring Worksheet Tabs
8.6- Copying or Moving Worksheets

SECTION 9- SETTING WORKSHEET LAYOUT
9.1- Using Page Break Preview
9.2- Using the Page Layout View
9.3- The Page Setup Dialog Box

SECTION 10- PRINTING WORKSHEETS
10.1- Using Print Preview
10.2- Printing Worksheets

SECTION 11- HELPING YOURSELF
11.1- Using Excel Help

SECTION 12- 3D FORMULAS
12.1- Creating 3D Formulas
12.2- 3D Formula Syntax
12.3- Creating 3D Range References

SECTION 13- NAMED RANGES
13.1- Naming Ranges
13.2- Creating Names from Headings
13.3- Moving to a Named Range
13.4- Using Named Ranges in Formulas
13.5- Naming 3D Ranges
13.6- Managing Named Ranges

SECTION 14- CONDITIONAL FORMATTING AND CELL STYLES
14.1- Conditional Formatting
14.2- Finding Cells with Conditional Formatting
14.3- Clearing Conditional Formatting
14.4- Using Table and Cell Styles

SECTION 15- PASTE SPECIAL
15.1- Using Paste Special
15.2- Pasting Linked Formulas

SECTION 16- SHARING WORKBOOKS
16.1- Sharing Workbooks
16.2- Highlighting Changes
16.3- Reviewing Changes
16.4- Using Comments
16.5- Compare and Merge Workbooks

SECTION 17- AUDITING WORKSHEETS
17.1- Auditing Worksheets
17.2- Tracing Precedent and Dependent Cells
17.3- Tracing Errors
17.4- Error Checking
17.5- Using the Watch Window
17.6- Cell Validation

SECTION 18- OUTLINING WORKSHEETS
18.1 Using Outlines
18.2 Applying and Removing Outlines

SECTION 19- CONSOLIDATING WORKSHEETS
19.1- Consolidating Data

SECTION 20- CREATING WORKSHEET CHARTS
20.1- Creating Charts
20.2- Selecting Charts and Chart Elements
20.3- Moving and Resizing Charts
20.4- Changing the Chart Type
20.5- Changing the Data Range
20.6- Switching Column and Row Data
20.7- Choosing a Chart Layout
20.8- Choosing a Chart Style
20.9- Printing Charts
20.10- Deleting Charts

SECTION 21- EDITING AND FORMATTING CHARTS
21.1- Formatting Chart Objects
21.2- Inserting Objects into a Chart
21.3- Changing Chart Labels
21.4- Changing Axes Display
21.5- Changing the Chart Background
21.6- Applying Chart Analysis Lines
21.7- Naming Charts
21.8- Applying Shape Styles to Chart Elements
21.9- Applying WordArt Styles to Chart Elements
21.10- Saving Custom Chart Templates

SECTION 22- PIVOTTABLES
22.1- Creating PivotTables and PivotCharts
22.2- Manipulating a PivotTable
22.3- Changing Calculated Value Fields
22.4- Applying PivotTable Styles
22.5- Creating a PivotChart
22.6- Setting PivotTable Options
22.7- Sorting and Filtering PivotTable Data

SECTION 23- TABLES
23.1- Creating a Table
23.2- Adding and Editing Records
23.3- Inserting Records and Fields
23.4- Deleting Records and Fields

SECTION 24- SORTING DATA
24.1- Sorting Data
24.2- Custom Sort Orders

SECTION 25- FILTERING DATA
25.1- Using AutoFilters
25.2- Using the Top 10 AutoFilter
25.3- Applying a Custom AutoFilter
25.4- Creating Advanced Filters
25.5- Applying Multiple Criteria
25.6- Using Complex Criteria
25.7- Copying Filtered Results to a New Location
25.8- Using Database Functions

SECTION 26- USING WHAT-IF ANALYSIS
26.1- Using Data Tables
26.2- Using Scenario Manager
26.3- Using Goal Seek

SECTION 27- TABLE-RELATED FUNCTIONS
27.1- The Hlookup and Vlookup Functions
27.2- Using the IF, AND, and OR Functions

SECTION 28- SECURITY FEATURES
28.1- Unlocking Cells
28.2- Worksheet Protection
28.3- Workbook Protection
28.4- Password Protecting Excel Files

SECTION 29- MAKING MACROS
29.1- Recording Macros
29.2- Running and Deleting Recorded Macros
29.3- The Personal Macro Workbook