If you work in the business world, you probably have used Excel to create spreadsheets. Most people are familiar with the basic functions of Excel since it has been around for several years. However, many people admit that their knowledge is extremely limited and they would like to learn more. Instead of asking one of your coworkers every time you need to create a chart or find a large sum, here are 5 free resources to expand your knowledge and get you Excel-savvy.
1. Microsoft's Excel Training Center
Since the people at Microsoft created Excel, they are quite versed on how to operate the program. They have an Office Training Center for Excel that features videos and tutorials for current versions of Excel as well as for older versions. Resources are divided up by a user’s ability including beginner, intermediate, and advanced. More information can be found here: https://support.office.com/en-us/office-training-center?ms.officeurl=training.
2. The Spreadsheet Page
This site was created by John Walkenbach, an Excel expert who has written more than 60 books on Excel. He has also written 300 articles for various computer publications. Under the Excel Tips tab, he gives useful pointers on charts, graphics, formatting, and formulas. You can learn how to work with fractions or even how to unlink a pivot table. More information can be found here: www.spreadsheetpage.com.
MrExcel.com is a large online forum that is dedicated to answering questions from users. Its message board is continuously monitored by Excel experts. You can choose from a variety of categories including products, questions, or announcements. The site also features a library of Excel books. Excel consultants are available for hire if you have a unique situation. The online forum can be found here: www.mrexcel.com/forum/forum.php.
4. EdX Excel Courses
If you are looking for a course rather than a tutorial, EdX does a great job of providing more formal education. EdX provides education for people in different counties and works as a nonprofit. They offer Excel training sessions that users can complete at their own pace. The courses are free, however for a small fee, the user will receive a certificate with the institution’s logo if they choose a course labeled as “verified.” This may be helpful on a resume. If you don’t need the certificate, you can still take the course for free. The courses can be found here: www.edx.org/course/?search_query=excel&language=English.
5. Khan Academy
This site offers free video tutorials on various subjects including math, history, grammar, etc. It also has several videos about Excel. You can learn about linear models, SQL basics, marginal costs, and interpreting computer regression models. More information about the Excel tutorials can be found here: https://www.khanacademy.org/search?page_search_query=microsoft%20excel.
Learn about economics and business principles while approaching investments from a biblical perspective, recognizing that we are stewards for God's resources. The finance program teaches you about economics, investments, risk analysis, and how to strategize to maximize wealth for individuals and for organizations. This degree prepares you for work in small or large businesses, nonprofits, financial institutions, security firms, government agencies, and more.
Gain an understanding of financial analysis, tracking personal expenses, and financial planning with the personal money management and planning minor.
We are here to guide and inspire students and alumni to thrive in career and professional development. A supportive staff with relevant resources, we coach, advise, and connect students with...Read More