Data Analysis and Visualizing using Microsoft Excel
Details
Manage workbook options and settings
- Manage workbooks
- Use and configure language options
- Prepare workbooks for collaboration
Outline
Manage workbook options and settings
- Manage workbooks
- Use and configure language options
- Prepare workbooks for collaboration
Manage and format data
- Fill cells based on existing data
- Format and validate data
- Apply advanced conditional formatting and filtering
Create advanced formulas and macros
- Perform logical operations in formulas
- Look up data by using functions
- Use advanced date and time functions
- Perform data analysis
- Troubleshoot formulas
- Create and modify simple macros
Consume and Transform Data by Using Microsoft Excel
- Import from data sources
- Perform data transformations
- Cleanse data
Model Data
- Create and optimize data models
- Create calculated columns, measures, and tables
- Create performance KPIs
- Create hierarchies
Visualize Data
- Create and modify advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
- Interact with Power BI
Speaker/s
Special Offer
Schedules
Tue, Fri | 09:00 AM — 04:00 PM |
No. of Days: | 4 |
Alpha Partners is a reputable firm of Training and Management Consultants with many years of corporate training experience in Finance, Accounting, Auditing, Banking, Management, Information Technology, Oil and Gas Sector, Security, Engineering, Public Relations, Secretarial Studies, Leadership, Marketing and other fields of human endeavour.
We are one of the leading players in the profession. Our firm, a multi-disciplinary one with highly talented, experienced and dedicated partners and staff who have experiences in different facets of working life was established in 1996 and has branches in Lagos, Enugu and Awka.
We offer a wide range of professional services, which covers audits, accounting, finance, taxation, ICT, security, engineering, insurance, human resources management, secretarial and consultancy services in all ramifications.
Our numerous clients attest to the high quality services we offer which contribute in no small measure in ensuring sound and efficient management of their resources.