- Duration: 6 Months
Course details
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 Location
About MMTI - Marvel Management Training Institute 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.
Benefits from MMTI:
- Make it easy Study Materials
- Module wise/Chapter wise tests
- Unlimited number of Full length/Module wise Mock up tests (PMP)
- Post training support on subject and exams
- Membership and Exam scheduling assistance
- Free Re-training for unsuccessful aspirants
- TAMKEEN/MOL support assistance
- Regular reminders for classes, exams
- Scheduling to attend the missed classes
Our Vision:
- To be pioneer institute and the training provider of choice by the industry.
- To train most number of professionals in the region we belong to through our easy and dedicated methodology
in training to lead the professionals toward success.
Our Mission:
- Inspire by Quality and Excellent training
- Lead by Example
- Guide towards goals
- Motivate towards success
- Make them feel easy to understand by using Teamwork
- Mentor them with great experience and knowledge.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- VLOOKUP: Mastering in 60 Minutes StudyHubBHD 5
BHD 98Duration: Upto 1 Hour - Microsoft Excel NextGen LearningBHD 5Duration: 11 Hours