LearnSomething
LearnSomething Computer Skills CoursesOur computer skills catalog offers training in key office software from intro through advanced levels.
Can’t find what you’re looking for? Please contact Brian Vann
This course introduces users to the Microsoft Office 2000 environment, including several Office applications. It covers basic tasks common across Office applications, such as navigation, starting and exiting programs, and working with files, and covers text editing and printing functions. An in-depth exploration of document formatting is also provided. This course also provides an introduction to Word (word processing), Excel (spreadsheet), Outlook (electronic mail), PowerPoint (presentation), and Access (database), covering the basic functions of each application.
Course duration: 27 hours
This course describes products and features that are new in this version of Office and common to each of the applications in the suite. InfoPath and OneNote are new products introduced in this version of Office. The new features include XML support, Smart Documents, the Research task pane, new collaboration tools, and improved developer tools. The course also covers new features in each Office application.
Course duration: 2 hours
Office 2003 Integration presents a number of common occurrences where information from one application is imported or utilized in another Office 2003 application. Topics include: Creating Business Forms Using Shared Data, Embedding Access Data in Excel, Exporting PowerPoint to Word, Mail Merge with Word, Office Contacts and VCARD Files, PowerPoint Presentations from Word, Sharing Data Using Office Links.
The new Office package is changing the old interface with new features on an interface now known as the Ribbon. How do you find the commands you already know? What new commands are available in Word, Excel, Outlook, PowerPoint, and Access? Take a look at the changes in Office 2007 and learn how to make the most of them.
Course duration: 17 hours
This course is designed to help users prepare for Microsoft Access 2000 MOS certification. It shows how to create, plan, and modify databases and tables in Access 2000. It also covers sorting and filtering, creating queries, forms and reports, and advanced tasks such as saving Access objects as Web pages, importing data, and adding hyperlinks.
Course duration: 22 hours
This course shows how to create, plan, and modify databases and database objects in Access 2002. Sections cover the following topics: understanding relational databases, creating and planning databases, selecting and printing database objects, creating tables, entering records, modifying tables and field properties, using advanced sorts, finding records, applying and removing filters, establishing and managing table relationships, specifying query criteria, creating calculated fields, running multi-table queries, creating forms and reports, implementing standard and calculated controls in both forms and reports, importing data, saving Access objects as Web pages, and performing administrative tasks. This course is procedure focused and assumes that the student is familiar with the mechanics of getting around in a Microsoft Office application.
Course duration: 22 hours
Access 2003 presents instruction for these commonly used tasks: Action and Crosstab Queries, Building Tables, Creating Forms, Creating Queries, Creating Reports, Data Entry and Navigation, Data Protection and Synchronization, Database Objects, Formatting Forms, Importing Data, Introducing Access, Joining Tables, Modifying Forms, Modifying Reports, Modifying the Table Design, Printing Reports, Relational Databases and Working with Records.
Also available in Spanish
This series covers how to use Access 2007 to create, modify, and access databases. It shows the learner how to use the Ribbon-based Access 2007 interface, as well as how to build tables, forms, and reports. Learners will also be able to use queries and filters to sort through data.
Course duration: 9 hours
This course is designed to help users prepare for the MOS Excel Core examination. The course begins with basic Excel tasks, such as entering and editing data, using Find, Replace, and AutoFill, and creating hyperlinks. It also covers locating, opening, and saving files, and using the help function, Office Assistant. Formatting worksheets is covered in detail, including cell and number formatting, adjusting rows and columns, and the use of AutoFormat, styles, and Format Painter. More advanced topics covered include page setup, managing worksheets and data, and creating formulas and functions. An overview of charts and objects, including the Chart Wizard, is also provided.
Course duration: 21 hours
This course is intended as preparation for the Excel 2002 Microsoft Office User Specialist (MOUS) Core Proficiency exam. It introduces Excel's newest enhancements such as task panes for New Documents, Clipboard, Search, and Insert Clip Art; the Ask a Question box; enhancements to Find and Replace; and additional options for pasting and for inserting columns and rows. These new features, along with the productivity tools of previous versions, are taught within the context of working with cells and files, page setup and printing, worksheets and workbooks, formulas and functions, and charts and objects.
Course duration: 22 hours
This course is designed for beginning and intermediate Excel users. This course teaches learners about creating and editing spreadsheets, what's new in the 2003 version, the Excel interface, navigating, editing, and working with text, values, and formulas, printing, formatting, creating charts and databases, and using images and hypertext in a spreadsheet.
Course duration: 26 hours
Also available in Spanish
Also available in Spanish
Also available in Spanish
The Excel 2007 series introduces learners to the newly designed Ribbon interface of Microsoft Excel 2007. It provides a basic introduction to Excel including entering and editing cell data, selecting cell ranges, and formatting worksheet data. Learners will also be able to print worksheets, add comments, complete basic calculations and formulas, and create charts using Excel 2007.
Course duration: 11 hours
The Excel 2007 Advanced series teaches you to apply filters, use formulas and analyze data. You will be able to apply your knowledge to create complex business applications and analyses in Microsoft Excel.
Course duration: 4 hours
This course shows users how to create presentations using PowerPoint 2000. The course is designed to help users prepare for the MOS PowerPoint 2000 Core examination. The basics of PowerPoint, including navigation, templates, copying and deleting slides, and modifying the Slide Master, are presented. Detailed information on layout concepts and inserting text is provided, as well as how to integrate graphics and tables in presentations. Advanced topics covered include adding custom features and formatting, producing notes and handouts, running a slide show, and Web-based features such as hyperlinks, emailing slides, and publishing to the Web.
Course duration: 16 hours
This course teaches the user how to create presentations and edit page layouts. The user will learn how to add text, graphics and tables to slides. The course also discusses customizing individual slides as well as the entire slide presentation. This course is designed for anyone who is interested in learning about the features of PowerPoint 2002.
Course duration: 17 hours
The PowerPoint 2003 course is designed for beginning and intermediate PowerPoint users. This course teaches learners about creating and editing presentations and individual slides, outlining presentations, and printing presentations. The sections also detail topics such as formatting presentations and slides and using masters, color schemes, and templates. Learners will find out how to incorporate pictures, clip art, sound, video, and animation into a presentation. Finally, the sections cover how learners can use PowerPoint with the Internet and when collaborating with others.
Course duration: 25 hours
Also available in Spanish
Also available in Spanish
Also available in Spanish
This course covers the basic features and capabilities of Microsoft Word 2000. It is designed to help users prepare for the MOS Word 2000 Core Exam. It discusses document management techniques, including document creation and display, creating document folders, sending documents through email, and adding hyperlinks. The course also examines how to add, delete, and format text, and various paragraph formatting techniques. Additional topics covered in this course include page formatting, printing, creating tables, and inserting objects into Word documents.
Course duration: 19 hours
This course is designed to teach the student how to use Word 2002 in the Windows XP operating system. This course covers the basics of Word 2002 and continues into the advanced features and procedures. This course teaches all objectives for the Microsoft Word 2002 Core Exam and includes a complete list of these objectives, which the student can print to hard copy.
Course duration: 19 hours
This course is designed for beginning and intermediate Word users. This course teaches users about creating and editing documents, what's new in the 2003 version, the Word interface, navigating, editing, and working with text, spell checking, printing, formatting, styles, templates, borders, tables, columns, lists, and using images in a document.
Course duration: 32 hours
Also available in Spanish
Also available in Spanish
Also available in Spanish
This series shows you how to use Word 2007 to create word processing documents. It shows you how to use the Ribbon-based Word 2007 interface, how to create and format documents, and how to add lists, tables, and images to your documents.
Course duration: 14 hours
This course teaches users how to use the major components of Outlook: Outlook Today, Contacts, Inbox, Calendar, Notes, and Tasks. Topics include navigating between components in Outlook; adding and using information about contacts; reading, sending, customizing, and organizing e-mail messages; scheduling appointments, events, and meetings; and creating tasks and notes.
Course duration: 18 hours
The Outlook 2003 course teaches learners how to use the major components of the Outlook 2003 program: Mail, Calendar, Contacts, Tasks, and Notes. Topics include navigating between Outlook modules and reading, sending, customizing, and organizing e-mail messages. Learners will also find out how to schedule appointments, add and use information about contacts, and create tasks and notes. In addition, the sections will delve into the collaboration, security, and personalization features of Outlook 2003.
Course duration: 25 hours
This course presents concepts for designing and building Web sites. It covers how to plan the structure of a Web site, maintaining the Web site files, and considering the affect that various browsers, monitors, and systems can have on the display of a site. Strategies for making a site download quickly and display well across all browsers and systems are presented, along with creating color schemes, backgrounds, GIF transparencies, and image maps. Additional topics covered in this series include the use of HTML and graphics for formatting and layout, and other useful tools such as frames, animated GIFs, dynamic HTML, JavaScript, QuickTime, Flash, and Shockwave.
Course duration: 16 hours
The Web Publishing and Design with HTML 4.01 and XHTML course teaches you how to make Web sites using HTML 4.01, XHTML, and cascading style sheets. It also provides tips and guidelines to help you design and create effective Web sites, as well as organize their content.
Course duration: 15 hours
The sections in this course teach students to use Microsoft Internet Explorer 6 to browse the Internet and to send and receive electronic mail using Microsoft Outlook Express.
Course duration: 6 hours
This course examines topics related to creating an e-business. After providing an introduction to e-commerce, the course examines how to start an e-business, establishing a business presence, and creating critical applications. Also covered are the legal ramifications of e-commerce, transaction processing and data mining, managing costs, and the logistics of providing customer service and payment processing. Other topics covered include building a strategy to market and advertise your e-business, resource planning, and ongoing business management.
Course duration: 55 hours
This course provides an overview of using Microsoft FrontPage 2000 to create Web sites and pages. It discusses navigation, page and site creation, and publishing to the Web. It also examines working with images, formatting text, using tables and lists, and creating hypertext links to other pages and sites. Additional topics include creating image maps, adding backgrounds, colors, and lines, creating hover buttons, hit counters, and text marquees, and building forms in Web pages.
Course duration: 11 hours
This course presents information on designing Web sites using Macromedia Dreamweaver MX 2004. Topics include an introduction to the interface and the basic concepts of Web design, in addition to procedures for setting up the site, managing the site, creating pages, and inserting basic text, links, and images. The latter part of the course covers advanced topics such as tables and frames, DHTML, behaviors, and forms. Finally the course explains how to upload projects and work with templates.
Course duration: 23 hours
Flash MX 2004 teaches learners how to create animated web graphics and movies from scratch. Learners will be able to apply their knowledge to the creation of both dynamic and interactive Web graphics and applications.
Course duration: 24 hours
This course is designed for beginning and intermediate Photoshop users. This course teaches users about image editing, what's new in version 7, the Photoshop interface, pixels, saving and printing, using the tools, making and modifying selections, layers, creating text effects, filters, color correction, and web graphics.
Course duration: 44 hours
This course provides an overview of the ways JavaScript can be used for adding interactivity to Web content. In addition, frames, cookies, objects, text strings, and a brief history are explained.
Course duration: 14 hours
This course teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.
Course duration: 43 hours
This course provides an introduction to the Extensible Markup Language (XML) and its general format. It introduces the fundamentals of XML, including how to read a basic XML document, the XML document structure, and viewing XML source documents. It shows how to build an XML data document, including creating elements and element modes, naming XML objects, and creating declarations and well-formed documents. Building DTDs is explained in detail, along with creating and managing internal, external, and parameter entities. Additional topics covered in this course include a detailed discussion of the Document Object Model, Cascading Style Sheets (CSS), and XSL Style Language.
Course duration: 15 hours
This course is designed to introduce users to personal computers. Users will learn what a PC is and what an operating system is. They will learn basic computer skills such as turning a computer on, logging on to Windows, and working with files. Users will also learn to identify and use the major components of a PC, both externally and internally, including: disk drives, monitors, mice, keyboards, and printers.
Course duration: 35 hours
The Project 2003 course is designed to help learners with the basics of Microsoft Office Project 2003. This course explains how to set up a project; manage project files; create a task list; schedule tasks; view a schedule; define and assign resources and costs; track a project; and analyze progress and revise a schedule.
Course duration: 30 hours
This course is designed for learners who want to use QuickBooks 2004 as a business accounting system. Tasks covered include using the EasyStep Interview to set up QuickBooks; adding accounts and customers; setting up security; tracking invoices, purchases, and payments; using timesaving features; recording inventory and assets; and working with taxes, equity, and liabilities. QuickBooks is a registered trademark or registered service mark of Intuit Inc., or one of its subsidiaries, in the United States and other countries.
Course duration: 33 hours
Do you need to know the foundations of Crystal Reports XI? Do you want to create reports that sizzle from one or more data sources ASAP? This series will show you how to create, format, and deliver reports that get results in no time. You will learn everything from the basics of getting around in Crystal's report design environment to the subtle nuances of effective report formatting and data visualization through charting and mapping.
Course duration: 4 hours
Can’t find what you’re looking for? Please contact Brian Vann