platinumhost.blogg.se - Using excel on mac

USING EXCEL ON MAC HOW TO
USING EXCEL ON MAC FOR MAC
USING EXCEL ON MAC MAC

Replicate a single formula to an entire column.Change numerical values into categorical using VLOOKUP or grouping.Change categorical values into numerical using Replace.Choose numerical or categorical forms of each column to best answer your questions.Build a unified data table using VLOOKUP to draw data from another.Organize the data to see similarities (prepare for clustering).Find a category most likely to have some characteristic (data mining).

Effectively use the various PivotTable options for "summarized by".

Use a PivotTable to analyze an issue whose outcome is "yes" or "no".

Use a PivotTable to "slice and dice" the data various ways for deeper insights.

Use PivotTables to make an instant summary table of the data.

Filter your data based on various criteria.

Sort your data based on numerical and categorical values.

Calculate an entire column using a simple formula and replicating.

Apply the VLOOKUP function in both forms, in particular to merge data or turn numerical values into pre-defined categories.

Focus and organize your data to surface answers using sort, filter and PivotTables.

Merge disparate data files into a form for easy analysis.

Make data-informed personal and business decisions.

Design a PivotTable to best answer any particular question.

At the end of this course you will be able to.

These powerful techniques have been in Excel for a long time. If you've used Excel for anything-making a list or adding up a column of numbers-you're good to go. That's why most of the time you spend in this class will be hands on, doing case studies of personal and business issues.Īll you need is a basic familiarity with Excel. The complexity comes from applying these seemingly simple techniques to real-life problems. Find the 20% that gives you 80% of the value. Summarize it by one factor, then quickly try another. Immediately start exploring your data with sort and filter.

USING EXCEL ON MAC HOW TO

Your data may be in inconsistent pieces or have extraneous information, and you'll learn how to fix that. First you will structure the data to make finding answers quick and flexible. You will learn to turn your mess of data into answers, decisions, and action. You will learn PivotTables, sorting, filtering, VLOOKUP, formulas and more. Do the hands-on case study challenges and experience the power of these simple analytical techniques. You will be given sample spreadsheets for real-world personal and business case studies. You will be surprised at the powerful analysis that can be done with simple spreadsheets, including data science techniques like data mining, segmentation, and clustering. Getting Answers from Data using Excel brings you the best techniques for slicing and dicing your mess of data until the insights fall right out of it.

USING EXCEL ON MAC MAC

I'm using a Mac with specific instructions for Windows in the few places the interface differs.Ī desire to draw answers out of a mess of data If you've used it for a list, for example, you're good to go.Īny version of Microsoft Excel on any platform. Perform data mining, clustering and segmentation using Excelīasic familiarity with Excel. Merge disparate data files into a form for easy analysisįocus and organize your data to surface answers using sort, filter and PivotTablesĪpply various Excel tools to organize data and get answers, including sort, filter, PivotTables, VLOOKUP, formulas, conditional formatting and more.

Make data-informed personal and business decisions Real-world case studies for data-informed decision makingĭraw hidden insights from any data file: counts, totals, sweet spots, similarities, rankings and moreĭesign and apply a PivotTable to best answer any particular question, whether numerical or yes/no. Language: English | Size: 1.31 GB | Duration: 2h 25mĭata analysis with Excel Pivot tables, filtering and more.

USING EXCEL ON MAC FOR MAC

Getting Answers from Data using Excel for Mac or Windows