Imate žicu za učenje?

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

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

Getting Started with Excel 2010

Overview/Description Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and...

Inserting Basic Charts in Excel 2010

Overview/Description Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data. Target Audience Individuals and business users with basic computer literacy Expected...

Moving and Getting Around in Excel 2010

Overview/Description While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features. Target Audience Individuals and business users with basic computer literacy Expected Duration (hours) 1.0 Lesson...

Moving Data and Modifying Worksheets in Excel 2010

Overview/Description The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special...

Reviewing and Protecting Content in Excel 2010

Overview/Description Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools. Target Audience Individuals and business users...

Saving, Sending, and Printing Excel 2010 Workbooks

Overview/Description Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and...

Using Basic Formulas in Excel 2010

Overview/Description Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise. Target Audience Individuals and business users with basic computer literacy Expected Duration (hours) 1.0 Lesson...

Using Basic Functions with Excel 2010

Overview/Description One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that...

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ć?