EXCEL Tutorial
Click Image To Visit Site
This user friendly interactive course lets you study at your own pace as you cover the functions and tools of the Excel, giving you software training that will develop both your expertise and your confidence. Finally here is a way to become fluent in Microsoft Excel, a spreadsheet application that is a financial industry standard worldwide.
EXCEL COURSE Chapter 1 Covers Excel structure and ways to open and save the worksheet 1. Starting EXCEL 2. What is a spreadsheet? 3. Workbook Saving 4. Save as dialog box 5. Workbook opening 6. Open dialog box 7. New workbook opening 8. Workbook closing 9. Handling several workbooks 10. Password Chapter 2 Chapter covers data types, cells selecting, editing and marking 1. Data Types 2. Rows, Columns and cells Selecting 3. Entering data 4. Data Editing 5. Clearing Cells content 6. Cells deleting 7. Rows, Columns and cells inserting 8. Undo and Redo buttons 9. Copy Data 10. Paste Special Chapter 3 Covers ways to determine the look and design of the worksheet 1. Setting columns width 2. Setting row height 3. What is a font? 4. Underling Text 5. Bold Text 6. Italic Text 7. Text alignment 8. Worksheets navigation 9. Naming a worksheet 10. Add / delete a worksheet Chapter 4 Covers cells formations and working with worksheets 1. Moving or copying a worksheet 2. Format cells 3. Add border and color 4. Hide and Unhide 5. Freeze Panels 6. Cell rename 7. Worksheet direction Chapter 5 Covers the basic of formulas and functions 1. What is a formula? 2. Recognize a formula in a cell 3. Entering a formula 4. Relative address 5. Copy formula to cell region 6. Fix address 7. What is a function 8. SUM function 9. Useful functions 10. Function Wizard Chapter 6 Covers diagrams, graphs and pivot table topics 1. What is diagram? 2. Creating a diagram 1 3. Creating a diagram 2 4. Editing a diagram 5. Diagram format 6. Diagram Printing 7. Delete / Copy Diagram 8. Pivot Table Chapter 7 Covers preview and print subjects 1. Printing steps 2. Page setup 3. Margin setup 4. Header and Footer setup 5. Sheet setup 6. Print Preview 7. Print 8. What to print Chapter 8 Covers Macros and Lists 1. List building 2. Display AutoFilter buttons 3. Using AutoFilter buttons 4. What is a Macro 5. Macro recording 6. Running the Macro 7. Macro Editing Chapter 9 Covers exporting and importing data 1. Importing sources 2. CVS file 3. Open CVS file 4. Importing data from internet 5. Cut and Paste Chapter 10 Looking and analyzing several common applications 1. Operators 2. Actions execution Order 3. Grade spreadsheet 4. IF Condition Function 5. COUNT IF condition counting Function 6. Attendance spreadsheet 7. Time calculation
EXCEL ADVANCED COURSE CHAPTER 1 The following chapter covers the basic formulas and functions. 1. What is a formula? 2. Recognizing a formula in a cell 3. Entering a formula 4. Relative address 5. Copy formula to cell region 6. Fix address 7. What is a function? 8. SUM function 9. Useful functions 10. Function Wizard CHAPTER 2 This chapter will discuss IF and LOOKUP groups 1. IF functions 2. AND 3. OR 4. COUNTIF 5. SUMIF 6. LOOKUP 7. VLOOKUP 8. HLOOKUP CHAPTER 3 This chapter will discuss date and time groups 1. Days360 2. Now 3. Date value and Format cell 4. WorkDay 5. Networkdays 6. Today 7. WeekDay 8. Day 9. Month 10. Year CHAPTER 4 This chapter will discuss Database formulas and the Pivot table 1. Introduction 2. Dcount 3. Dmax 4. Dmin 5. Daverage 6. Dsum 7. Pivot Table ‘” Introduction 8. Pivot Table 9. Pivot Chart CHAPTER 5 This chapter will discuss MACRO and forms 1. Introduction ‘” Macro 2. Recording a Macro 3. Running a Macro 4. Introduction ‘” Forms 5. Creating Forms 6. Radio Buttons 7. Button 8. Combo Box 9. List Box 10. Check Box CHAPTER 6 This chapter will discuss the concluding project 1. The demo file 2. MACRO approval ‘” Excel 2003 3. MACRO approval ‘” Excel 2007 4. Project overview 5. Introduction 6. Approach this complicated project 7. Customer request 8. The charts in this project 9. Navigation and modification buttons 10. Evaluate deadline CHAPTER 7 In this chapter, we will discuss all of the items in the project and explain the creation process for each one 1. Introduction 2. Creating all sheets 3. Formatting the first sheet 4. Formatting the second sheet 5. Formatting the third sheet 6. Formatting the fourth sheet 7. Formatting the fifth sheet 8. Formatting the sixth sheet 9. Concluding
POWERPOINT COURSE Chapter 1 1. Starting Power Point 2. Creating a new Slide Show 3. The screen structure 4. The slide show exercise 5. Applying background 6. Filling effect 7. Adding a slide 8. Project Saving 9. Adding picture 10. Running the slide show Chapter 2 1. What is font? 2. Adding text box 3. Font type and size 4. Underling Text 5. Bold Text 6. Italic Text 7. Text alignment 8. Font color 9. Format Painter button Chapter 3 1. Pictures video and graphics 2. Word Art 3. Adding picture from Clip Art 4. Adding picture from a file 5. Size and Rotation change 6. Adding video movie 7. Recording voice 8. Sound object options Chapter 4 1. What is an object 2. AutoShape Object 3. Object types in auto shapes 4. Adding effect to object 5. Grouping Objects 6. Ungrouping objects 7. Forwarding an object 8. Backward an object Chapter 5 1. What is animation? 2. Costume animation 3. Adding effect 4. Tuning the effect 5. Order and timing 6. Effect Options 7. Entrance and exit effects 8. Motion path effect 9. Slide transition window 10. Add slide transition effect Chapter 6 1. What is navigation? 2. Hyperlink to a slide 3. Hyper link to a web site 4. Hyper link to a document 5… Read more…
