- الموقع: المنطقة الدبلوماسية - المنامة
- مدة الدورة التدريبية: 6 شهور
- مواعيد الدورة: استفسار
تفاصيل الدورة
The Basics
- Creating a New Workbook
- Navigating in Excel
- Moving the Cell Pointer
- Using Excel Menus
- Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
- Entering Values in a Worksheet and Selecting a Cell Range
- Previewing and Printing a Worksheet
- Getting Help from the Office Assistant
- Saving a Workbook & Re-opening a saved workbook
Formatting a Worksheet
- Creating Headers, Footers, and Page Numbers
- Adjusting Page Margins and Orientation
- Adding Print Titles and Gridlines, rows to repeat at top of each page
- Formatting Fonts & Values
- Adjusting Row Height and Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and Patterns
- Using the Format Painter
- Using AutoFormat
- Merging Cells
Managing your workbooks
- Switching Between Sheets in a Workbook
- Inserting and Deleting Worksheets
- Renaming and Moving Worksheets
- Protecting a Workbook
- Hiding Columns, Rows and Sheets
- Splitting and Freezing a Window
- Inserting Page Breaks
- Advanced Printing Options
Editing a Workbook
- Entering Date Values and using AutoComplete
- Editing, Clearing, and Replacing Cell Contents
- Cutting, Copying, and Pasting Cells
- Moving and Copying Cells with Drag and Drop
- Collecting and Pasting Multiple Items
- Using the Paste Special Command
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
- Checking Your Spelling
- Finding and Replacing Information
- Inserting Cell Comments
Formulas
- Creating a basic Formula
- Calculating Value Totals with AutoSum
- Editing & Copying Formulas
- Fixing Errors in Your Formulas
- Formulas with Several Operators and Cell Ranges
Working with the Forms Menu
- Sorting, Subtotaling & Filtering Data
- Copy & Paste Filtered Records
- Using Data Validation
Creating & Working with Charts
- Creating a Chart
- Moving and Resizing a Chart
- Formatting and Editing Objects in a Chart
- Changing a Chart’s Source Data
- Changing a Chart Type and Working with Pie Charts
- Adding Titles, Gridlines, and a Data Table
- Formatting a Data Series and Chart Axis
- Annotating a Chart
- Working with 3-D Charts
- Selecting and Saving a Custom Chart
- Using Fill Effects
- Mapping Data
- Modifying a Map
Data Analysis & Pivot Tables
- Creating a PivotTable
- Specifying the Data a PivotTable Analyzes
- Changing a PivotTable’s Calculation
- Selecting What Appears in a PivotTable
- Grouping Dates in a PivotTable
- Updating a PivotTable
- Formatting and Charting a PivotTable
Automating Tasks with Macros
- Recording a Macro
- Playing a Macro and Assigning a Macro a Shortcut Key
- Adding a Macro to a Toolbar
Working with Other Programs
- Inserting an Excel Worksheet into a Word Document
- Modifying an Inserted Excel Worksheet
- Inserting a Linked Excel Chart in a Word Document
- Inserting a Graphic into a Worksheet
Course Syllabus
The Basics:
- Creating a New Workbook: Learn how to start a new workbook from scratch and navigate the Excel interface.
- Navigating in Excel: Explore moving the cell pointer and navigating through worksheets.
- Using Excel Menus and Toolbars: Customize toolbars by hiding, displaying, and moving them for an optimized workspace.
- Entering Values and Selecting Cell Ranges: Input data into cells and select multiple cells effectively.
- Previewing and Printing Worksheets: Understand print setup and previewing options before printing.
- Getting Help from the Office Assistant: Use built-in help resources to resolve Excel-related queries.
- Saving and Re-Opening Workbooks: Save your progress and access previously saved workbooks.
Formatting a Worksheet:
- Headers, Footers, and Page Numbers: Add essential document details to enhance professionalism.
- Adjusting Page Margins and Orientation: Customize your page layout settings for printing.
- Print Titles and Gridlines: Set rows to repeat at the top of each printed page for easy reference.
- Formatting Fonts and Values: Change font style, size, and value display formats.
- Row Height and Column Width Adjustments: Modify rows and columns for a polished appearance.
- Changing Cell Alignment: Align cell content for better readability.
- Adding Borders, Colors, and Patterns: Enhance the look of your worksheet with visual formatting.
- Using Format Painter and AutoFormat: Quickly copy formatting and apply predefined styles.
- Merging Cells: Combine multiple cells to create a unified appearance.
Managing Your Workbooks:
- Switching Between Sheets: Navigate across multiple worksheets seamlessly.
- Inserting, Deleting, and Renaming Worksheets: Manage sheets within your workbook.
- Protecting a Workbook: Set up workbook protection to prevent unwanted changes.
- Hiding Columns, Rows, and Sheets: Simplify your view by hiding unnecessary data.
- Splitting and Freezing Panes: Keep important data in view while scrolling.
- Inserting Page Breaks and Advanced Printing Options: Manage how your data appears on printed pages.
Editing a Workbook:
- Entering Date Values and Using AutoComplete: Speed up data entry using date shortcuts.
- Editing, Clearing, and Replacing Cell Contents: Modify data quickly and efficiently.
- Cutting, Copying, and Pasting Cells: Master data movement within the worksheet.
- Using Drag and Drop for Moving Cells: An intuitive approach to reposition data.
- Paste Special Options: Perform advanced paste operations for data manipulation.
- Inserting and Deleting Cells, Rows, and Columns: Adjust worksheet structure as needed.
- Spell Checking and Replacing Information: Ensure data accuracy with built-in tools.
- Adding Cell Comments: Annotate cells with helpful notes.
Formulas:
- Creating Basic Formulas: Perform calculations using cell references.
- Calculating Totals with AutoSum: Quickly sum data in your worksheet.
- Editing and Copying Formulas: Adjust formulas as needed and replicate them.
- Fixing Formula Errors: Troubleshoot common issues in your calculations.
- Formulas with Multiple Operators and Ranges: Create complex calculations using various functions.
Working with the Forms Menu:
- Sorting, Subtotaling, and Filtering Data: Organize data for better analysis.
- Copying and Pasting Filtered Records: Extract and manipulate specific data sets.
- Using Data Validation: Ensure data integrity by setting criteria for entries.
Creating and Working with Charts:
- Creating and Formatting Charts: Visualize your data with different chart types.
- Moving, Resizing, and Editing Charts: Customize chart layout and design.
- Changing Chart Types and Working with Pie Charts: Display data with various chart formats.
- Adding Titles, Gridlines, and Data Tables: Improve chart readability.
- Formatting Data Series and Chart Axis: Enhance the appearance of your charts.
- Annotating Charts: Add notes or labels to explain data trends.
- Working with 3-D Charts and Customizing Fill Effects: Make charts visually appealing with 3D effects.
- Modifying a Map: Customize mapped data for geographic analysis.
Data Analysis and PivotTables:
- Creating and Modifying PivotTables: Summarize and analyze large data sets.
- PivotTable Calculations and Selections: Tailor calculations and displayed data.
- Grouping Dates and Updating PivotTables: Manage time-based data efficiently.
- Formatting and Charting PivotTables: Present PivotTable data visually.
Automating Tasks with Macros:
- Recording and Playing Macros: Automate repetitive tasks to save time.
- Assigning Macros to Shortcut Keys: Trigger macros with ease.
- Adding Macros to Toolbars: Streamline your workflow with custom macro buttons.
Working with Other Programs:
- Inserting Excel Data into Microsoft Word: Integrate Excel data within Word documents.
- Modifying Inserted Worksheets and Charts: Update data directly within Word.
- Linking Excel Charts to Word: Maintain a dynamic link between Excel and Word.
- Inserting Graphics into a Worksheet: Enhance worksheets with visual elements.
المتطلبات
Basic Computer Knowledge: Familiarity with general computer operations.Keyboard Skills: Ability to perform basic typing tasks.
نبذة عن معهد Marvel Management Training Institute
استفسر عن هذه الدورة
يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.