Excel for Mac 2011 Essential Training
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
- Customizing the Ribbon
- Formatting worksheets, cells, and cell data
- Sorting and filtering data
- Working with formulas
- Detecting formula errors
- Creating charts
- Importing data
- Inserting objects and graphics
- Using PivotTables
- Recording macros
- Sharing workbooks
- Hi, I'm Curt Frye. Welcome to Excel 2011 for Mac Essential Training. In this course, I'll teach you all the skills you need to use Excel 2011 effectively, whether you're an experienced user upgrading from an earlier version, or someone who's new to Excel. I'll start by showing you how to run Excel, how to navigate the program's user interface, and how to get help within the program or online. Then, I'll teach you how to manage your workbooks and the data they contain, such as by entering data quickly, adding and deleting worksheets, and by sorting and filtering your data so you can focus on just the information you need to make a decision.
The next part of the course covers formulas and formatting. I'll show you how to summarize your data using formulas that range from the simple to the not so simple, and how to make your headings and data stand out. In the last part of the course, I'll teach you some slightly more advanced techniques that let you summarize your data visually using charts, work with external data, manage images and shapes, and even automate routine tasks using macros. In short, I'll show you everything you need to know so you can use Excel 2011 effectively. Thanks again for watching Excel 2011 for Mac Essential Training.
Your time with this course will be time well spent.
Nonprofit Fundamentals87,006 Views
Advanced Topics in MySQL and MariaDB26,094 Views
Running a Design Business: Presentation Skills90,967 Views
iMovie for iOS Essential Training108,599 Views
Digital Product Photography with CINEMA 4D90,226 Views
Illustrator CC 2013 One-on-One: Fundamentals1,678,359 Views
Excel 2013 Essential Training6,279,953 Views
Word for Mac 2011 Essential Training738,669 Views
Foundations of Programming: Fundamentals7,772,051 Views