Wed. Jan 27th, 2021

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.

(Getty Images)

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

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

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

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.

Source link

Leave a Reply

Your email address will not be published. Required fields are marked *