{"id":167633,"date":"2020-10-05T00:24:48","date_gmt":"2020-10-04T22:24:48","guid":{"rendered":"https:\/\/www.myza.co.za\/microsoft-excel-skills-for-business-accounting-and-analysis-12th-to-16th-october\/"},"modified":"2020-10-05T00:24:48","modified_gmt":"2020-10-04T22:24:48","slug":"microsoft-excel-skills-for-business-accounting-and-analysis-12th-to-16th-october","status":"publish","type":"post","link":"https:\/\/www.myza.co.za\/press\/microsoft-excel-skills-for-business-accounting-and-analysis-12th-to-16th-october\/","title":{"rendered":"Microsoft Excel Skills for Business Accounting and Analysis.12th to 16th October"},"content":{"rendered":"

Microsoft Excel Skills for Business Accounting and Analysis.12th to 16th October<\/a><\/strong><\/p>\n

A Kenya Event on 2020-10-12 08:00:00<\/i><\/p>\n

FineResults Research Services invites you to training on:<\/p>\n

Topic: \tMicrosoft Excel Skills for Business Accounting and Analysis<\/p>\n

Date:\t12th to 16th October 2020<\/p>\n

Cost: \tUSD 800 or Ksh 65000<\/p>\n

Contacts: \t+254 759 285 295, training@fineresultsresearch.org.<\/p>\n

Venue : FineResults Research, Nairobi, Kenya Training Centre.<\/p>\n

INTRODUCTION
\nMicrosoft Excel has powerful business analysis capabilities and dynamic reporting features that provide managers and business owners with the information and insights instantly. This course is will equip the participants with skills for retrieving data from Excel, analyzing the data, making budgets, P&L, sales reports and other business report (statutory or otherwise). Participants will also be trained on how to make dynamic dashboards that can be used to display the information using interactive charts and reports. Participants will also be equipped with necessary skills in interpreting various Microsoft Excel reports\/outputs in key business decision-making and planning. Effort will be made to illustrate how to make use of Microsoft Excel data analysis functions and the program analysis toolpak.<\/p>\n

DURATION
\n5 days<\/p>\n

COURSE OBJECTIVES
\nBy the end of this course, participants will be able to know:
\n\u2022\tGain enhanced spreadsheets data skills: creating templates, charts, graphics and formulas for business and operational work.
\n\u2022\tHow to calculate with advanced functions & formulas, create interactive charts using Excel
\n\u2022\tHow to analyze data using Pivot Charts. insert graphic objects and quickly transform business data into informative reports using PivotTables
\n\u2022\tHow to use business dashboards to compare multiple business elements in one screen
\n\u2022\tHow to generate management and weekly reports quickly and accurately
\n\u2022\tHow to use Microsoft Excel analysis toolpak.<\/p>\n

TRAINING FOCUS
\nModule 1:
\nIntroduction to Microsoft Excel
\n\u2022\tIntroduction, Outline & Objectives
\n\u2022\tFunctions and Formulae
\n\u2022\tEntering and Copying Formulae
\n\u2022\tCreating Formulas using Names
\n\u2022\tManaging Names using, Name Manager
\n\u2022\tSearching for Functions
\n\u2022\tNaming Ranges
\n\u2022\tCreating Named Ranges
\n\u2022\tUsing Names in Movement
\n\u2022\tInserting Names in Formulae
\n\u2022\tFormatting
\n\u2022\tNumber Formatting
\n\u2022\tCell Styles
\n\u2022\tCopying and Clearing formatting<\/p>\n

Module 2:
\nCalculating with Formulas and Functions
\n\u2022\tUse Date and Time Functions
\n\u2022\tUse Statistical Functions
\n\u2022\tUse Database Functions
\n\u2022\tUse Lookup Functions
\n\u2022\tUse Logical Functions<\/p>\n

Module 3:
\nVisualizing Data with Charts
\n\u2022\tUse Recommended Charts Tool
\n\u2022\tCreate Chart with Quick Analysis
\n\u2022\tAlign Chart Axis Labels
\n\u2022\tDisplay Value Axis in Millions
\n\u2022\tCreate Chart with Multi Line Labels
\n\u2022\tCreate Combo Chart
\n\u2022\tCreate Chart Template for Sharing
\n\u2022\tBuild Dynamic Chart with Table<\/p>\n

Module 4:
\nAnalyzing Data with Tables and Importing External Data Sources
\nTables
\n\u2022\tCreate Table with Quick Analysis
\n\u2022\tRemove Duplicate Records
\n\u2022\tAdd Total Row to Table
\n\u2022\tInsert Calculated Columns
\n\u2022\tFilter Table Data with Custom Filter
\n\u2022\tUse Slicer to Filter Data
\n\u2022\tApply Conditional Formatting
\n\u2022\tSort and Filter Data by Color
\n\u2022\tCreate In-Cell Chart with Sparklines<\/p>\n

PivotTables
\n\u2022\tOverview of PivotTable & PivotChart
\n\u2022\tCreate PivotTable from Table
\n\u2022\tChange Report Layouts
\n\u2022\tShow and Hide Report Totals
\n\u2022\tCreate Custom Calculations
\n\u2022\tFilter Pivot Data with Slicer and Timeline
\n\u2022\tGroup Fields in a PivotTable
\n\u2022\tCreate Calculated Fields in PivotTable<\/p>\n

Importing External Data Sources
\n\u2022\tImport Data from Text Files
\n\u2022\tCreate PivotTable from Microsoft Access
\n\u2022\tCreate PivotChart from Microsoft Access
\n\u2022\tManage Data Connections<\/p>\n

Module 5:
\nCreating Dashboard Report
\n\u2022\tOverview of Dashboard
\n\u2022\tCreate PivotTable and PivotChart
\n\u2022\tHide Field Buttons from PivotChart
\n\u2022\tUse Slicer to Connect PivotTables
\n\u2022\tBuild a Slicer Dashboard Report<\/p>\n

Other Tips and Tools
\n\u2022\tFlash Fill
\n\u2022\tQuick Analysis
\n\u2022\tSlicer to Filter Excel Table
\n\u2022\tTimeline to Filter PivotTable
\n\u2022\tConnecting Multiple PivotTables
\n\u2022\tSparklines<\/p>\n

NB: We are offering you a half day, fun and interactive team building event!<\/p>\n

Be part of the Training
\n\u2022\tClick HERE for the individual registration. <\/p>\n

Engage with us on <\/p>\n

Visit our face book page <\/p>\n

Visit our linkedin page <\/p>\n

Visit our twitter account<\/p>\n

at Fahari Palace Apartment Nairobi kenya<\/a>
\nwestlands nairobi
\nNairobi, Kenya<\/p>\n

Add your Kenya<\/em> event for free here<\/a> on MyZA.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Excel Skills for Business Accounting and Analysis.12th to 16th October A Kenya Event on 2020-10-12 08:00:00 FineResults Research Services invites you to training on: Topic: Microsoft Excel Skills for Business Accounting and Analysis Date: 12th to 16th October 2020 Cost: USD 800 or Ksh 65000 Contacts: +254 759 285 295, training@fineresultsresearch.org. Venue : FineResults […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9840],"tags":[18545,21120,3078,39021,5855,13317,1811,5537],"class_list":{"0":"post-167633","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-eventful","7":"tag-business","8":"tag-16th","9":"tag-accounting","10":"tag-analysis-12th","11":"tag-excel","12":"tag-microsoft","13":"tag-october","14":"tag-skills","15":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/posts\/167633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/comments?post=167633"}],"version-history":[{"count":0,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/posts\/167633\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/media?parent=167633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/categories?post=167633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/tags?post=167633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}