Microsoft Office Excel - Training Course & Certification

Data Analysis Using Excel Registration

https://zoom.us/meeting/register/tJYufumqqzwqGtOTR5E6thAOkX9Zvh4dG5U6

Excel spreadsheets are commonly used for personal and business purposes to store and analyze financial information and other relevant data. This could be information relevant to Employee Management, Inventory, Sales and Marketing .

The Microsoft Office Excel course will enable you maximize the value of your data and provide an in-depth knowledge of the data analysis and visualization features to enable you work more efficiently and increase productivity.

Essential Functions and Formulas

➖ Using the VLOOKUP Function to search for information in a table.

➖ Using the CONCAT Function to join multiple texts in different cells into one text.

➖ Using the SUMIF Function to get the total value in a range that meets the criteria you specify.

Data Analysis

➖ Using Conditional formatting to apply visual identifications to your data in form of colours and/or icons to enable you analyze data patterns and trends.

➖ Using Pivot Tables and Pivot Charts to summarize, analyze, explore, and visualize data in a worksheet.

➖ Using Data Consolidation to combine separate data on different worksheets into one master worksheet for easy analysis without having to view different worksheets regularly e.g. Combine sales from North, East, West and South worksheets into an All Regions worksheet.

➖ Using Subtotals to calculate rows of related data and analyze the sum totals, averages, etc. of related values.

Data Security

➖ Using Data Validation to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering invalid data in a cell or range of cells.

Contact Us

Microsoft Office Excel – Training Course & Certification

Essential Functions and Formulas

Data Analysis

Data Security

Recent Posts