Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Microsoft Excel for Mac 2011: Getting Started $74.95
Microsoft Excel for Mac 2011: Applying Basic Data Formatting $74.95
Microsoft Excel for Mac 2011: Navigating the Interface and Viewing Workbooks $74.95
Microsoft Excel for Mac 2011: Moving Data and Modifying Worksheets $74.95

Bundle Price: $169.00
Total Savings: $130.80


Microsoft Excel for Mac 2011: Getting Started

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 Invoice template. This course explores these topics and many other basics of Excel 2011, including opening the application, creating new spreadsheets, and entering data both manually and through Excel's automatic features.
  • start Excel 2011 and open a workbook from the Excel Workbook Gallery
  • recognize the functions of main Excel interface elements
  • open a workbook from within the Excel application
  • enter data in a worksheet
  • open a workbook
  • enter data into a workbook
  • customize Excel interface elements

Microsoft Excel for Mac 2011: Applying Basic Data Formatting

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 quickly see the top 10 values in a range. This course also explains the various options for number formatting in Excel for Mac 2011.
  • apply basic text formatting
  • apply and copy cell formatting
  • align text within cells
  • apply number formats
  • apply basic conditional formatting
  • format text and cells
  • format cells that meet a specified condition
  • apply number formats to worksheet data

Microsoft Excel for Mac 2011: Navigating the Interface and Viewing Workbooks

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.
  • navigate the Excel interface
  • get Help on Excel tasks or commands
  • change your view of a worksheet
  • work with windows in Excel 2011
  • work with panes in Excel
  • navigate the Excel interface
  • alter the worksheet view
  • use windows and panes to view different parts of a worksheet

Microsoft Excel for Mac 2011: Moving Data and Modifying Worksheets

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.
  • copy and move data
  • use paste options to preview and control how data displays
  • insert and delete rows, columns and cells
  • format rows and columns
  • insert and delete worksheets
  • copy or move worksheets
  • copy and paste data
  • insert and modify rows and columns
  • copy and modify worksheets
Register Now
Microsoft Office: Beginning Excel for Mac 2011 Part 1 e-learning bundle
  • Course ID:
    252404
  • Duration:
    4 hours
  • Price:
    $169