Corporate Training By Zack Academy - Excel 2011 for Mac

Why Should You Take This Excel 2011 for Mac Course?

The Excel 2011 for Mac group class concentrates on the most common topics that we see in businesses using Excel on a daily basis. By the end of the Excel training course, you will feel confident managing Excel lists, databases, charts, common formulas, formatting, shortcuts and printing. This Excel class is perfect for those who are new to Excel, have been using Excel without any training or need to gain a solid grasp of how to use it effectively.

The Following Course Materials Are Included:

• Custom Printed Manual
• Multiple XLS and XLT examples for in class and after class
• Shortcut sheets
• After class resources

The Following Topics Will Be Covered:

• What you can do with Excel
• Creating and using formulas
• Absolute References
• Formatting
• Advanced Formatting
• Charting
• Databases
• Printing and Page Orientation
• Where to find answers to more complex Excel problems

Syllabus

Lesson 1

• What you can do with Excel
• Cell and Row structure
• Creating an efficient Excel workspace
• Quickly entering data using Auto-fill
• Auto-entries
• Moving Data
• Paste Special

Lesson 2

• Creating formulas manually
• Creating formulas using paste functions and auto functions
• SUM, AVERAGE, COUNT, MINIMUM, MAXIMUM, STANDARD DEVIATION
• Understanding how to use hundreds of predefined functions

Lesson 3

• Absolute References and why they are crucial to you
• Solo Project
• Monthly global allocation

Lesson 4

• Formatting
• Alignment
• Size
• Direction
• Format types
• Borders
• Cell width and height
• Merging cells

Lesson 5

• Advanced Formatting
• Custom formatting
• Conditional Formatting

Lesson 6

• Charting
• Quick and dirty charting when you are in a rush
• Advanced data series charting
• Chart types and when to use them
• Controlling every aspect of chart formatting such as color, axis scales, 3-D views, etc

Lesson 7

• Databases
• How to properly set up an Excel Database to ensure accurate information
• Auto-filtering
• Sorting the database
• Subtotals
• Freezing Rows for easy viewing
• Solo Project
• Database creating and sorting

Lesson 8

• Printing
• Setting print area
• Using the Page Break Preview
• Page Orientation
• Repeating heading rows
• Adding headers and footers to your printing area
• Controlling the annoying “blank pages” and the “stray column” printing problem
• Printing areas that are not next to each other

Lesson 9

• Where to find answers to more complex Excel problems