Course Overview
3h 05m | 39 Videos | 81250 Views | 
Beginner About Microsoft Excel 2011 for MAC Users – Basic
Excel has always been a great partner when you are handling any figures, outputs and other matters. For financial guys, businessmen, corporate or government employees and even for students Microsoft excel has been an effective and easy software to handle and cater all their needs. The basic function of excel 2011 is a must learn subject or course for all people who work via computer. And people now-a-days are more accustomed to Mac series, so our course is specially designed for Mac users who want to work on excel spreadsheet in Mac. The complete online course involves data feeding, calculations, formatting, collaborating, and automating each data you want to work on. Each of the section in this course has been supported by real life examples which you can relate to so that it will help you to have a better understanding. Each functions and methods have been explained in easy step wise process. Microsoft Excel 2011 for Mac users had been designed in such an easy manner that you can easily work on it. This course produces a certification after proper completion of the course. This course will help not only the beginners to learn but will also help the existing users to improvise their skills in a much better way.
Course description
Microsoft Excel 2011 for MAC Users – Basic has been designed for people of all ages who have an urge to learn and apply it in their daily work life. Here you will get to learn all the basics of the excel starting from creating a workbook, saving it, framing it, doing the calculations with formulas, inserting various images, drawing graphs, shapes and charts, setting up various views- vlookup, IF, sumIF and lot more. This course will provide an end to end training on excel, which will make your life easier.
Now let us check what our curriculum includes:
Section 1: Starting with excel
This portion is the beginning part of excel 2011. This chapter will help you to understand the basic of Mac and excel.
- Introduction to basic Mac
Here you will learn about Mac and its functionalities. Mac as a personal computer how it works and how excel is set into it and how you can start working on excel 2011.
- Exploring the window
To start with computer, you need to learn about the complete window in which you will work. You need to know its basic features.
- Exploring the Ribbon
The ribbon bar demonstrates various features, you will get acquainted with those features.
- Customizing the Ribbon
In this section you will get to know how to work with this ribbon and how you can customize them as per your need.
- Setting up program preferences
This section will teach you how to set your program preferences and features. Customizing your requirements will help you to work in a much better way in Mac.
- Using help in Excel
As you are beginner, how you can work on excel, what all you will need for any help in excel.
- Working with workbooks
In this module you will learn how to work with workbook in excel. You will learn all the basics for worksheet.
- Using workbook templates
This module will train you on various templates which you can use in your workbook.
Section 2: Managing Worksheets
Once you understand and grasp the workbook concept, we will start with worksheets.
- Working with cells
Initially you will learn how to start working with cells. Each cell can be customized as per your need.
- Using Autofill to input data
Here you will learn how to use autofill to input data automatically from one sheet to another.
- Create an excel table
In this section you will learn how to create an excel table for your data.
- Using find and replace
Huge data sheet can some errors, so by using find and replace you can change the particular data with correct word or figure.
- Using Data Validation rules
Data validation rules are used to validate your data and compare them as per the requirement.
- Limiting data entry using lists
You can also limit your data entry by using various lists.
- Sorting tools
There are various sorting tools for your data sheet which will help you to get your work done easily.
- Using filter
Filters are used to sort the data which you want to fetch for the time being from huge data sheets. This makes your work easier.
- Splitting and Freezing
Splitting and freezing panes are used to sort certain data and to make the chart easy accessible.
- How to manage worksheets
This section will teach you how you can manage your worksheets.
- Header and Footer 1 and 2
Header and footer is not only used in word but even excel can have it. You can publish your data by inserting header and footer.
Section 3: Using formulas and functions
Excel is used to calculations and to get various output. Formulas and functions are the most critical part of excel. This section is the most important part.
Introduction to formulas and functions
This section will help you to get introduced to basic formulas and functions. Here you will learn:
- How to add a formula
- How to do absolute and relative cell references
- How to use Autosum formula
- How to use Status bar to summarize data
- How to join text using concatenation
- How to use IF function 1 and 2
- How to use SUMIF function
- How to find data using VLOOKUP
- Goal Seek analysis 1 and 2
Section 4: Formatting Worksheets
Worksheets are required to format at times and you need to customize those worksheets as per your requirement.
- Fonts, colors and borders
Making chart is not only the final thing, you need to also learn how to make it look good and presentable. Here in this section you will learn about fonts, colors and borders.
- Number and date formatting
Not only the fonts and colors, you also need to change and format the data as per your requirement. In this subsection you will learn how to format the data and numbers in excel worksheet and how to save it.
- Text Alignment
Text alignment is another part of excel which makes your data look good and it develops a synchronization and enhances the flow of the data.
- to copy cell formats
Excel makes your work easier, so there are option to copy the cell formats, so that you can have the same formulas working in different columns. In this section you are going to learn this.
- Creating cell styles
You can make your chart or figures look beautiful and cell styles are there to support your data’s look as you desire.
- Rule based conditional formatting
At times you need to put conditions and rules to your cell and its figure so that they can work as per your set calculations.
- Top bottom rules and removing conditional formatting
In this subsection you will have a thorough knowledge on top bottom rules and how to remove conditional formatting.
Section 5: Introduction to Charts
In this section you will get introduced to various charts and graphs which will help you prepare your sales data and marketing output. You can also use this data for various other purposes.
- Column charts and their formatting
In this subsection you will learn how to prepare column charts in excel and how to format them as per your needs.
- Other charts
Except these there are also several types of charts which you can prepare in excel you will learn those too.
- COMMON ERRORS 1 and 2
Here you will learn about common errors 1 and 2 and how you can rectify it easily. These are basically formula errors.
What are the requirements/pre-requisites to Microsoft Excel 2011 for MAC Users – Basic training?
This course requires only two things one is Mac computer, excel installed in it and another is internet connection. For Mac users this course is modified and framed in an easy way. You must have passion to learn which will help you to grab the course quickly.
Target Audience for this training
This course is mainly targeted for Mac users who are deputed in various professional fields, be it accounts, human resource, sales, analytical or any other. Excel work book is a dire requirement of people of every field. Our course has been modeled in a methodical way so that people of all ages be students, job seekers or high officials all can learn it very easily.
Here are the list of people who can get benefitted by our course:
- Entrepreneurs
- MBA and BBA students, Graduates and postgraduate students.
- Working professional from various domains- Marketing, sales, operations, accounts, HR
- High professionals- Investment bankers, Finance Analyst, Market Analyst, Research Analyst
FAQs – General Questions
- Is it difficult to learn about Microsoft Excel 2011 Techniques?
Each course is taught here in easy and methodological way which you can grasp in a very easy way.
- Where can be Microsoft Excel 2011 applied?
Microsoft excel can be easily applied in varied places. Be it any department or for any kind of data maintenance, calculation and for to prepare any charts you can easily maintain your data via excel workbook.
- Will I get a certificate once I finish this course?
Yes, you will get an online certificate after accomplishing this course successfully.
- Will this course helpful for my job?
Be any job, excel 2011 has always been an easy and methodical medium to save your data and do all kinds of calculations with simple formulas. Your job is made simple!
- Can I remember everything I learn easily?
Yes, you can, as our course modules are designed with certain set of examples so at any point of time if you require any assistance you can easily go back to your study material which we will provide and you can solve your queries.
- Am I eligible to apply for this course?
Yes, people of any field and of any age can apply for this course. Till now 12052 people had applied for various courses from educba, so you can rely on us without any delay!
Course Testimonials:
Let us see what people has to say about our course:
Jenifer Williams
I was extremely confused about excel and how it works but educba has made it easier, they had taught me step by step with supporting examples which helped me to grab it quickly. Thanks a lot!
Alex
I work as an accountant and except erp software I also need to maintain my data via excel. I got a Macbook for me and I was struggling to understand how excel works here. I got enrolled for this course on my friend’s recommendation and yes, I got highly benefitted. Now I can easily work on excel.
Thomas Jones
Thank you so much for retaining and refurbishing my excel skills! I am working since years on computer, but excel skills had got little dull, so I thought I need to get retrained, so I got in touch with educba and they really taught me very well. I am impressed by their teaching methodology.
Jonny Solley
I am the MD of my company and I need to maintain lot of data which I get regularly from my employees and clients. It was very difficult for me to work on my new Macbook. I got the module training from educba and now I can easily work on my MacBook.
Salem
I work in a CA firm and I have to handle lots of data for various clients who seek accounting service from our company. I need to process salary and pay slip and other audit data for several companies. For me to know every details from excel would have been impossible, and I got help from educba and got complete tutorial on excel.
Career Benefits of this training
Career wise this course has been a great learning to all who working with lots of data per day. Excel 2011 has been a wonderful software to work on in a much faster and easier way. It is helpful to people of all domains. Any new Mac user can go through this course and can easily work on spreadsheets. This course will help you to understand and learn the complete features of Microsoft excel. Knowing such an useful software will enhance your career in a much better way.
| Where do our learners come from? |
| Professionals from around the world have benefited from eduCBA’s Microsoft Excel 2011 for Mac – Beginners Guide courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |
