BASIC MICROSOFT EXCEL TRAINING IN THE PHILIPPINES<\/span><\/strong><\/h2>\n\u00a0<\/strong><\/p>\nENTERTRAINMENT OVERVIEW:<\/strong><\/span><\/h3>\nThis Basic Microsoft Excel Training in the Philippines provides Basic Microsoft Excel training to new users.<\/span><\/p>\n <\/p>\n
ENTERTRAINMENT GOAL:<\/strong><\/span><\/h3>\nEquip new users with fundamental Microsoft Excel skills through Basic Microsoft Excel Training in the Philippines.<\/span><\/p>\n <\/p>\n
ENTERTRAINMENT OBJECTIVES:<\/strong><\/span><\/h3>\nTo achieve the goal above, the participants should be able to:<\/span><\/p>\n\n- Navigate Excel interface proficiently including creating new workbooks, using menus, and accessing help features.<\/span><\/li>\n
- Format worksheets effectively by adjusting page layout, fonts, alignments, and applying colors and patterns.<\/span><\/li>\n
- Manage workbooks efficiently by organizing sheets, protecting data, and utilizing advanced printing options.<\/span><\/li>\n
- Edit workbook contents skillfully including entering, editing, and clearing cell contents, as well as using copy-paste functionalities.<\/span><\/li>\n
- Create, edit, and troubleshoot formulas for basic calculations, as well as utilize the Forms menu for sorting, subtotaling, and filtering data.<\/span><\/li>\n
- Develop proficiency in creating and working with charts, including formatting, editing, and annotating chart elements.<\/span><\/li>\n
- Master data analysis techniques using PivotTables, including creating, updating, and formatting PivotTables for effective data interpretation.<\/span><\/li>\n
- Enhance spreadsheet functionality by utilizing various functions such as Paste Function, logical functions, and VLOOKUP.<\/span><\/li>\n
- Implement workbook protection, cell comments, and collaboration features to ensure data security and effective team collaboration.<\/span><\/li>\n<\/ul>\n
<\/p>\n
ENTERTRAINMENT OUTLINE:<\/strong><\/span><\/h3>\nMODULE ONE: THE BASICS<\/strong><\/span><\/h4>\n\n- Creating a New Workbook<\/span><\/li>\n
- Navigating in Excel<\/span><\/li>\n
- Moving the Cell Pointer<\/span><\/li>\n
- Using Excel Menus<\/span><\/li>\n
- Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars<\/span><\/li>\n
- Entering Values in a Worksheet and Selecting a Cell Range<\/span><\/li>\n
- Previewing and Printing a Worksheet<\/span><\/li>\n
- Getting Help from the Office Assistant<\/span><\/li>\n
- Saving a Workbook & Re-opening a saved workbook<\/span><\/li>\n<\/ul>\n
<\/p>\n
MODULE TWO: FORMATTING A WORKSHEET\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> <\/strong><\/h4>\n\n- Creating Headers, Footers, and Page Numbers<\/span><\/li>\n
- Adjusting Page Margins and Orientation<\/span><\/li>\n
- Adding Print Titles and Gridlines, rows to repeat at top of each page<\/span><\/li>\n
- Formatting Fonts & Values<\/span><\/li>\n
- Adjusting Row Height and Column Width<\/span><\/li>\n
- Changing Cell Alignment<\/span><\/li>\n
- Adding Borders<\/span><\/li>\n
- Applying Colors and Patterns<\/span><\/li>\n
- Using the Format Painter<\/span><\/li>\n
- Using AutoFormat<\/span><\/li>\n
- Merging Cells, Rotating Text, and using AutoFit<\/span><\/li>\n
- Using AutoFill<\/span><\/li>\n<\/ul>\n
<\/p>\n
MODULE THREE: MANAGING YOUR WORKBOOKS<\/strong><\/span><\/h4>\n\n- Switching Between Sheets in a Workbook<\/span><\/li>\n
- Inserting and Deleting Worksheets<\/span><\/li>\n
- Renaming and Moving Worksheets<\/span><\/li>\n
- Protecting a Workbook<\/span><\/li>\n
- Hiding Columns, Rows and Sheets<\/span><\/li>\n
- Splitting and Freezing a Window<\/span><\/li>\n
- Inserting Page Breaks<\/span><\/li>\n
- Advanced Printing Options<\/span><\/li>\n<\/ul>\n
\u00a0<\/strong><\/p>\nMODULE FOUR: EDITING A WORKBOOK<\/strong><\/span><\/h4>\n\n- Entering Date Values and using AutoComplete<\/span><\/li>\n
- Editing, Clearing, and Replacing Cell Contents<\/span><\/li>\n
- Cutting, Copying, and Pasting Cells<\/span><\/li>\n
- Moving and Copying Cells with Drag and Drop<\/span><\/li>\n
- Collecting and Pasting Multiple Items<\/span><\/li>\n
- Using the Paste Special Command<\/span><\/li>\n
- Inserting and Deleting Cells, Rows, and Columns<\/span><\/li>\n
- Using Undo, Redo, and Repeat<\/span><\/li>\n
- Checking Your Spelling<\/span><\/li>\n
- Finding and Replacing Information<\/span><\/li>\n
- Inserting Cell Comments<\/span><\/li>\n<\/ul>\n
\u00a0<\/strong><\/p>\nMODULE FIVE: FORMULAS<\/strong><\/span><\/h4>\n\n- Creating a basic Formula<\/span><\/li>\n
- Calculating Value Totals with AutoSum<\/span><\/li>\n
- Editing & Copying Formulas<\/span><\/li>\n
- Fixing Errors in Your Formulas<\/span><\/li>\n
- Formulas with Several Operators and Cell Ranges<\/span><\/li>\n<\/ul>\n
\u00a0<\/strong><\/p>\nMODULE SIX: WORKING WITH THE FORMS MENU<\/strong><\/span><\/h4>\n\n- Sorting, Subtotaling & Filtering Data<\/span><\/li>\n
- Copy & Paste Filtered Records<\/span><\/li>\n
- Using Data Validation<\/span><\/li>\n<\/ul>\n
<\/p>\n
MODULE SEVEN: CREATING AND WORKING WITH CHARTS<\/strong><\/span><\/h4>\n\n- Creating a Chart<\/span><\/li>\n
- Moving and Resizing a Chart<\/span><\/li>\n
- Formatting and Editing Objects in a Chart<\/span><\/li>\n
- Changing a Chart’s Source Data<\/span><\/li>\n
- Changing a Chart Type and Working with Pie Charts<\/span><\/li>\n
- Adding Titles, Gridlines, and a Data Table<\/span><\/li>\n
- Formatting a Data Series and Chart Axis<\/span><\/li>\n
- Annotating a Chart<\/span><\/li>\n
- Working with 3-D Charts<\/span><\/li>\n
- Selecting and Saving a Custom Chart<\/span><\/li>\n
- Using Fill Effects<\/span><\/li>\n
- Mapping Data<\/span><\/li>\n
- Modifying a Map<\/span><\/li>\n<\/ul>\n
<\/p>\n
MODULE EIGHT: DATA ANALYSIS AND PIVOT TABLES<\/strong><\/span><\/h4>\n\n- Creating a PivotTable<\/span><\/li>\n
- Specifying the Data a PivotTable Analyzes<\/span><\/li>\n
- Changing a PivotTable’s Calculation<\/span><\/li>\n
- Selecting What Appears in a PivotTable<\/span><\/li>\n
- Grouping Dates in a PivotTable<\/span><\/li>\n
- Updating a PivotTable<\/span><\/li>\n
- Formatting and Charting a PivotTable<\/span><\/li>\n<\/ul>\n
<\/p>\n
MODULE NINE: WORKING WITH FUNCTIONS<\/strong><\/span><\/h4>\n\n- Using the Paste Function tool<\/span><\/li>\n
- Absolute and relative cell references<\/span><\/li>\n
- Using range names in functions<\/span><\/li>\n
- Creating nested functions<\/span><\/li>\n
- Logical functions (SUMIF, COUNTIF)<\/span><\/li>\n
- The IF function and nested Ifs<\/span><\/li>\n
- Using AND and OR conditions<\/span><\/li>\n
- Using VLOOKUP<\/span><\/li>\n<\/ul>\n
<\/p>\n
MODULE TEN: WORKING WITH FUNCTIONS<\/strong><\/span><\/h4>\n\n- Protecting a workbook<\/span><\/li>\n
- Protecting worksheets and cells<\/span><\/li>\n
- Adding comments to cells<\/span><\/li>\n
- Sharing workbooks<\/span><\/li>\n