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:  Greenway Plaza Area: Richmond/Kirby
Price:               $169 (text included)
Class #Class Dates
A0115AD1 Tues 9:30am-5pm Feb 16
A0115AE1 Mon & 1 Thurs 6:20-9:35pm Feb 22, 25
A0115AF1 Sat 9am-4:30pm Mar 5
A0115AG1 Mon & 1 Wed 6:20-9:35pm Mar 14, 16
A0115AH1 Sat 9am-4:30pm Apr 2
A0115AI1 Fri 9:30am-5pm Apr 15
A0115AJ1 Mon & 1 Wed 6:20-9:35pm Apr 25, 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:  Greenway Plaza Area: Richmond/Kirby
Price:               $169 (text included)
Class #Class Dates
A0116D1 Mon & 1 Wed 6:20-9:35pm Mar 7, 9
A0116E1 Wed 9:30-5pm Mar 30
A0116F1 Sat 9am-4:30pm Apr 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:  Greenway Plaza Area: Richmond/Kirby
Price:               $169 (text included)
Class #Class Dates
A0117B1 Mon & 1 Wed 6:20-9:35pm Feb 15, 17
A0117C1 Tues & 1 Thurs 6:20-9:35pm Mar 15, 17
A0117D1 Sat 9am-4:30pm Apr 23

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.)

   
491f1519a8ef1d073e85f55577484a91
cart empty:188