Imate žicu za učenje?

Access 2010 Macros and VBA

Overview/Description Using Access macros and Visual Basic for Applications (VBA) code, you can easily add functionality to a database to suit your business needs. This course provides an introduction to programming in Access 2010 and explores when to use macros or VBA code to automate processes. It demonstrates how to create and modify different types of macros as well as how to specify actions, conditions, and event handlers. Target Audience A broad range of business users Expected Duration (hours) 1.0 Lesson ObjectivesAccess 2010 Macros and VBA create macros execute macro actions...

Adding Images to Presentations in PowerPoint 2010

Overview/Description Inserting images, such as photographs, clip art, and shapes, into your PowerPoint 2010 presentation can help to capture and keep the attention of your audience. This course will show you how to insert, format, and apply special effects to your images so that they provide the maximum impact for your presentation. You will learn how to create a photo album and create a presentation that effectively displays your favorite photos. In addition, you will be shown how to use the new built-in screen capture tool that enables you to capture and embed screenshots of other programs...

Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010

Overview/Description Word 2010 offers you a variety of tools that allow you to insert navigation and reference materials into a document. With heading styles applied to your document, you can easily construct a table of contents; you can also insert footnotes and endnotes, and you can quickly link to web pages, shared files, or other sections of a document using bookmarks. This course explores all of these topics, and discusses how to use each feature to improve the readability of your documents. Target Audience Individuals and business users with basic computer literacy and some experience...

Adding Visuals, Themes, and Styles to Excel 2010 Workbooks

Overview/Description Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010. Target Audience Individuals and business users with basic computer literacy Expected Duration (hours) 1.0 Lesson...

Advanced Importing and Exporting with Access 2010

Overview/Description Microsoft Office Access 2010 offers several advanced options for importing and exporting data. With Access 2010 you can link to, or import data and objects from external sources, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. You can also export data and objects from an Access 2010 database to a variety of external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources in Access 2010. Target Audience A broad range of business users...

Analyzing Data with What-if Analysis in Excel 2010

Overview/Description Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results. Target Audience End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level...

Applying Basic Data Formatting in Excel 2010

Overview/Description Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010. Target Audience Individuals and business users with basic computer...

Automating Excel 2010 Tasks Using Macros

Overview/Description To automate repetitive tasks, Excel 2010 provides a time saving feature known as a macro. These small programs, created using either a simple macro recorder or by using the more complex VBA language, allow you to record the numerous steps involved in accomplishing a task so that they can be played back automatically when the macro is run. This results in time savings and increased efficiency in day-to-day tasks. This course will introduce you to macros in Excel and show you how to leverage their power to make you work with Excel easier. Target Audience End users seeking...

Collaborating and Sharing Presentations in PowerPoint 2010

Overview/Description Today people can collaborate on the development of PowerPoint presentations in new and exciting ways. With the proper technological infrastructure in place, PowerPoint has the capability of allowing multiple people to work on the single presentation at the same time. An alternative to co-authoring a presentation with other team members is to send the presentation as an e-mail attachment, save it to a web site, burn it on a CD, or broadcast it live over the Internet. To simplify the process of reviewing and accepting or rejecting changes, you can now merge the reviewed...

Creating and Formatting Tables in Word 2010

Overview/Description Word 2010 has a robust set of tools that allow you to create, style, and format tables in your documents. This course explores the various methods of inserting tables in Word documents, including selecting a layout from a list of preformatted tables, choosing a table size by selecting a layout from a dynamic grid, and by configuring table settings to match the number of columns and rows that you require. It also discusses using table styles to enhance the appearance of tables and changing the layout of tables. Target Audience Individuals and business users with basic...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?