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 Fundamentals72,169 Views
iMovie for iOS Essential Training101,177 Views
Advanced Topics in MySQL and MariaDB22,183 Views
Digital Product Photography with CINEMA 4D83,202 Views
Running a Design Business: Presentation Skills84,487 Views
Illustrator CC 2013 One-on-One: Fundamentals1,633,291 Views
Excel 2013 Essential Training5,659,883 Views
Word for Mac 2011 Essential Training724,835 Views
Foundations of Programming: Fundamentals6,728,971 Views