Microsoft Access Database Solutions - Accra, Ghana

Gain strong foundational knowledge of Excel to organize, analyze and work with data.
In this training you will develop essential skills such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis.

This training is designed for those with little or no functional knowledge of Excel, as well as those who use Excel at a basic level but wish to enhance their skills. From basic operations to an introduction to more advanced techniques,
you’ll gain the confidence to navigate the Excel interface, master essential spreadsheet functions, perform calculations and produce creative charts and graphs from your data, while building an aptitude for data analysis that is critical to the success of any organization.

What You'll Learn

Excel fundamentals.
Data entry and editing using various formats.
Performing calculations using formulas and functions.
How to format and optimize spreadsheets.
How to manage spreadsheets using Filter and sort table data capabilities.
Previewing and printing.
Effective data visualization using basic charts

Learn how to leverage the power of data calculations and reports to make informed personal or organizational decisions.

WHAT YOU'LL LEARN
How to manage multiple worksheets and workbooks.
Analyzing data with datasets and tables.
How to manage data analysis using Pivot Tables and Pivot Charts.
Implementing What-If Analysis and Decision-Making Tools.
Using Date, Logical, Statistical and Financial Functions.

Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data.

WHAT YOU'LL LEARN
How to apply advanced formulas and conditional logic.
How to analyze and report on data frequently.
Automating complex or repetitive tasks.
How to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Protecting your workbooks.
Performing Formula Audits and Data Validation.
Creating Macros and usingVisual Basic.
How to use Advanced Charting Techniques to build professional dashboards.