{"id":1785,"date":"2024-02-01T14:40:40","date_gmt":"2024-02-01T11:40:40","guid":{"rendered":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/?page_id=1785"},"modified":"2024-02-01T14:40:40","modified_gmt":"2024-02-01T11:40:40","slug":"ms-excel-skills-training-basic-intermediate","status":"publish","type":"page","link":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/ms-excel-skills-training-basic-intermediate\/","title":{"rendered":"MS Excel Skills Training …Basic & Intermediate"},"content":{"rendered":"

\"Dolphins<\/p>\n

 <\/p>\n

This instructor-led course will provide knowledge of excel. Excel provides tools for data discovery, transformation, and enrichment. It allows you to combine data quickly and easily from one or more structured or semi-structured sources (Excel, CSV, relational databases, SAP, online services, etc.) in a repeatable manner and apply analysis expression functions for insights. This course will provide in-depth working knowledge of Functions, Auditing, charting, Validation including practical solutions to common scenarios.<\/p>\n

 <\/p>\n

Content:<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Working with multiple worksheets and workbook<\/td>\n Navigating between sheets<\/p>\n

Creating a formula to link worksheets<\/p>\n

Consolidating data<\/p>\n

Linking workbooks<\/p>\n

Creating a formula to link workbooks<\/td>\n<\/tr>\n

Working with Large worksheets<\/td>\n Viewing and organizing spreadsheet data<\/p>\n

Zoom feature<\/p>\n

Using freeze panes<\/p>\n

Grouping data manually<\/p>\n

 <\/td>\n<\/tr>\n

Cell referencing<\/td>\n Appropriate use of cell referencing in formulas.<\/p>\n

Relative referencing,<\/p>\n

Absolute referencing and<\/p>\n

Mixed referencing<\/p>\n<\/td>\n<\/tr>\n

Summarizing Data<\/td>\n Creating Subtotals with aggregating functions<\/p>\n

Creating conditional summaries with conditional aggregate functions<\/p>\n

Gathering insights with statistical functions<\/p>\n

 <\/td>\n<\/tr>\n

Excel functions<\/td>\n Logical functions for branch prediction and decision making IF, IFERROR<\/p>\n

Manipulating textual data with text functions<\/p>\n

Working with time series data using Date and Time functions<\/p>\n

Work with multiple lists and tables using lookup and reference functions<\/td>\n<\/tr>\n

Conditional formatting<\/td>\n Introduction to Conditional Formatting<\/p>\n

Highlight cell rules<\/p>\n

Top\/Bottom rules<\/p>\n

Data bars and Color scales<\/p>\n

Icon sets<\/p>\n

Using Formula in Conditional Formatting<\/p>\n

 <\/td>\n<\/tr>\n

Sorting and Filtering<\/td>\n Multi-Levels of Sorting<\/p>\n

Data Filtering-conditional Filters<\/p>\n

Text filter<\/p>\n

Number filter<\/p>\n

Date filter<\/p>\n

Wildcard<\/p>\n

Top 10 filter<\/p>\n

Advanced Filtering<\/p>\n

Filtering and Sorting in Excel Data Tables<\/p>\n

 <\/td>\n<\/tr>\n

Charts for visualization<\/td>\n Creating and modifying charts<\/p>\n

Adding trend-lines<\/p>\n

Visualizing multiple series and dissimilar data types<\/p>\n

Using sparklines<\/p>\n

Chart layout options<\/p>\n

 <\/td>\n<\/tr>\n

Tables<\/td>\n Creating managing and formatting tables, sorting filtering and applying quick analysis for data insights.<\/p>\n

Cleaning duplicate records<\/p>\n

Adding and deleting records<\/td>\n<\/tr>\n

Data Validation<\/td>\n Data Validation Criteria<\/p>\n

Input Message<\/p>\n

Customizing Error Messages<\/p>\n

Circle Invalid Entries<\/p>\n

Creating Dynamic Drop down List<\/p>\n

Validating Numbers<\/p>\n

Validating Dates<\/p>\n

Validating Text Length<\/p>\n

Custom validation to create special rule<\/p>\n

 <\/td>\n<\/tr>\n

Formula Auditing<\/td>\n Auditing features<\/p>\n

Tracing formula errors<\/p>\n

Error checking<\/p>\n

Evaluate formula<\/p>\n

Circular reference errors<\/p>\n

Protecting a worksheet<\/p>\n

Protecting cell ranges<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/strong><\/p>\n

REQUIREMENTS:<\/strong><\/p>\n