image  
 

Excel Intermediate - $189

This class is intended for:

PC/Windows Users: Excel 2010-2013-2016-2019-365
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 1 Day

ADVANCED FORMULAS:

Create more complex formulas using:

*Formula Syntax
Example: =SUM('[Main-File.xlsx]Totals'!$G$3:$G$16)

*Absolute Cell References
Example: =B5*$D$2

*Order of Operations
Example: =((D6+E6)*F6)

3-D FORMULAS:

Combine data from different sheets located within the same workbook (file).



LINK WORKBOOKS & CONSOLIDATE DATA:

Link cells from different workbooks (files) so you always see the latest information with automatic updates.


VALIDATION:

Use Validation to improve speed and accuracy of data entry, set limits on what can be entered, add drop-down lists and pop-up explanation boxes.

PIVOT TABLE BASICS:

Use Pivot Tables to summarize large spreadsheets. We also offer a separate in-depth class on Pivot Tables.



GROUP / OUTLINE / SORT / FILTER / SUBTOTAL DATA:

Apply multiple Sorts and Filters, Subtotal data, Group and Outline spreadsheets.

FORMULA AUDITING:

Evaluate formulas to discover and resolve errors, view the relationship between different cells, etc.

TEMPLATES:

Create and edit a Workbook Template so you can base new spreadsheets on it - complete with formulas, functions, AutoSum, titles, borders, etc.

CONDITIONAL FORMATTING:

Use Conditional Formatting to make important numbers stand out. Examples: make negative numbers turn red automatically, or change the background color of cells to highlight certain ranges of values.



PASSWORD PROTECT ALL OR PART OF WORKBOOK:

Password Protect an entire workbook (file) or individual cells within a worksheet so they cannot be edited.



Excel Class Information



Call: (858) 578-9476
Click to Contact Us
Click to View Map / Directions


 
 
 
 
 
 
Computer Training Classes

Excel Intermediate - $189 (1 Day)

ADVANCED FORMULAS:

Create more complex formulas using Absolute Cell References and the Order of Operations. Learn the proper use of Formula Syntax - Example: =SUM('[Sales.xlsx]January'!B4:E4.B5:E5).

3-D FORMULAS:

Combine data from different sheets located within the same workbook (file).

LINK WORKBOOKS & CONSOLIDATE DATA:

Link cells from different workbooks (files) so you always see the latest information with automatic updates.

VALIDATION:

Use Validation to improve speed and accuracy of data entry, set limits on what can be entered, add drop-down lists and pop-up explanation boxes.

PIVOT TABLE BASICS:

Use Pivot Tables to summarize large spreadsheets. We also offer a separate in-depth class on Pivot Tables.

GROUP / OUTLINE / SORT / FILTER / SUBTOTAL DATA:

Apply multiple Sorts and Filters, Subtotal data, Group and Outline spreadsheets.

FORMULA AUDITING:

Evaluate formulas to discover and resolve errors, view the relationship between different cells, etc.

TEMPLATES:

Create and edit a Workbook Template so you can base new spreadsheets on it - complete with formulas, functions, AutoSum, titles, borders, etc.

CONDITIONAL FORMATTING:

Use Conditional Formatting to make important numbers stand out. Examples: make negative numbers turn red automatically, or change the background color of cells to highlight certain ranges of values.

PASSWORD PROTECT ALL OR PART OF WORKBOOK:

Password Protect an entire workbook (file) or individual cells within a worksheet so they cannot be edited.

contact us

register for class in san diego

class schedule

class location

Contact Us Map / Directions Schedule Home Page