Flowcharting in Microsoft Excel

Partner: Udemy
Affiliate Name:
Area:
Description: There are many courses on how to use Excel. In contrast the instructor focuses on workbook design so that workbooks are:Easy to understand for both the developer and the user.Error-freeAutomatedThis logical and structured approach is called ‘Excel Engineering’. The first step in the Excel Engineering approach is to create a flowchart (or flowsheet).Flowcharts are commonly used in process modelling, engineering, simulation and software development. All well-designed Excel workbooks will have flowcharts visualising dataflow.Once an effective flowchart is created, both the user and developer gain clarity in understanding the dataflow within a workbook. The course introduces concepts such as hyperlinking to and from the flowchart to the Excel data (enabling easy navigation, and eliminating the need for provided Excel functionality such as trace precedents and dependents).The course also confronts some of the limitations of flowcharting in front-end Excel and provides ways to increase the Excel functionality of Excel Flowcharting by providing VBA add-ins that are freely available to course participants.The course is divided into 5 sections:  Introduction ( a general explanation about flowcharting and relevant flowcharting concepts)Hands-on flowcharting in Excel  (focus on shape and connectors, and putting these into a canvas)Creating a flowchart of a workbook ( a simple example of how to create a flowchart for a defined workbook)Using flowcharts software provided by instructor (Excel flowchart capability is limited so add-ins provided by the instructor are provided to enhance flowchart capability, A fundamental add-in is that which automates hyperlinking to and from the flowchart  and the workbook data rendering navigation much easier).This sec
Category: Office Productivity > Microsoft > Microsoft Excel
Partner ID:
Price: 24.99
Commission:
Source: Impact
Go to Course