Leisure Learning Unlimited, Inc.

 

Houston's Source For Lifelong Learning Since 1979

Excel

All MS-Office classes conform to MOUS (Microsoft Office User Specialist) standards. To learn more about MOUS, visit www.microsoft.com/mous. All courseware is Microsoft approved.

MS-Excel--Intro
Topics: Excel Basics--creating/navigating/saving workbooks, setting options, switching views. Working With Data--entering text/numbers/simple formulas, using autosum, using Go To command, spell checking, inserting symbols. Editing A Worksheet--working with ranges, changing width and height, using auto fill, using flash fill. Formatting A Worksheet--formatting text & values, alignment & text wrapping, merging, borders & shading, hiding/freezing rows and columns, page breaks. Page Setup & Printing--defining print area, forcing a worksheet to fit, headers & footers. Formulas & Functions--relative/absolute/mixed references, min/max/count/average functions. Modifying Worksheets--renaming/repositioning/grouping worksheets, using 3-D formulas & references. Note: Prior enrollment in course 0104 or equivalent knowledge is required.
Instructor: LLU Computer Center Staff
Area of Town:  SW Houston: Richmond Ave/Hillcroft
Price:               $169 (text included)
Class #Class Dates
A0115AL1 Sat 9am-4:30pm May 21
A0115AM1 Tues & 1 Wed 6:30-9:35pm Jun 14, 15
A0115AN1 Fri 9:30am-5pm Jul 8
A0115AO2 Wed 6:30-9:35pm Jul 20, 27

To register, click on the Class Number link above. (For online classes only, go to www.ed2go.com/llu or www.yougotclass.org/catalog.cfm/LLU to register.)

MS-Excel Level 2
Topics: Working With Tables--creating/formatting, totaling/sorting data, filtering data & creating custom filters. Working With Charts--creating/moving/resizing charts, changing layout & style, changing chart types & customizing. Working With Graphics--adding clip art/pictures/shapes/WordArt/SmartArt, org charts. Workgroup Collaboration--web page preview, inserting hyperlinks. Financial & Logical Functions--using IF/nested/PMT/FV and AutoCalculate functions. Date & Time Functions--adding a date/date interval, subtracting dates. Managing Workbooks--creating/editing templates, showing or hiding workbook elements, using data consolidation. Note: Prior enrollment in course 0115 or equivalent knowledge is required.
Instructor: LLU Computer Center Staff
Area of Town:  SW Houston: Richmond Ave/Hillcroft
Price:               $169 (text included)
Class #Class Dates
A0116G1 Fri 9:30am-5pm May 6
A0116H1 Wed 9:30am-5pm Jun 8
A0116I1 Sat 9am-4:30pm Jul 16

To register, click on the Class Number link above. (For online classes only, go to www.ed2go.com/llu or www.yougotclass.org/catalog.cfm/LLU to register.)

MS-Excel Level 3
Topics: Importing & Exporting Data--importing external/text/database data, linking & embedding, publishing to web, creating XML web queries. Formatting Numbers--custom formats, conditional formatting. Ranges--using & managing ranges, using vlookup function. Macros--creating/running/editing a macro. Data Analysis Tools--tracing formula precedents, pivot tables. Summarizing Data--subtotals, filters, data validation, text to columns. What-If Analysis--using goal seek/solver, create/display scenarios. Workgroup Collaboration. Note: Prior enrollment in course 0116 or equivalent knowledge is required.
Instructor: LLU Computer Center Staff
Area of Town:  SW Houston: Richmond Ave/Hillcroft
Price:               $169 (text included)
Class #Class Dates
A0117E1 Fri 9:30am-5pm Jun 24

To register, click on the Class Number link above. (For online classes only, go to www.ed2go.com/llu or www.yougotclass.org/catalog.cfm/LLU to register.)

   
3d2dd5ed8258199a5507976f02c77ae0
cart empty:188