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 coursechapter 1covers excel structure and ways to open and save the worksheet1. Starting excel2. What is a spreadsheet?3. Workbook saving4. Save as dialog box5. Workbook opening6. Open dialog box7. New workbook opening8. Workbook closing9. Handling several workbooks10. Passwordchapter 2chapter covers data types, cells selecting, editing and marking1. Data types2. Rows, columns and cells selecting3. Entering data4. Data editing5. Clearing cells content6. Cells deleting7. Rows, columns and cells inserting8. Undo and redo buttons9. Copy data10. Paste specialchapter 3covers ways to determine the look and design of the worksheet1. Setting columns width2. Setting row height3. What is a font?4. Underling text5. Bold text6. Italic text7. Text alignment8. Worksheets navigation9. Naming a worksheet10. Add / delete a worksheetchapter 4covers cells formations and working with worksheets1. Moving or copying a worksheet2. Format cells3. Add border and color4. Hide and unhide5. Freeze panels6. Cell rename7. Worksheet directionchapter 5covers the basic of formulas and functions1. What is a formula?2. Recognize a formula in a cell3. Entering a formula4. Relative address5. Copy formula to cell region6. Fix address7. What is a function8. Sum function9. Useful functions10. Function wizardchapter 6covers diagrams, graphs and pivot table topics1. What is diagram?2. Creating a diagram 13. Creating a diagram 24. Editing a diagram5. Diagram format6. Diagram printing7. Delete / copy diagram8. Pivot tablechapter 7covers preview and print subjects1. Printing steps2. Page setup3. Margin setup4. Header and footer setup5. Sheet setup6. Print preview7. Print8. What to printchapter 8covers macros and lists1. List building2. Display autofilter buttons3. Using autofilter buttons4. What is a macro5. Macro recording6. Running the macro7. Macro editingchapter 9covers exporting and importing data1. Importing sources2. Cvs file3. Open cvs file4. Importing data from internet5. Cut and pastechapter 10looking and analyzing several common applications1. Operators2. Actions execution order3. Grade spreadsheet4. If condition function5. Count if condition counting function6. Attendance spreadsheet7. Time calculation
Read More detail
Tidak ada komentar:
Posting Komentar