Marvel Management Training Institute MS Excel 2013 Basic/Advanced Marvel Management Training Institute
السعر: استفسر لماذا لا يظهر سعر؟
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.

تفاصيل الدورة

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
Content / Syllabus

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.

تحديث بتاريخ 23 October, 2024

المتطلبات

Basic Computer Knowledge: Familiarity with general computer operations.Keyboard Skills: Ability to perform basic typing tasks.

نبذة عن معهد Marvel Management Training Institute

MADRAS MANAGEMENT TRAINING INSTITUTE IN QATAR & MARVEL MANAGEMENT TRAINING INSTITUTE IN BAHRAIN
Let us introduce ourselves as an Executive Education and Continuing Professional Development center specialized in preparing management professionals to achieve their career high through certification in their respective field.MMTI has specialized in providing professionals the knowledge & tools to drive their business. MMTI is a leader in developing and delivering corporate and professional educational solutions.Our approach focuses on learning that empowers you to acquire knowledge, apply it, achieve results, and then interpret those results to identify new opportunities- again and again.
عرض الجميع دورات Marvel Management Training Institute

استفسر عن هذه الدورة

يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

قيِم هذه الصفحة