Learn how to use Excel can be valuable for your career. Excel or spreadsheets in general provide an easy and popular platform for data analysis. Number crunchers use this program to find answers, track trends and occasionally track the amount of data.
Excel is a cornerstone Microsoft Office, A collection of downloadable apps that starts at $ 69.99 per year. If you are a student, you can pay $ 149.99 upfront for an account that does not expire. If you are just starting out, you can try it for free for a month. There is also a free web-based version of Microsoft Office, but does not include some of the more powerful features, such as automated data cleaning or additional plugins.
Spreadsheet programs are ideal for sorting data, creating diagrams such as pie charts and diagrams, and tracking information. An executive assistant, for example, may color the supervisor’s schedule. Designers can use Excel to track all their projects. A business analyst can use it to crunch millions.
Excel is similar to other editing programs, such as Microsoft Word. It has a toolbar called Ribbon at the top of the screen, with buttons for sorting, styling, searching and even doing math. Each Excel file is called a workbook, and each workbook contains several worksheets, which you can flip through the tabs at the bottom of the screen.
The home section of the ribbon gives you italicized, boldface, or center text and selects other formatting options you may have used before. Spreadsheets also include “conditional formatting”, which means that you can instruct cells to appear differently depending on what they contain.
For example, suppose you have a spreadsheet listing the number of individual pages on your website that you received last month. You can create a conditional formatting rule by saying that if the value of a cell is greater than 1,000, that cell must be green. This can help you quickly identify pages with more than 1,000 views. Conditional formatting can make it easier to find the data you need or simply keep your eyes from being fatigued as you look at multiple rows of data.
The Data tab will help you organize and organize your content. You can sort, which means placing your rows in a certain order, or filtering, which means hiding the rows you don’t want to see. The formula tab helps you do the math, which is a popular Excel feature. You can write your own formulas, which is an intermediate skill, or use basic ones, such as add and multiply.
There are some free programs that can handle spreadsheets and work similarly to Excel, including Google Sheets, LibreOffice and Apache OpenOffice.
To start Excel training and online courses
- Visit excel, Microsoft, free
- Excel online learning, LinkedIn Learning, free
- Excel training required, LinkedIn Learning, $ 39.99
- How to use spreadsheet, Samantha sunne, free
- Start with excel, Goodwill Community Foundation, free
- Excel help and learning, Microsoft, free
- Excel Ribbon: Quick Guide for Beginners, Able, free
If you want to find trends in spreadsheets and answer questions, then sorting, filtering and formatting is probably your requirement. But if you want to learn the controls of Excel, then this is just the beginning.
Writing formulas and imagination are at another skill level. They take some time to learn, but they pay huge dividends. For example, would you like to know your company’s total sales – but only from the Chicago office? Or which products from your company are the best-selling items by month? Learning how to write functions and create data visualizations takes some time, but saves a lot of time on the road.
Journalist Kristin Hussey says she has used Excel for freelance jobs with outlets such as The New York Times. “It’s an easy way to check the dates I’ve forgotten, and especially to pull a complete picture together if I was working with odd notes and interviews,” She says.
Intermediate level Excel training and courses
- Excel magic, NICAR-LEARN, $ 40 per year if you are not a member of Investigative Reporters and Editors Inc.
- Finding stories in spreadsheet eBooks, Paul Bradshaw suggested a price of $ 19.99
- Doing Journalism with Data: First Steps, Skills and Tools; European Journalism Center, Open
- How to spot visualization lies, Floatingdata, free
- Excel formulas, Goodwill Community Foundation, free
- Nesting functions in excel, Functions for excel formulas and dummies, free
You can do a lot – perhaps most – of your analysis with beginner and intermediate skills. But if you want to learn Excel, the sky is the limit.
Some advanced Excel tools start toe the line between the spreadsheet and the code. For example, Visual Basic for Applications is a programming language that works inside Excel. You can use VBA to automate tasks, create an interactive form, coordinate changes with other users and other tasks.
You do not need to write code to use many of Excel’s built-in features. For example, macros record an action and then repeat it, which can save you a lot of time and effort. You can also add plugins like Power Query, allowing you to connect your workbook to other data sources.
“Excel is invaluable to the data layer, no matter the level,” says Girish Gupta, founder of Startup Data Drum. “I’ve used Excel to reduce data in physics, investigative journalism, my startup – everything.”
Advanced level excel training and courses
- Microsoft Excel – Advanced, Go skills, $ 299
- Excel: Advanced Formulas and Functions, LinkedIn Learning, $ 44.99
- Excel pivot table basics, Enemies, free
- Power query 101, Microsoft, free
- Excel: Working together with Power Query and Power Pivot, LinkedIn Learning, $ 44.99
- Financial modeling for beginners, Corporate Finance Institute, free of charge
- Scrap data from website to Excel, Alan cooper, free
If you really want to show your goods, then take an exam for an officer Excel certification from microsoft. This certification assures employers that you know what you are doing and can help job seekers negotiate higher salaries according to Microsoft. In fact job search sites allow users to search for jobs that require Excel certification. These jobs are often in administration, sales and finance.
Microsoft offers a series of tests that begin with Core program Growing up specialist. You have to pass the MO-200 test to become Excel Associate, And MO-2018 need to earn one Excel expert Authentication. These exams are very difficult, and they cost $ 100 per attempt, so be sure to check out some of the study resources below before registering.
- How to pass excel test, Study.com, free
- Microsoft Excel Certification: Practice and Study Guide, Study.com, free
- Microsoft Excel Certification Test – Free Practice and More, iPREP, $ 19.95
- Excel 2019: From Beginning to Intermediate (MoS 200 certified), Enemies, free
- 4 Steps to Successful Microsoft Excel Test Preparation, Applied Educational System, free
- Certificate Prep: Excel Associate – Microsoft Office Specialist for Office 2019 and Office 365, LinkedIn Learning, $ 44.99
- MOS Study Guide for Microsoft Excel Examination MO-200 Book, Joanne Lambert, $ 24.99
- How to prepare for MO-200: Microsoft Excel (Excel and Excel 2019) (MO-200), TestPrepTraining, free