Course Length:
Delivery Methods: Available for private class only
- Create basic worksheets using Microsoft Excel 2016.
- Perform calculations in an Excel worksheet.
- Modify an Excel worksheet.
- Modify the appearance of data within a worksheet.
- Manage Excel workbooks.
- Print the content of an Excel worksheet.
- Learn how to use handy features new in 2016.
In this Introduction to Microsoft Excel 2016 for Mac training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.
Target Audience: Students who have little or no familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this course in the 2016 interface.
Modern workplace training. Learn how to get more work done, from anywhere on any device with Microsoft 365 and Windows 10. Discover how industry professionals leverage Microsoft 365 to. The only complete course for the Apple Mac version of Excel 2019. Books and ebooks are available for all levels of ability. Download Basic Skills for free! Publishers of the world’s most comprehensive and up-to-date Excel tutorials. Excel tutorials.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.
- Creating a Microsoft Excel Workbook
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- Changing the Order of Worksheets
- Splitting the Worksheet Window
- Closing a Workbook
- Exercise: Creating a Microsoft Excel Workbook
- The Ribbon
- Tabs
- Groups
- Commands
- Exercise: Exploring the Ribbon
- The Backstage View (The File Menu)
- Introduction to the Backstage View
- Opening a Workbook
- Exercise: Open a Workbook
- New Workbooks and Excel Templates
- Exercise: Select, Open and Save a Template Agenda
- Printing Worksheets
- Exercise: Print a Worksheet
- Adding Your Name to Microsoft Excel
- Managing Workbook Versions
- The Quick Access Toolbar
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog Box
- Adding Ribbon Commands or Groups
- Placement
- Exercise: Customize the Quick Access Toolbar
- Entering Data in Microsoft Excel Worksheets
- Entering Text
- Expand Data across Columns
- Adding and Deleting Cells
- Adding an Outline
- Adding a Hyperlink
- Add WordArt to a Worksheet
- Using AutoComplete
- Exercise: Entering Text and Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
- Exercise: Entering Numbers and Dates
- Formatting Microsoft Excel Worksheets
- Selecting Ranges of Cells
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Exercise: Customize a Workbook Using Tab Colors and Themes
- Adding a Watermark
- The Font Group
- Exercise: Working with Font Group Commands
- The Alignment Group
- Exercise: Working with Alignment Group Commands
- The Number Group
- Exercise: Working with Number Group Commands
- Using Formulas in Microsoft Excel
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas and Functions
- Displaying Formulas
- Relative, Absolute, and Mixed Cell References
- Exercise: Working with Formulas
- Working with Rows and Columns
- Inserting Rows and Columns
- Deleting Rows and Columns
- Transposing Rows and Columns
- Setting Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
- Exercise: Working with Rows and Columns
- Editing Worksheets
- Find
- Find and Replace
- Exercise: Using Find and Replace
- Using the Clipboard
- Exercise: Using the Clipboard
- Managing Comments
- Adding Comments
- Working with Comments
- Finalizing Microsoft Excel Worksheets
- Setting Margins
- Setting Page Orientation
- Setting the Print Area
- Print Scaling (Fit Sheet on One Page)
- Printing Headings on Each Page/Repeating Headers and Footers
- Headers and Footers
- Exercise: Preparing to Print
- Microsoft Excel Features that Were New in 2013
- One Workbook Per Window Feature
- Using Flash Fill
- Exercise: Using Flash Fill
- Features New in 2016
- Tell Me
- Smart Lookup
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Excel class:
- Familiarity with using a personal computer, mouse, and keyboard.
- Comfortable in the Mac environment.
- Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors
Fully updated for the new Jan 2021 semi-annual release
For over fifteen years, large corporations, government departments, schools, colleges and the armed forces have used Smart Method® classroom courses to train their employees.
We’ve now published the same materials as a free e-book. This means that your learning success will be guaranteed if you invest five hours (or less) completing the lessons in this book.
The free Excel 365 tutorial is also available for Excel: 2016, 2019,2016 for Apple Mac and 2019 for Apple Mac.
Functions
Create functions easily using Forumula Auto-complete
AutoFill
Understand everything there is to know about AutoFill including text and numeric series, adjusting formulas, custom fill series and linear and exponential series.
Flash Fill
Understand everything there is to know about Flash Fill including manual and automatic Flash Fill methods, splitting de-limited text, using multiple-examples and concatenating text.
Printing
Understand Excel's vast array of printing options.
Mike Smart is the founder and CEO of The Smart Method. During Mike’s long career as an IT consultant, Mike specified, designed and delivered IT solutions for large corporations all over the world. In 2002 Mike decided to specialize in IT training and founded The Smart Method.
In 2008 Mike realized that he could only ever teach a few thousand students in his classroom courses but could help millions of students by producing his Excel courses in book form. His first Excel books (covering Excel 2007) rapidly became best sellers and his books have topped best seller lists ever since.
Would definitely recommend. I am newbie with excel. This is so wonderfully written, easy to understand and very informative. The text in which it is written is awesome, no faff, no pink and fluffy, no waste of time. Brilliant Book.
This is probably the best training manual I have ever read. I find most manuals too wordy and quite honestly tedious. Mike Smart wins outright on several points. Each main topic is broken down to lessons on two facing pages one advantage is that if you have a spare 10 to 15 minutes you can complete a lesson with ease.
Our books provide a route to become a true Excel guru
If you aspire to become a true Excel guru, we also have Essential Skills and Expert Skills books in this series that will teach you very advanced features such as:
Free Excel For Mac Tutorial
Ms Excel For Mac Tutorial
- Power Pivot, Power Query (Get & Transform) and Power Maps (3-D Maps)
- DAX calculated columns and measures.
- Data Modeling, OLAP and Business Intelligence.
- Creating an OLAP star-schema data model from an OLTP database.
2011 Excel For Mac Tutorial
Hardly any Excel users (even top professionals) really understand the guru-level skills listed above!