Microsoft Excel Training is suitable for someone who has the basics of Microsoft Excel, this course will help bring you to the next level for greater efficiency and productivity.
In this Microsoft Excel Training, you will learn the most important advanced Excel features, functions, tools, tricks, and reporting techniques. You will be able to perform your daily and periodic excel-related tasks professionally and become the Excel Star in your departments and offices. Besides, the participants will also learn how to map and manage huge data, as well as how to extract key information in a short amount of time.
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
Module 1: Calculating with Formulas
- How formulas work
- Using “$” in formulas
- SUM function
- MAX and MIN function
- AVERAGE and AVERAGE function
- COUNT and COUNTA function
- COUNTIF & SUMIF function
Module 2: Conditional Formatting
- How to use conditional formatting
- Using conditional formatting presets
- Managing and prioritizing rules
- Using top bottom rules
- Customizing data bars
- Using formulas in conditional formatting
Module 3: Sparklines
- Inserting sparklines
- Formatting sparklines
Module 4: Charts
- Creating a chart
- Using Excel’s recommended charts
- Formatting charts
- Changing chart data
- Filtering chart data
- Creating a dual-axis line chart
- Saving a chart template
Module 5: Logical Functions
- Function: IF, AND, OR
- Nested IF & AND Function
- Nested IF & OR Function
Module 6: Pivot Tables
- Creating A Pivot Table
- Changing the Layout of the Pivot Table
- Using Filters and Report Filters
- Grouping Data in Pivot table
- Calculation in Pivot Table
- Using Slicers
Module 7: Data Validation
- Setting Data Validation Rules
- Message & Error Alert
- INDIRECT Function with Data Validation
Module 8: Working with Data from Multiple Worksheets & Workbooks
- Consolidating Data from Multiple Sources
- Consolidating With Formulas
- Linking Cells with other Sheets & Workbooks
- Repairing Broken Links
Module 9: Text Function
- REPLACE, SUBSTITUTE, LEN & TRIM
Module 10: Passwords & Security
- Adding Open & Modify Password
- Protecting cells with password
- Protecting Worksheets
- Hiding Formula
For more information about our Digital Marketing Masterclass, 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/
