COMP 1022Q
##### COMP 1022Q - HKUST Study Resources
• 1 Page
• Register Now

School: HKUST

Example of VLOOKUP with Approximate Match This example uses the approximate match feature of VLookup() to generate letter grades for examination marks. If an exact match for the score is not found, the letter grade of the highest score which is less than

• 1 Page
• ###### 03_1022q_sorting_column_without_affecting_others
• Register Now
###### 03_1022q_sorting_column_without_affecting_others

School: HKUST

Ranking of Most Popular Legislative Councilors in Hong Kong This data shows the popularity of some Hong Kong legislative councilors in Jan/April 2012. Ranking Chinese Name English Name 1 2 3 4 5 6 7 8 9 10 Leung Kwok-hung Wong Yuk-man Albert Ho Audrey Eu

• 1 Page
• ###### 03_weight_conversion_with_error_handling
• Register Now
###### 03_weight_conversion_with_error_handling

School: HKUST

A Weight Conversion Program With Error Handling This example illustrates a simple weight conversion program using an Excel formula. The formula has used ISERROR to handle incorrect input. It will display an error message in that case. Please enter your we

• 2 Pages
• ###### 04_1022q_common_logical_functions
• Register Now
###### 04_1022q_common_logical_functions

School: HKUST

Some Commonly Used Logical Functions This example shows 3 commonly used logical functions in cell formulas: AND, OR, NOT. It helps you make the decision "Should I marry him/her?". It considers the important things that help you make the decision whether t

• 1 Page
• ###### 04_1022q_conditional_formatting_failed_subjects
• Register Now
###### 04_1022q_conditional_formatting_failed_subjects

School: HKUST

Advanced Example of Conditional Formatting - Highlighting Scores of Failed Subjects This example shows the highlighting of scores of failed subjects using conditional formatting. In this example, the passing score is 50. The font color of failed scores wi

• 1 Page
• ###### 04_1022q_no_vba_formula_discount_conversion_chinese
• Register Now
###### 04_1022q_no_vba_formula_discount_conversion_chinese

School: HKUST

English to Chinese Discount Conversion, Using Chinese Numbers This example uses a simple Excel formula to convert an English sign showing a discount into another sign showing the same message in Chinese. This example only works correctly when the source n

• 1 Page

School: HKUST

Radar Chart - Hong Kong Monthly Average Temperature A radar chart is used to display changes in values relative to a center point. In this example, a radar chart is used to show the monthly average temperature in Hong Kong for the 2008 to 2010 period. Mon

• 1 Page
###### 04_1022q_sorting_row

School: HKUST

Peoples' Confidence in HK's Future for the 1994 to 2011 Period This example shows the result of sorting the data in a descending chronological order. Confidence Level Confident Hard to Say Not Confident Source: http:/hkupop.hku.hk/ 2011 62.8% 5.5% 31.7% 2

• 3 Pages
###### 04_coffee_comparison

School: HKUST

Comparison of Hot Beverage Prices This example shows the use of ISNA when using VLOOKUP. When the price of a particular beverage cannot be found, a '-' is displayed rather than the '#N/A'. Hot Beverage Starbucks tall grande Pacific Coffee venti tall grand

• 1 Page
• ###### 05_1022q_conditional_formatting_format_only_top_or_bottom_ranked_values
• Register Now
###### 05_1022q_conditional_formatting_format_only_top_or_bottom_ranked_values

School: HKUST

Simple Example of Conditional Formatting Type 3 This is a simple example for the conditional formatting type 3, "Format only top or bottom ranked values". We use this to change the text into red if the cell contains values in the top 3. Value 64 50 30 88

• 1 Page
###### 05_1022q_line_chart

School: HKUST

Line Chart - Number of Sent and Received SMS in Hong Kong A line chart is used to display trends over time or categories. In this example, a line chart is used to show the number of sent and received SMS in Hong Kong for the 2002 to 2009 period. Year 2002

• 1 Page
• ###### 05_1022q_operator_string
• Register Now
###### 05_1022q_operator_string

School: HKUST

Example of String Concatenation This example shows how to concatenate two strings in cell formulas by using & and CONCATENATE. You can enter two strings in cells B5 and B6. The result is shown in cell D9 and D10. Input From User String A David String B Ro

• 1 Page
• ###### 05_1022q_sorting_custom_list
• Register Now
###### 05_1022q_sorting_custom_list

School: HKUST

People's Appraisal of Chief Executive's Job Performance This example shows the result of sorting the entire data using the 'Average Peformance Appraisal column' by a custom list (Very Good, Quite Good, Half-half, Quite Bad, Very Bad). Year of Survey 2005

• 1 Page
• ###### 06_1022q_common_string_handling_functions
• Register Now
###### 06_1022q_common_string_handling_functions

School: HKUST

Some Commonly Used String Handling Functions These examples show 6 commonly used string handling functions in Excel cell formulas: LEN, UPPER, LOWER, LEFT, RIGHT, SUBSTITUTE. Input From User String A Dave is the best instructor! String Old best String New

• 1 Page
• ###### 06_1022q_conditional_formatting_tvb_blog
• Register Now
###### 06_1022q_conditional_formatting_tvb_blog

School: HKUST

Advanced Example of Conditional Formatting - Highlighting the Top 5 Most Frequently Visited Blogs of TVB Artists This example highlights the top 5 most frequently visited blogs of TVB Artists. We use the conditional formatting rule type 3, "Format only to

• 1 Page
###### 06_1022q_stock_chart

School: HKUST

Stock Chart - Hang Seng Index in 2010 A stock chart is most often used to illustrate the fluctuation of stock prices. In this example, a stock chart is used to show the behaviour of the Hang Seng Index in 2010. Month January February March April May June

• 1 Page
• ###### 03_1022q_operator_relational
• Register Now
###### 03_1022q_operator_relational

School: HKUST

Examples of Relational Operators These examples show the most common relational operators in cell formulas. The users can enter two numbers in cells B5 and B6. The results of several comparisons are shown in cells D9 to D14. Input From User Number A 3 Num

• 1 Page
• Register Now

School: HKUST

Example of HLookup Function - Converting Exam Grades into Chinese This example uses HLookup() to convert examination grades into Chinese. HLookup() is very similar to VLOOKUP but has only one difference which searches the value horizontally. Hlookup() is

• 1 Page
###### 01_1022q_no_vba_if

School: HKUST

Example of Cell Function IF This example shows the use of Excel cell function IF. Speed of snail (m/s) Your speed (m/s) 0.001 5 You are faster than a snail!

• 1 Page
• ###### 01_1022q_operator_arithmetic
• Register Now
###### 01_1022q_operator_arithmetic

School: HKUST

Examples of Arithmetic Operators These examples show the basic arithmetic operators in cell formulas. The users can enter two numbers in cells B5 and B6. The results of several calculations are shown in cells D9 to D13. Input From User Number A 3 Number B

• 1 Page
• ###### 01_1022q_single_bar_chart
• Register Now
###### 01_1022q_single_bar_chart

School: HKUST

Single Bar Chart - Worldwide Mobile Phone Sales to End Users in 2010 A bar chart is used to illustrate comparisons among individual items. In this example, a bar chart is used to show worldwide mobile phone sales to end users in 2010. Units (Thousands) 11

• 1 Page
• ###### 01_1022q_sorting_column
• Register Now
###### 01_1022q_sorting_column

School: HKUST

The Titanic's Death Status This example shows the result of sorting the Titanic's death data by the '% Death' column in descending order. People on the Ship Number of Deaths Percentage of Death Economic Status Unknown Third Class Second Class First Class

• 1 Page
###### 01_cell_errors

School: HKUST

Examples of Several Cell Formula Errors This example illustrates several types of cell formula error. Example of #N/A This example illustrates the #N/A error, caused when a look up cannot find the item it is searching for. Name Dog Puppy Tiger Cat Kitten

• 1 Page
• ###### 02_1022q_common_number_functions
• Register Now
###### 02_1022q_common_number_functions

School: HKUST

Some Commonly Used Number Functions This example uses the following 7 cell functions in the cell formulas: SUM, AVERAGE, STDEV, MAX, MIN, RANK, COUNTIF. (In this course, each of the assignments is worth 14% and the final exam is worth 44%. This course is

• 1 Page
• ###### 02_1022q_conditional_formatting_capital_punishment
• Register Now
###### 02_1022q_conditional_formatting_capital_punishment

School: HKUST

Advanced Example of Conditional Formatting - Indicating the Level of Capital Punishment in Each Country This example indicates the level of capital punishment in each country. The background color will be changed according to how many people are executed.

• 1 Page
• Register Now

School: HKUST

Example of VLookup Function - Converting Exam Grades into Chinese This example uses VLookup() to convert examination grades into Chinese. Vlookup() is used to find an exact or approximate value inside a range using the key you have given and returns the c

• 1 Page
• ###### 02_1022q_no_vba_if_else
• Register Now
###### 02_1022q_no_vba_if_else

School: HKUST

The IF ELSE Structure This example shows the extended use of the IF cell function. In this example if the tested condition fails we return something specific, instead of simply returning FALSE. Money in Pocket Cost of Chocolate 90 10 I have enough money t

• 1 Page
• ###### 02_1022q_single_column_chart
• Register Now
###### 02_1022q_single_column_chart

School: HKUST

Single Column Chart - Box Office Income of Movies About China A column chart is used to show data changes over a period of time or to illustrate comparisons among items. In this example, a column chart is used to show the box office income of famous movie

• 2 Pages
• ###### 02_1022q_lookup_chinese_zodiac_using_hlookup
• Register Now
###### 02_1022q_lookup_chinese_zodiac_using_hlookup

School: HKUST

Example of HLookup Function - Finding the Chinese Zodiac Animal For Each Year This example uses HLOOKUP function to find which year belongs to which Chinese Zodiacs animal. Chinese Zodiac (Shngxio, ) is a scheme that relates each year to an animal and its

• 1 Page
• ###### 02_1022q_sorting_more_than_one_column
• Register Now
###### 02_1022q_sorting_more_than_one_column

School: HKUST

Top 10 Richest People in Asia 2010 This example shows the result of sorting the top 10 richest people in Asia 2010 by the 'Nationality' and 'Net Worth (US Dollar)' columns. Nationality Hong Kong Hong Kong Hong Kong India India India India India India Mala

• 1 Page
• ###### 02_weight_conversion_without_error_handling
• Register Now
###### 02_weight_conversion_without_error_handling

School: HKUST

A Weight Conversion Program Without Error Handling This example illustrates a simple weight conversion program using an Excel formula. The formula does not have error handling and therefore will show #VALUE! when the input is not a valid number. Please en

• 1 Page
• ###### 03_1022q_3d_column_chart
• Register Now
###### 03_1022q_3d_column_chart

School: HKUST

3D Column Chart - Hong Kong Resident Educational Attainment A 3D column chart is used to compare data points along two axes. In this example, a 3D column chart is used to show the Hong Kong Resident Population aged 15 and over by quinquennial age group an

• 1 Page
• ###### 03_1022q_conditional_formatting_format_only_cells_that_contain
• Register Now
###### 03_1022q_conditional_formatting_format_only_cells_that_contain

School: HKUST

Simple Example of Conditional Formatting Type 2 This is a simple example for the conditional formatting type 2, "Format only cells that contain". We use this to change the text into red if the cell value <50. Value 64 50 30 88 99 100

• 1 Page
• ###### 07_1022q_2d_clustered_column_chart
• Register Now
###### 07_1022q_2d_clustered_column_chart

School: HKUST

2D Clustered Column Chart - Research Rankings for The Hong Kong University of Science and Technology A clustered column chart is used to compare values across categories and time. In this example, a clustered column chart is used to show the research rank

• 1 Page
• ###### 07_1022q_conditional_formatting_format_only_values_that_are_above_average
• Register Now
###### 07_1022q_conditional_formatting_format_only_values_that_are_above_average

School: HKUST

Simple Example of Conditional Formatting Type 4 This is a simple example for the conditional formatting type 4, "Format only values that are above or below average". We use this to change the text into red if the values are below average. Value 64 50 30 8

• 1 Page
• ###### 1022q_01_cost_of_diets_no_table
• Register Now
###### 1022q_01_cost_of_diets_no_table

School: HKUST

The Cost of Different Types of Diet This example shows the use of relative and absolute referencing in Excel, which works both with and without a table. It calculates the cost of different types of diet. Type of diet Traditional meat diet Meat reduced die

• 1 Page
• ###### 1022q_01_exponential_curve
• Register Now
###### 1022q_01_exponential_curve

School: HKUST

x 0 1 2 3 4 5 6 x*x 0 1 4 9 16 25 36 40 35 30 25 20 15 10 5 0 0 1 2 3 4 5 6

• 1 Page
• ###### 1022q_01_timetable_unformatted
• Register Now
###### 1022q_01_timetable_unformatted

School: HKUST

An Unformatted Timetable This is an example of a timetable. The timetable is not formatted. The cells of the timetable look very boring and unattractive. There are no macros in this example file. My Timetable Monday 0900-0930 0930-1000 1000-1030 1030-1100

• 1 Page
• ###### 1022q_03_cost_of_diets_with_table_and_table_referencing
• Register Now
###### 1022q_03_cost_of_diets_with_table_and_table_referencing

School: HKUST

The Cost of Different Types of Diet This example shows the use of a table and structured referencing, i.e. [name of column], in cell formula. It calculates the cost of different types of diet. Type of diet Traditional meat diet Meat reduced diet Vegetaria

• 1 Page
###### 1022q_03_labelling

School: HKUST

Julia Chan Li Kwong Richard Angel Fong IQ 110 77 90 120 133 108 88 Difference to Average HK IQ 3 -30 -17 13 26 1 -19 Average HK IQ 107 (From http:/en.wikipedia.org/wiki/IQ_and_the_Wealth_of_Nations)

• 1 Page
• Register Now

School: HKUST

Weekly Cost of Living Rent Transport Food Clothes Entertainment Total Dave: $628 Rentingasmallroomin Dave:$60 TaiPoTsai() Walkfromthevillageto Dave: $350 USTeachdaygo MainlyLG7andLG5cos Dave:$60 homeatweekendonly theyarenotexpensive. MongKok. \$130 Dave:

• 1 Page
• ###### 1022q_07_after_auto_creating_names
• Register Now
###### 1022q_07_after_auto_creating_names

School: HKUST

Julia Chan Li Kwong Richard Angel Fong IQ 110 77 90 120 133 108 88 Difference to Average HK IQ Difference to Average World IQ 3 21.8 -30 -11.2 -17 1.8 13 31.8 26 44.8 1 19.8 -19 -0.2 Country Average IQ Average World IQ 107 Hong Kong 106 South Korea 105 Ja

• 1 Page
• Register Now

School: HKUST

Example of a Formula that uses Absolute and Relative Cell References This example shows the use of a formula which uses both relative and absolute cell references. First, the formula in cell G6 was carefully written. Then the cell was copied and pasted in

• 1 Page
• Register Now

School: HKUST

Example of a Formula that uses Absolute and Relative Cell References In this example the formula in cell G6 was written. However, it was not written properly. Then the cell was copied and pasted into the area G6 to J14. Because the formula was poorly desi

• 7 Pages
• ###### 1022q_midterm_review_questions_part_2_f2012
• Register Now
###### 1022q_midterm_review_questions_part_2_f2012

School: HKUST

COMP1022Q Midterm Review Questions Part 2 Conditional Formatting Question Q5) In this question, you need to complete the formula used for conditional formatting. The visual formatting is already set up. You only need to complete the formula for the rule.

• 2 Pages
• ###### recursion_review_question
• Register Now
###### Recursion_review_question

School: HKUST

COMP1022Q Recursion Review Question Here is some VBA code. Option Explicit Dim maxDepth As Integer Sub inputMaxDepth() Dim centerX As Double, centerY As Double, radius As Double centerX = 250: centerY = 350: radius = 128 maxDepth = InputBox("Enter the max

• 5 Pages
• ###### 1022q_midterm_review_questions_part_1_s2013
• Register Now
###### 1022q_midterm_review_questions_part_1_s2013

School: HKUST

COMP1022Q Midterm Review Questions Part 1 Cell Formula and Cell Formatting Q1) Here is a screen dump showing our target result. The chart at the bottom is included only to give you an overview of the data. Page 1 of 5 To achieve this result, you need to e

• Pages
###### 1022q_a1_s2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Assignment 1 Stock Market Prediction David Rossiter and Gibson Lam Lab 1 and Lab 2 Work In lab 1 and lab 2 you worked on stock market prediction At the end of lab 2 you created a chart similar to the on

• Pages
###### 1022q_a2_s2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Assignment 2 Eliza Your UST Counsellor David Rossiter and Gibson Lam Lab 4 Work In lab 4 you made Eliza, a virtual psychologist, using VBA programming In this assignment you need to extend the work that

• Pages
###### 1022q_a3_s2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Assignment 3 Music System David Rossiter, Gibson Lam and Wallace Mak From the first lecture Reminder - Assignments Worth: The first assignment will involve using Excel formulas only (no VBA) The second

• 1 Page
• ###### 18_1022q_doughnut_chart
• Register Now
###### 18_1022q_doughnut_chart

School: HKUST

Doughnut Chart - World Internet Users in 2000 and 2010 Like a pie chart, a doughnut chart is used to show the relationship of parts to a whole; however, it can contain more than one data series. In this example, a doughnut chart is used to show the popula

• 1 Page
###### 17_1022q_pie_chart

School: HKUST

Pie Chart - HKUST Graduates Employment Situation in 2009 A pie chart is used to show the size of items that make up a data series, proportional to the sum of the items. In this example, a pie chart is used to show the HKUST graduates employment situation

• 1 Page
• ###### 08_1022q_conditional_formatting_mr_hong_kong
• Register Now
###### 08_1022q_conditional_formatting_mr_hong_kong

School: HKUST

Advanced Example of Conditional Formatting - Highlighting the Mr. Hong Kongs that Are Taller Than Average This example highlights the Mr. Hong Kongs in 2011 which are taller than average. The height values are changed into red if the cell contains values

• 1 Page
###### 08_1022q_line_chart

School: HKUST

Line Chart - Hong Kong Gas Consumption in 2010 A line chart is used to display trends over time or categories. In this example, a line chart is used to show the gas consumption in 2010. (1 terajoule = 1012 joules) Month January February March April May Ju

• 1 Page
• ###### 09_1022q_conditional_formatting_format_only_unique_or_duplicate_values
• Register Now
###### 09_1022q_conditional_formatting_format_only_unique_or_duplicate_values

School: HKUST

Simple Example of Conditional Formatting Type 5 This is a simple example for the conditional formatting type 5, "Format only unique or duplicate values". We use this to change the text into red if the cell contains a unique value. Value 64 50 99 88 99 100

• 1 Page
###### 09_1022q_scatter_chart

School: HKUST

Scatter Chart - Relationship between Broadband and GDP per Capita A scatter chart is commonly used for displaying and comparing numeric values, such as scientific, statistical and engineering data. A trendline is usually added to depict trends in the data

• 1 Page
• ###### 10_1022q_2d_bubble_chart
• Register Now
###### 10_1022q_2d_bubble_chart

School: HKUST

2D Bubble Chart - World Population in 2009 A bubble chart can be used instead of a scatter chart if your data has three data series. In this example, a bubble chart is used to show the population of individual countries in 2009. Larger circles indicate co

• 1 Page
• ###### 10_1022q_conditional_formatting_flight_schedule
• Register Now
###### 10_1022q_conditional_formatting_flight_schedule

School: HKUST

Advanced Example of Conditional Formatting - Highlighting Duplicate Flight Numbers This example highlights duplicate flight numbers in red. The below table shows the flight arrival schedule on 18 July 2011. Every flight number should be unique. No Excel f

• 1 Page
• ###### 11_1022q_conditional_formatting_use_a_formula
• Register Now
###### 11_1022q_conditional_formatting_use_a_formula

School: HKUST

Simple Example of Conditional Formatting Type 6 This is a simple example for the conditional formatting type 6, "Use a formula to determine which cells to format". We use this to change the number into red if the cell value <60. Value 64 50 30 88 99 100

• 2 Pages
###### 11_1022q_scatter_chart

School: HKUST

1/20 /20 0 0 1/21/20 0 0 1/24 /20 0 0 1/25/20 0 0 1/26 /20 0 0 1/27/20 0 0 1/28 /20 0 0 1/31/20 0 0 2/1/20 0 0 2/2/20 0 0 2/3/20 0 0 2/8 /20 0 0 2/9 /20 0 0 2/10 /20 0 0 2/11/20 0 0 2/14 /20 0 0 2/15/20 0 0 2/16 /20 0 0 2/17/20 0 0 2/18 /20 0 0 2/21/20 0

• 1 Page
• ###### 12_1022q_conditional_formatting_failed_subjects_using_excel_formatting_rule
• Register Now
###### 12_1022q_conditional_formatting_failed_subjects_using_excel_formatting_rule

School: HKUST

Simple Example of Conditional Formatting Type 6 - Highlighting Scores of Failed Subjects This example shows the highlighting of scores of failed subjects using conditional formatting. In this example, the passing score is 50. The font color of failed scor

• 1 Page
###### 12_1022q_surface_chart

School: HKUST

3D Surface Chart - Plotting an Equation A surface chart is used to show a three dimensional surface that connects a set of data points. In this example, a 3D surface chart is used to show the distribution of equation z = sin(x)*cos(y). x -3.00 y 2.00 2.15

• 1 Page
• ###### 13_1022q_conditional_formatting_lottery
• Register Now
###### 13_1022q_conditional_formatting_lottery

School: HKUST

Advanced Example of Conditional Formatting - Highlighting Matching Lottery Numbers This example shows how to highlight the matching lottery numbers using conditional formatting. Two conditional formatting rules have been added. The first rule is to highli

• 1 Page
• ###### 13_1022q_stack_area_chart
• Register Now
###### 13_1022q_stack_area_chart

School: HKUST

Stack Area Chart - Hong Kong Electricity Consumption A stack area chart is used to display the trend of the contribution of each value over time or categories. In this example, a stack area chart is used to show the electricity consumption in 2010. (1 ter

• 1 Page
• ###### 14_1022q_stack_column_chart
• Register Now
###### 14_1022q_stack_column_chart

School: HKUST

Stack Column Chart - Hong Kong Number of Deaths by Leading Causes of Death A stack column chart is used to show the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. In this example, a st

• 1 Page
• ###### 15_1022q_100_stack_area_chart
• Register Now
###### 15_1022q_100_stack_area_chart

School: HKUST

100% Stack Area Chart - HKSAR Number of Deaths by Leading Causes of Death A 100% stack area chart is used to display the trend of percentage contribution from categories over time. In this example, a 100% stack area chart is used to show the number of dea

• 1 Page
• ###### 16_1022q_stack_area_chart
• Register Now
###### 16_1022q_stack_area_chart

School: HKUST

Stack Area Chart - Browser Statistics for the 2002 to 2010 Period A stack area charts are much like line charts, but they are used to display different colors in the areas below the lines. In this example, a stack area chart is used to show the browser st

• 6 Pages
###### Comp Assignment 1

School: HKUST

COMP1022Q Assignment 1 Name: Dennis Ko Student ID : 20117524 The stock : PCCW Ltd (0008.HK) You can click on one of the following links to see the analyses of different moving averages: 3-Day Average 10-Day Average 25-Day Average You can also click on the

• 10 Pages
• ###### 26_1022q_worksheets_f2013
• Register Now
###### 26_1022q_worksheets_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Worksheets David Rossiter Workbook Structure The basic structure of an Excel file is: Workbook Workbook basically means an Excel file 1 or more worksheets Each worksheet has lots of cells You can think

• 12 Pages
• ###### 78_1022q_using_cell_formula_functions_in_vba_f2013
• Register Now
###### 78_1022q_using_cell_formula_functions_in_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Using Cell Formula Functions in VBA Gibson Lam and David Rossiter This Presentation Although we havent seen it before, VBA code can use most of the cell formula functions Cell Formulas VBA Code Cell form

• 13 Pages
• ###### 74_1022q_sorting_no_vba_f2013
• Register Now
###### 74_1022q_sorting_no_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Sorting in Excel David Rossiter and Gibson Lam Sorting in Excel Sorting is one of the most commonly used features of Excel For example, if you want to know the top 5 students with the highest GPA in you

• 16 Pages
• ###### 82_1022q_more_variables_f2013
• Register Now
###### 82_1022q_more_variables_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA More on Variables Gibson Lam This Presentation This presentation discusses two different topics related to the use of variables: Variable Scope The Variant Data Type For variable scope we will focus o

• 22 Pages
• ###### 80_1022q_working_with_selected_cells_f2013
• Register Now
###### 80_1022q_working_with_selected_cells_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Working with the Currently Selected Cells David Rossiter, Oz Lam and Gibson Lam This Presentation In this presentation, we look at the use of the Selection object to get information from the currently se

• 29 Pages
• ###### 20_1022q_useful_handling_f2013
• Register Now
###### 20_1022q_useful_handling_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Useful Ways to Handle Spreadsheets David Rossiter This Presentation You know the basic idea of entering data into Excel and using formulas to process the data In this presentation we look at four areas

• 19 Pages
• ###### 84_1022q_custom_functions_f2013
• Register Now
###### 84_1022q_custom_functions_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Custom Functions Gibson Lam and David Rossiter This Presentation This presentation discusses the use of custom functions Using custom functions is one of the ways to have interaction between Excel cell

• 43 Pages
• ###### 76_1022q_filtering_no_vba_f2013
• Register Now
###### 76_1022q_filtering_no_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Filtering in Excel David Rossiter, Gibson Lam and Eddie Chan What is Filtering? Filtering helps you see what you want to see, and hide the rest For example, you have some candy chips with many different

• 28 Pages
###### 88_1022q_arrays_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Arrays David Rossiter, Eddie Chan and Oz Lam This Presentation In this presentation we will look at: What is an array? Lower bound and upper bound Using Option Base 1 WithEnd With Two dimensional ar

• 56 Pages
• ###### 86_1022q_sorting_and_filtering_vba_f2013
• Register Now
###### 86_1022q_sorting_and_filtering_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Sorting and Filtering Using VBA Gibson Lam and David Rossiter What You Will Learn In this presentation we will look at these: A reminder of sorting and filtering (without VBA) Sorting using VBA Basic

• 46 Pages
###### 90_1022q_objects_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Objects Gibson Lam, David Rossiter and Eddie Chan Overview Object-Oriented Programming is an advanced topic in computer programming In this presentation, we will look at these: Introduction to Object-Or

• 37 Pages
• ###### 64_1022q_basic_gui_control_f2013
• Register Now
###### 64_1022q_basic_gui_control_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Basic GUI Controls Gibson Lam, David Rossiter and Eddie Chan What is a GUI? A graphical user interface (GUI) is a set of visual elements that a user can interact with An example GUI is shown on the righ

• 11 Pages
• ###### 08_1022q_range_references_s2013
• Register Now
###### 08_1022q_range_references_s2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Range References Gibson Lam Stavros Papadopoulos Referring to Cells An Excel formula may contain a function For example, SUM(), MAX(), and AVERAGE() Such functions typically perform operations on sever

• 8 Pages
• Register Now

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Advanced Example of Cell Referencing David Rossiter Writing a Correct Formula In this example we want to know the best country to get profit by buying and then selling lots of iPad 2 tablets The profit

• Pages
• ###### 01_1022q_course_details_s2013
• Register Now
###### 01_1022q_course_details_s2013

School: HKUST

• 12 Pages
• Register Now

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Introduction to Spreadsheets David Rossiter Microsoft Office Before we learn about VBA, we have to know about Microsoft Office, which is the main productivity software used around the world The two main

• 17 Pages
• ###### 70_1022q_more_do_loops_f2013
• Register Now
###### 70_1022q_more_do_loops_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA More on Do Loops Gibson Lam and David Rossiter This Presentation Previously, we have looked at while loops and two kinds of do loops, i.e. WhileWend Do WhileLoop DoLoop While In this presentation, we

• 23 Pages
• ###### 72_1022q_more_for_loops_f2013
• Register Now
###### 72_1022q_more_for_loops_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA More on For Loops Gibson Lam and David Rossiter This Presentation In this presentation we will look at: 1. Using for loops with a step value 2. Nested for loops At the end of this presentation we will s

• 9 Pages
• ###### 30_1022q_introduction_to_vba_f2013
• Register Now
###### 30_1022q_introduction_to_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Introduction to VBA David Rossiter Looking at VBA At this stage we have learned a lot of things about using Excel (without thinking about VBA) Now we will start looking at VBA and how it can be used wit

• 21 Pages
• ###### 11_1022q_cell_formula_basics_f2013
• Register Now
###### 11_1022q_cell_formula_basics_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Cell Formula Basics David Rossiter and Oz Lam In This Presentation We will look at the following topics in this presentation: The basics of cell formulas Arithmetic operators Relational operators Log

• 20 Pages
• ###### 36_1022q_getting_started_on_vba_f2013
• Register Now
###### 36_1022q_getting_started_on_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Getting Started on VBA Gibson Lam Overview We have learned that VBA code runs when Excel receives some kind of trigger, called an event An event can be a keyboard event associated with a macro, or an

• 15 Pages
• ###### 40_1022q_making_basic_decisions_with_vba_f2013
• Register Now
###### 40_1022q_making_basic_decisions_with_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Making Basic Decisions in VBA David Rossiter, Eddie Chan and Oz Lam Using IF in a Cell Let's review the cell formula IF function we saw before IF( condition , some code or value ) Excel will test this

• 8 Pages
• ###### 34_1022q_first_look_at_excel_vba_f2013
• Register Now
###### 34_1022q_first_look_at_excel_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA A First Look at Excel VBA David Rossiter The VBA Trigger There has to be some kind of trigger for VBA code to begin This signal is called an event There are lots of different possible events An exampl

• 35 Pages
• ###### 28_1022q_conditional_formatting_f2013
• Register Now
###### 28_1022q_conditional_formatting_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Conditional Formatting Gibson Lam, David Rossiter and Eddie Chan This Presentation In this presentation we will look at conditional formatting, which is a way to highlight cells based on some conditions

• 9 Pages
• ###### 56_1022q_different_types_of_variable_in_vba_f2013
• Register Now
###### 56_1022q_different_types_of_variable_in_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Different Types of Variable in VBA David Rossiter and Oz Lam Variables We have seen this before David You can think of a variable as a box Name There are different types of box which hold different thin

• 15 Pages
• ###### 38_1022q_msgbox_inputbox_f2013
• Register Now
###### 38_1022q_msgbox_inputbox_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA MsgBox and InputBox David Rossiter and Eddie Chan What is MsgBox? MsgBox is a useful command to show a few words in a small window For example: Here is the VBA code which generates the message: MsgBox

• 13 Pages
• ###### 58_1022q_using_for_loops_f2013
• Register Now
###### 58_1022q_using_for_loops_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Using For Loops David Rossiter, Gibson Lam, Eddie Chan This Presentation Previously we discussed the use of while loops and two types of do loops In this presentation we will introduce for loops COMP102

• 11 Pages
• ###### 60_1022q_error_handling_f2013
• Register Now
###### 60_1022q_error_handling_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Handling Errors David Rossiter and Eddie Chan Errors in Excel VBA Programs It is very difficult to avoid errors while you write and run a VBA program If an error happens, VBA will immediately stop runni

• 28 Pages
• ###### 50_1022q_introduction_to_looping_f2013
• Register Now
###### 50_1022q_introduction_to_looping_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Introduction to Looping David Rossiter, Gibson Lam, Eddie Chan What is Looping? A loop is a set of code which repeats many times Looping is a very useful feature in programming languages such as VBA bec

• 14 Pages
• ###### 62_1022q_functions_and_subroutines_f2013
• Register Now
###### 62_1022q_functions_and_subroutines_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Functions and Subroutines in VBA David Rossiter, Oz Lam and Gibson Lam This Presentation This presentation looks at VBA functions and subroutines Both are used to group together VBA code so that the cod

• 9 Pages
• ###### 66_1022q_handling_a_common_programming_mistake_f2013
• Register Now
###### 66_1022q_handling_a_common_programming_mistake_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Handling a Common Programming Mistake David Rossiter, Eddie Chan and Oz Lam VBA Can Automatically Make Variables Usually, when the VBA engine is running some code and finds an unknown variable name, it w

• 20 Pages
• ###### 42_1022q_macros_and_vba_f2013
• Register Now
###### 42_1022q_macros_and_vba_f2013

School: HKUST

COMP1022Q Introduction to Computing with Excel VBA Macros and VBA David Rossiter This Presentation In this presentation we are going to look at macros: How to make a macro Two types of macro Creating a macro Using a shortcut to run a macro Amending/

Back to course listings