Excel for Mac Basics
If you have worked in Excel before but not on a Mac, this is the perfect course for you. If you have never used Excel before and you’re starting with the Mac version, this course is still the right choice. In the Excel for Mac Basics course, we’ll show you how to get started with Excel and use its most popular features. Learn the anatomy of a spreadsheet, how to insert data and make your data appealing and easy to read. Using Excel, you can do almost anything – crunch numbers, create lists, store data, edit budgets, and more.
- Getting Started with Excel
- Excel for Mac VS Excel for PC
- Data Entry Shortcuts
- Using Formulas and Functions
- Copying Formulas and Functions
- Using Relative Absolute, and Worksheet Reference Formulas
- Modifying Cells, Columns, and Rows
- Search and Replace and Spellcheck
- Applying Text Formatting
- Number Formats and Cell Alignment
- Styles and Themes
- Applying Conditional Formatting
- Creating a Template
- Preview a Workbook
- Setting Page Layout and Printing a Workbook pt. 1
- Setting Page Layout and Printing a Workbook pt. 2
- Working with Worksheets
- Using Custom Views
