Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This hands-on Microsoft Excel 2011 For Mac course shows you how to effectively use the many features and functions of MS Excel. You will learn to leverage the power of the most important features Excel 2011 has to offer the Apple user, whether you're working in an all-Mac office or needing to coordinate with PC counterparts. Beginning your training with the creation of a sheet to record and monitor sales data, you'll learn the basics of what you can do with spreadsheets. The course then moves on to creating a Profit and Loss report, building a solid understanding of formulas along the way. Moving to score sheets for a sports day, you will discover conditional formatting, lookups, and more. You then create a functional expense claim form and a sales contact management sheet, exploring how you can easily manipulate text, and even create mail merges from within Excel. Whether wanting to beef up your existing Excel skills or learn the program from the ground up this InfiniteSkills Excel course is a tremendous resource with over 50 lessons.
What You Will Learn
- How to create professional quality spreadsheets, workbooks and presentation-ready charts with one of the world's leading office productivity tools.
- How to manipulate and implement data across a wide range of projects.
- How to create fully compatible documents and projects that can be accessed by users working with Office for Mac products as well as Windows counterparts.
Who Should Take This Course
- Anyone who has used Microsoft Excel in the past but wanted a better understanding of its full range of features.
- Anyone who needs an understanding of Microsoft Office software as it applies to a professional work or academic environment.
- Anyone Mac user new to MS Excel wanting a user-friendly guide that introduces the program from the ground up.
What People Are Saying
"I swear I thought excel was the most confusing program ever created...until I started following the simple examples in YOUR course. THANKS."
"Exactly what I needed. Very direct training on each major part of the program. Guy's presentation style is straightforward and effective."
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started|
Working Files - Download These FirstPreview
How Time Saving Are These Excel Projects?Preview
Making Use Of The Project Working Files
An Introduction To Math In Excel
|Section 2: Recording And Monitoring Sales Data|
Creating A New Excel File To Record Data
Saving Your Workbook In The Correct Format
Improve Your Worksheet With Some Formatting
Adding Formulas To Total Rows And Columns
Adding Formulas The Quick Way
Working Out Our Average Consumption
Conditional Formatting To Improve Presentation
Renaming Sheets And Printing
|Section 3: Using Excel For A Profit And Loss|
Creating The Data Collection Sheet
Setting Up A List Using A Named Range
Adding Formula To Create January Profit And Loss
Changing The Data Entry To A Single Sheet
Creating The Other Eleven Months
Using 3D Referencing To Generate The Whole Years Profit And Loss
Exporting To PDF And Emailing To The Accountant
|Section 4: Score Sheets For School Sports Day|
Setting Up The Scoresheet Structure
Looking Up The Competitor Name
A Near Match Lookup For The Event Scores
Using Sheet Replication To Create The Other Event Sheets
Adding Protection To Protect Your Formula
Data Entering The Actual Results
Completing The Competitor Summary
Creating An Error Check For Events Competed
Adding Up The Scores And Ranking For Position
|Section 5: Expenses Claim Form|
Expenses Claim Document Setup And Header Page
Adding The First Month
Displaying The Month Name Instead Of The Number
Creating Destination Lookups For January
Protecting January And Setting Print Options
Creating The Other Eleven Months
Adding A Summary Sheet
Using And Submitting Your Expenses Claim
|Section 6: Sales Contacts Management|
Setting Up Excel To Store Data And Entering That Data
Creating A Unique ID And Freezing Titles
Calculating New Values Using String Manipulation
Sorting Your Excel Database
Filtering Your Dataset
Removing Duplicate Records From Your Dataset
Mail Merge Using Your Dataset
Form View In Excel
Summarizing The Dataset With Pie Charts
|Section 7: Stock Sales Summaries|
Starting The Sales Data Record Sheet
Adding A Sales Chart To The Data
Replicate Sheets To Create Other Sales Regions
Summarizing The Sales Data
Importing CSV Format Sales Data
Adding Some Calculations To The Imported Data
Interrogating The Sales Data With A Pivot Table
Formatting The Pivot Table
Sorting And Filtering The Pivot Table
|Section 8: Next Steps|
Reviewing Absolute And Relative Formulas
What Is The SkyDrive?
Saving An Excel File To SkyDrive
Informing Others That The SkyDrive Document Is There
Excel 2011 Summary
What Is Next?
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.