Macros

Sir Tom taught us about Macros.
Macros can minimize the effort needed to do in an excel file.

Examples:

Charts

Sir Tom taught us about Charts.

A simple chart in Excel can say more than a sheet full of numbers. As you'll see, creating charts is very easy.

Types of Charts:

1.Bar Graph

2.Line Graph

3.Column Graph

Example:

Result:

Formulas

Sir Tom taught us about Formulas.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

Functions

Sir tom taught us about the Excel Functions.

Uses:

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.

2 Logical: Learn how to use Excel's logical functions such as the IF, AND and OR function.

3 Cell References: Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

4 Date & Time: To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.

5 Text: Excel has many functions to offer when it comes to manipulating text strings.

6 Lookup & Reference: Learn all about Excel's lookup & reference functions such as the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE function.

7 Financial: This chapter illustrates Excel's most popular financial functions.

8 Statistical: An overview of some very useful statistical functions in Excel.

9 Round: This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

10 Formula Errors: This chapter teaches you how to deal with some common formula errors in Excel.

11 Array Formulas: This chapter helps you understand array formulas in Excel. Single cell array formulas perform multiple calculations in one cell.

Conditional Formatting

Sir Tom taught us about Conditional Formatting.

Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule. For example, a conditional formatting rule might be: "If the value is less than $2000, color the cell red." By applying this rule, you'd be able to quickly see which cells contain values under $2000.

Example:

Logical Operations

Sir Tom taught us about Logical Operations.

• AND(logical1,logical2,...) tests whether the logical arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to thecell. If any are FALSE, the AND function returns FALSE.
• IF(logical_test,value_if_true,value_if_false) tests whether thelogical_test expression is TRUE or FALSE. If TRUE, the IF function returns the value_if_true argument. If FALSE, the IF function returns thevalue_if_false argument.
• NOT(logical) tests whether the logical argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. IF FALSE, the NOT function returns TRUE.
• OR(logical1,logical2,...) tests whether the logical arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.
• FALSE() takes no argument and simply enters logical FALSE in its cell.
• TRUE() takes no argument and simply enters logical TRUE in its cell.

Example:

Cell Reference

Sir Tom taught us about the Cell Reference.

Relative Reference -cells adjust when copied
 Absolute Reference- cells do not adjust when copied,uses a dollar sign ($)

Mixed Reference

-Sometimes we need a combination of relative and absolute reference (mixed reference).

Excel Solver

Sir Tom taught us about the Excel Solver.It is about Areas,Hypotenuse,Quadratic Equations and more.

Example:

Parts of Microsoft Excel

Sir Tom taught us about the Parts of Microsoft Excel.

3rd Quarter Experiences in Computer Science 1

List Of Topics:
1.Parts of Microsoft Excel
a.Shortcut keys 
2.Excel Solver
3.Cell Reference
4.Logical Operations
5.Conditional Formatting
6.Functions
7.Formulas
8.Charts
9.Macros


My Experience this Quarter:
                This Quarter,it is all about Microsoft Excel.I felt quite more confident this quarter because there is more math involved in it.I think that I have done great this quarter.I have passed all the requirements this 3rd Quarter.I have learned a lot this quarter,all about Microsoft Excel.Even though there are lots of hurdles in the way,I still managed to jump over it.Thank you Sir Tom to all of your efforts and hard works this quarter.I know this will help me a lot in the future.Thank you so much!!!