Home
Videos uploaded by user “AnalyzeIT”
MS Excel ActiveX: How to change the font size & style in a combo box
 
02:27
Ken Atigari: Learn how to change the size and style of fonts in Excel's activex combo box.
Views: 15172 AnalyzeIT
Microsoft Excel ScreenTip on Mouse Hover using Hyperlink Function
 
03:11
Ken Atigari. Ever wanted to move your mouse cursor over an object such as a map in Excel and see a label pop up? The ScreenTip function embedded within Excel's Hyperlink function is the way to go. This lesson will show you how you can go about creating such mouseover pop up labels that will make your Excel applications look very cool.
Views: 12017 AnalyzeIT
Creating dropdown list using data validation, form control and activex control
 
07:54
Ken Atigari shows how you can create a drop-down using data validation, Form controls and Activex Control
Views: 2496 AnalyzeIT
MS Excel ActiveX: How to link Combobox selection as an output cell value.
 
04:08
Ken Atigari: In this free video, you'll learn how to access the ActiveX 'properties' window in order to make changes to the combo box that will link the value presented in the combobox to an Excel cell.
Views: 14530 AnalyzeIT
MS EXCEL: Using a little VBA to reset the value of a dependent dropdown list
 
11:54
Ken Atigari: Sometimes when you're building tools and forms in Excel, you'd like values in hierarchically dependent drop downs to be reset. For example, when you change the country in a drop drown from UK to Canada, you'd expect that city box is reset from London to a blank box. This video tutorial will show you how you can use VBA to do this in Excel.
Views: 7759 AnalyzeIT
MS Excel: Learn how to Create Maps by editing Shapes
 
08:23
Ken Atigari -Learn how to create Microsoft Excel maps by inserting shapes and then manipulating them using 'edit points' function in Excel. After creating your maps, you can go further to RAG rate them into heat maps using some VBA syntax which is not covered in this video tutorial.
Views: 3331 AnalyzeIT
Excel: Extending a named range (name manager) for a dropdown list
 
04:05
Using a Tracker application, Ken Atigari demonstrates how an Excel user can extend a named range that is being used by a data validation list.
Views: 994 AnalyzeIT
Excel Desk Booking Tool
 
22:50
Ken Atigari shows how to create a dynamic desk booking tool using Excel. In creating the tool, he uses Hlookups, data validation and conditional formatting mixed with good old common sense.
Views: 8582 AnalyzeIT
Integrating Excel VBA with SQL Server: Lesson 1
 
10:10
In this 4 part series, Ken Atigari demonstrates how you can integrate Excel with SQL using VBA programming.
Views: 35961 AnalyzeIT
Dependent heirarchy dropdown lists in Excel and some VBA
 
19:42
Ken Atigari demonstrates how to create 3 hierarchically dependent drop down lists. He also shows how a little VBA programming can reset the lists to default values.
Views: 2588 AnalyzeIT
Exporting Data from SQL to Excel using Copy and Paste Method
 
03:33
Ken Atigari shows an easy "Copy and Paste" way you can export some data from SQL to Excel or a CSV file without having to use SSIS or other export /import functions.
Views: 1602 AnalyzeIT
Excel VLookup:Hard Coding and Lookup Direction
 
06:59
In this video, the viewer is shown how to hard code the lookup value and the table array. Ken also demonstrates that vlookup is only able to read data to the right of the 'lookthrough" data and not those on its left. The user would need to copy data from a left column to the right of the "lookthrough" column
Views: 2515 AnalyzeIT
Using nested IFs in Excel Data Vaildation
 
10:42
Ken Atigari: Watch how to use If and nested if statements within the Data Validation window in Excel.
Views: 1381 AnalyzeIT
VLookup Organisation Case Study Example of Mapping 80,000 Spreadsheet Rows
 
05:11
Using a business example, we map over 60 supplier's ID to supplier's names in a spreadsheet with circa 80,000 rows. With the Vlookup function, we demonstrate that this can be done in less than 3 minutes
Views: 178 AnalyzeIT
Excel Conditional Formatting 3: Highlight cell rules - Between, Equal
 
02:59
In this series, Ken Atigari walks you through how you can use the different built-in conditional formatting functions in Excel
Views: 646 AnalyzeIT
MS Excel ActiveX: How to create combobox dropdown list.
 
04:43
Ken Atigari: This video will show you how to create dropdowns using ActiveX comboboxes. You'll learn how to access the ActiveX 'properties' window in order to make changes to the combobox.
Views: 2800 AnalyzeIT
Some UI User Interface tricks in Excel
 
04:22
Ken Atigari shows you a couple of tricks to create fancy Excel user interfaces.
Views: 1114 AnalyzeIT
Excel Hlookup and Row reference function
 
04:26
Ken Atigari shows how the Excel Hlookup function is used to extract values that are horizontally laid out.
Views: 1524 AnalyzeIT
MS Excel ActiveX: Preventing other values being entered into a combobox dropdown list
 
03:04
Ken Atigari: Learn how to manipulate the properties of an ActiveX combo box control in order to prevent it taking any value except for those available in the drop-down list.
Views: 143 AnalyzeIT
Excel Vlookup: Exact and Approximate Matches
 
09:33
Ken Atigari introduces vlookup as an extremely useful function in Excel. He highlights the differences between using exact match and approximate match in vlookup, pointing out that if data is not sorted in ascending order before using approximate match, the retuned values could be erroneous
Views: 1310 AnalyzeIT
Excel for Scorecards, SLA's and KPI's 2
 
08:42
In the second lesson on Performance Management, Ken Atigari talks about SLA's and KPI's in the workplace. The lesson is a prelude to case study examples of designing scorecards using Excel with some Analytical thinking
Views: 1652 AnalyzeIT
Excel Conditional Formatting 1: Highlight cell rules -Greater than
 
04:54
In this series, Ken Atigari walks you through how you can use the different conditional formatting functions in Excel.
Views: 1894 AnalyzeIT
Excel Conditional Formatting 2:  Highlight Cell Rules -Less than
 
04:36
In this series, Ken Atigari walks you through how you can use the different built-in conditional formatting functions in Excel
Views: 188 AnalyzeIT
2 ways to create error bar charts in Excel
 
09:00
Ken Atigari shows two ways to create Excel error bar charts. In one of the methods, he use a line chart with error bars and in the other method, he uses a stock chart.
Views: 228 AnalyzeIT
MS Excel: Introduction to ActiveX  controls.....great for building forms!
 
06:03
Ken Atigari: This is a quick introduction to ActiveX controls in Excel. It is a great tool to get familiar with if you want to start building interactive forms in Excel
Views: 1822 AnalyzeIT
Excel for Scorecards, SLA's and KPI's 1
 
05:24
Performance Management, Balance Scorecards, SLA's and KPI's. Ken gives an insight into how Excel is used as a tool in Performance Analysis
Views: 3478 AnalyzeIT
Heirarchal dropdown lists and multiple substitute functions in Excel
 
13:24
This is a postscript to an earlier video titled "Hierarchical dropdown lists and substitute functions in Excel". In this video, Ken Atigari shows how to nest a substitute function within another substitute function when working with data validation and name manager in Excel.
Views: 2009 AnalyzeIT
Excel Index Match  Function Case Study 2
 
23:19
Ken Atigari shows how to dynamically use Microsoft Excel index and match function together . The index function provides the array that the Excel syntax will refer to, while the Match function provides the row and column numbers that will determine the exact cells in the array that will be pulled by the index function. The case study under consideration is for a "themed review" project in order to assess the quality of data hosted in an Excel database. In addition to Excel Index and Match functions, other Excel functions used include Data validation, Vlookup, Hlookup, Concatenate, Conditional formatting.
Views: 213 AnalyzeIT
Using Concatenate and Ampersand in Excel
 
11:06
Ken Atigari demonstrates how to use the Excel Concatenate function and ampersand to join text strings and numerical values.
Views: 855 AnalyzeIT
Microsoft Excel:  This is how you show charts for hidden cells
 
01:40
Ken Atigari: Some times, you want to hide the data source for charts within the same worksheet. However, when you do so, the chart by default would have no values to present. This video will show you how to configure Excel chart function to be able to pull values from cells that are hidden in the worksheet.
Views: 55 AnalyzeIT
Using Access Database Documenter
 
14:14
So you want to create a data dictionary to document the attributes and validation rules of your Access database. Instead of tediously going back and forth transcribing data from Access datasheet view, Ken Atigari shows you how you can use a function in Access database called the "database documenter" to export the documentation to Excel or a CSV file.
Views: 2949 AnalyzeIT
X Factor 2014 Result Analysis Using Excel
 
14:34
Ken Atigari shows you how you can use excel to analyse and report on the voting results of x factor
Views: 88 AnalyzeIT
System Expiration Analysis Dashboard for Calender and Fiscal Years
 
16:59
Ken Atigari shows you how to innovatively use line charts and drop downs to make dynamic dashboards which visually captures the interplay of Calender and Financial year system expiration dates.
Views: 43 AnalyzeIT
Excel In Business 1: Introduction
 
07:20
Ken highlights the need to have a broad view of Excel in the workplace. He then introduces the viewer to Excel end to end process starting from Excel as database, Excel as an Analysis tool and Excel as a reporting tool .
Views: 49 AnalyzeIT
Excel Index Match Function Case Study 1
 
07:41
Ken Atigari shows how you can use Excel's Index match function in a data cleansing project
Views: 314 AnalyzeIT
Skype Social Media Analysis Case Study
 
22:26
Ken Atigari shows how usage and content analysis can be acheived.
Views: 75 AnalyzeIT
Excel Countif and Countifs function
 
09:57
Ken shows how to use Excel Countif and Countifs functions in global human resource analysis.
Views: 126 AnalyzeIT
Excel In Business 2: Excel as Database
 
03:44
The video argues that Excel can function as either a temporary of permanent database depending on the goal of the project.
Views: 79 AnalyzeIT
Dynamic Excel Hyperlinks for Modeling Systems Use Cases
 
07:50
Ken Atigari demonstrates how to use dynamic Excel hyperlinks when modelling system prototypes. This is useful in Business Analysis practices.
Views: 135 AnalyzeIT
MS Excel: Subtotal function to add unfiltered and unhidden values
 
05:01
Ken Atigari: Some times you want to filter a table and see the sum of some measures in the filtered table. This video will show you how to use Excel's subtotal function "=subtotal(9,A1:A50)" to achieve this.
Views: 64 AnalyzeIT
Excel Sumif and Sumifs function for diversity analysis
 
09:50
Ken shows you how to use the Sumif and Sumifs function within the context of global resource analysis
Views: 54 AnalyzeIT