What will you learn in Microsoft Excel Training?
- Manage database effectively
- Apply proper formula and function
- Troubleshooting errors
- Link and Embed Data from other sources.
- Applying Conditional Formatting and Validation Rules
- Build upon the essential Microsoft Office Excel knowledge and skills.
- Learn to create advanced workbooks and worksheets, including advanced formulas, tables, and data-analyzing tools.
Course Outline
DATA MANAGEMENT
• Sorting
• Sorting Multiple Columns
• Finding Data
• Replacing Data
• Finding and Replacing Cell Format
• Practice – Data Management
WORKING WITH DATABASES
• Creating Subtotals in a List
• Removing Subtotals from a List
• Sorting Data by Multiple Levels
• Using Custom Sort
• Using Data Validation
• Validating Data using a List
• Creating a Custom Error Message
• Removing Data Validation
USING TEMPLATES
• Copying Worksheets
• Hiding Columns and Rows
• Unhiding Columns and Rows
• Saving a Workbook as a Template
• Using a Template
• Editing a Template
• Inserting a New Worksheet
• Hiding/Unhiding a Worksheet
• Deleting a Template
• Finding Online Templates
CREATING CHARTS
• Inserting a column chart
• Inserting a line chart
• Inserting a bar chart
• Inserting a pie chart
• Resizing a chart
• Deleting a chart
• Adding a Chart Title
• Changing the Chart Background
• Changing a column, bar, line, or pie slice colours
• Changing the chart type
• Adding a Data Table
• Changing the Chart Layout
• Copying and moving charts
• Creating a 3-D Chart
• Adjusting 3-D View
• Inserting Sparklines
• Practice – Creating Charts
REVISING CHARTING FEATURES
• Formatting an Axis
• Changing the Axis Scaling
• Formatting the Data Series
• Adding Data from Different Worksheets
• Using a Secondary Axis
• Changing Data Series Chart Types
• Changing Source Data Range
WORKING WITH ADVANCED FILTERS
• Creating a Criteria Range
• Using a Criteria Range
• Showing All Records
• Using an Advanced and Condition
• Using an Advanced or Condition
• Copying Filtered Records
• Using Database Functions
USING CONDITIONAL AND CUSTOM FORMATS
• Applying Conditional Formats
• Changing a Conditional Format
• Adding a Conditional Format
• Creating a Custom Conditional Format
• Using Data Bars
• Deleting a Conditional Format
• Creating a Custom Number Format
USING WORKSHEET PROTECTION
• Unlocking Cells in a Worksheet
• Protecting a Worksheet
• Unprotecting a Worksheet
• Creating Allow-Editing Ranges
• Deleting Allow-Editing Ranges
• Protecting Workbook Windows
• Unprotecting Workbook Windows
• Assigning a Password
• Opening a Password-protected File
• Removing a Password
USING AUDITING TOOLS AND RANGE NAMES
• Jumping to a Named Range
• Assigning Names
• Using Range Names in Formulas
• Creating Range Names from Headings
• Applying Range Names
• Deleting Range Names
• Using Range Names in 3-D Formulas
• Displaying/Removing Dependent Arrows
• Displaying/Removing Precedent Arrows
• Showing Formulas
EXPORTING AND IMPORTING DATA
• Importing Data from Text Files
• Changing External Data Range Properties
• Removing the Query Definition
• Creating a Hyperlink
• Editing a Hyperlink
USING ADVANCED FUNCTIONS
• Using the VLOOKUP Function
• Using the HLOOKUP Function
• Using the IF Function
• Using Nested IF Functions
• Using the ISERROR Function
• Using an AND Condition with IF
• Using an OR Condition with IF
• Using the ROUND Function
• Using COUNTIF Function
• Using RANK Function
• Using Financial Functions
• Using Text Functions
CREATING/REVISING PIVOT TABLES
• Creating a PivotTable Report
• Adding PivotTable Report Fields
• Selecting a Page Field Item
• Refreshing a PivotTable Report
• Changing the Summary Function
• Adding New Fields to a PivotTable Report
• Moving PivotTable Report Fields
• Hiding/Unhiding PivotTable Report Items
• Deleting PivotTable Report Fields
• Creating a Page Field Report
• Formatting a PivotTable Report
• Creating a PivotChart Report
• Grouping Data Manually
USING SCENARIOS
• Creating a Scenario
• Displaying a Scenario
• Editing a Scenario
• Creating a Scenario Summary Report
• Working with Data Tables
• Placing Formulas in Data Tables
• Creating a One-Variable Table
• Creating a Two-Variable Table
TRACKING AND MERGING WORKBOOKS
• Saving a Shared Workbook
• Viewing Users Sharing a Workbook
• Viewing Shared Workbook Changes
• Changing the Update Frequency
• Highlighting Changes
• Managing Conflicting Changes
• Resolving Conflicting Changes
• Setting Change History Options
• Adding a History Worksheet
• Reviewing Tracked Changes
• Merging Shared Workbook Files
RECORDING MACROS
• Recording a Macro
• Saving a Macro-Enabled Workbook
• Running a Macro
• Assigning a Shortcut Key
• Using a Shortcut Key
• Deleting a Macro
• Adding a Macro to Quick Access Toolbar
• Deleting a Macro Button from QAT
For more information about our Microsoft Excel Training, contact us at 1700-81-5520 or email us at training@excelacademy.my. To keep updated with our training you can follow us on Facebook, https://www.facebook.com/excelacademyofexecutiveeducation
Check out other courses, https://www.excelacademy.my/hrdcorp-claimablecourse/