Vi ste ovdje
Overview/Description
Excel 2011 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 alignment and formatting features. This course explores the processing of formatting cells and text, using basic formatting options such as bold and underline, and tools such as the Format Painter. The course also shows you how to align text in a worksheet and how to set certain conditions, that when met, change the appearance of the data â for example you can format data to...
Overview/Description
Excel for Mac 2011 is the newest version of Microsoft's comprehensive spreadsheet tool for Macintosh systems that offers features supporting a wide range of data entry, formatting, organization, and analysis methods. The new ribbon menu arranges the many features of Excel into related tabs, making it easy to quickly access the ones you need. The Excel Workbook Gallery contains a variety of visually appealing templates that simplify file creation by speeding up the styling and formatting processes, and oftentimes adding useful features such as a Total row in a pre-built...
Overview/Description
Charts make data easier to understand by providing a clear diagrammatic representation of your information. By using Excel for Mac 2011's strong charting capabilities, you can create attractive and organized representations of worksheet and workbook data, and you can easily insert and customize charts to suit your needs. This course demonstrates how to effectively insert and edit charts in Excel 2011. It explores the abundance of available chart types such as column, pie, and bar charts, and the best use of each type. The course also shows how to modify the layout and...
Overview/Description
Excel for Mac 2011 enables you to produce intuitive and attractive workbooks, and lets you rearrange and move data within the workbooks and worksheets easily. This course explores methods of copying and moving data within a worksheet. It also demonstrates how to modify the layout of a worksheet by adding, removing, and resizing rows and columns. In addition, the course examines ways of inserting new worksheets, deleting worksheets, and rearranging worksheets within a workbook.
Target Audience
Any individuals and business users with basic Mac computer literacy.
Expected...
Overview/Description
While it can often seem complicated and daunting, navigating the Excel 2011 interface isn't all that difficult. This course will show you how to move around the Excel interface using a variety of keys on your keyboard, and by using menu and ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets and explores how you can access Excel's Help features.
Target Audience
Any individuals and business users with basic Mac computer literacy.
Prerequisites
None
Expected Duration (hours)
1.0
Lesson ObjectivesMicrosoft Excel for...
Overview/Description
Excel for Mac 2011 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 for future use, and in many instances, print it to save a hard copy or share with someone else. This course describes these Excel features and explains how to use them to increase your efficiency and productivity, including sharing your workbooks with colleagues using SkyDrive and SharePoint.
Target Audience
Any individuals and business users with basic Mac computer literacy.
Expected Duration (hours)
1.0...
Overview/Description
Formulas are the building blocks of data calculation in Excel for Mac 2011. Being able to use formulas to perform everything from easy to 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 formulas, demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise when using formulas in Excel for Mac 2011.
Target Audience
Any individuals and business users with basic Mac computer literacy.
Expected Duration (hours)
1.0...
Overview/Description
One of the great features of Excel for Mac 2011 is its ability to perform a wide variety of functions to make your use of Excel easier. Functions are built-in formulas that save you time by allowing you to choose one that suits your needs rather than creating a complex formula from scratch. This course introduces you to the components of functions, and how and when to use a particular function in the most efficient and practical way.
Target Audience
Any individuals and business users with basic Mac computer literacy.
Expected Duration (hours)
1.0
Lesson...
Overview/Description
Microsoft Outlook for Mac 2011 enables you to send and receive e-mails in an intuitive manner, using a streamlined interface. This course explores the Outlook for Mac interface, including such key features as the ribbon, menu system, and Navigation Pane. The course also teaches you how to open an e-mail, how to add contacts to an e-mail, and how to reply to a message.
Target Audience
Any individuals and business users with basic Mac computer literacy and a fundamental understanding of e-mail concepts.
Expected Duration (hours)
1.0
Lesson ObjectivesMicrosoft Outlook for...
Overview/Description
Outlook for Mac 2011 includes a Contacts feature that houses easy-to-access personal information about people and businesses. You can add your own contacts and include such information as a person's e-mail address, name, phone number, and even a photo to give the contact a personal feel. You can easily import contacts from other files and applications, and export them from Outlook just as efficiently. This course explores these areas of contact management in Outlook for Mac 2011, and includes how to add contacts, contact groups, and arrange contacts.
Target Audience
A...
- 1 od 3
- ››