-
Recent Posts
Recent Comments
- yp079600 on What’s New In Microsoft Word 2013?
- yp079600 on New features in Excel 2013
- hz118786 on The New Office 2013 (-by William Cheng)
- wc088853 on Office 2013
- Jonguk.Sung on What’s New In Microsoft Excel 2013? [Review]
Archives
Categories
Meta
Author Archives: ag104530
Posts: 3 (archived below)
Comments: 0
What’s New for Excel 2013
One of the many features I enjoy in Excel is their pivot tables and various charts. It is a handy, easy and enjoyable way to view the data. Here are some of the new features in pivot and chart views.
Enjoy new ways to explore your data more intuitively. Visualize, analyze, and display results with a single click. And when you’re ready, it’s easy to share your freshly discovered insights.
Discover:
Reveal the insights hidden in your data. Easily extract what you need from imported information with Flash Fill, and perform complex analyses quickly with Recommended Pivot Table.
Recommended Pivot Table Excel summarizes your data with previews of various pivot-table options, letting you select the option that tells your story best.
Flash Fill Here’s the easy way to reformat and rearrange your data. Excel learns and recognizes your pattern and auto-completes the remaining data, with no formulas or macros required.
Visualize
New analysis tools help make it easy to visualize data with a click of the mouse.
Recommended Charts Let Excel recommend the charts that best illustrate your data’s patterns. Quickly preview your chart and graph options, and then pick the option that works best.
Quick Analysis Discover a variety of ways to represent your data visually. When you like what you see, apply formatting, sparklines, charts, and tables with a single click.
Chart Formatting Control Fine-tune your charts quickly and easily. Change the title, layout, and other chart elements—all from a new and more interactive interface.
Source: http://www.microsoft.com/office/preview/en/excel-2013-preview
Anthony Garafola
Posted in Office 2013
Comments Off on What’s New for Excel 2013
How I Use Excel At Work
I am constantly using excel at work. As I’ve stated in my blog profile, I am considered the excel “expert” at work and there is a lot of pressure when it comes to performing a task using excel. Actually today, I was asked to create a mail merge using excel. We recently changed our system from SIMS to CUNYfirst and there were a lot a glitches with the system. I was asked to create a letter template in word and extract data from excel using various formulas adding up and subtracting numbers for student bills. I also use excel for a committee that I am on to keep track of students who file for tuition liability appeals. What I like about using excel for this particular task is that I can filter out particular data using lists, such as how many students were approved or denied for an appeal in a particular academic year, or semester. And I can filter out the percentages of approval and denials of who actual determined the appeal. I have also used excel for creating data matrix’s for payroll purposes using the sum function, what if analysis, and linking worksheets, workbooks and Microsoft word. I also use excel to create pie charts, which I love because they give the data you create a nice visual without having to strain looking at loads of numbers.
Excel Rocks!!
Anthony Garafola–
Posted in How Excel is used at Work
Comments Off on How I Use Excel At Work
Here is the link for my (Anthony Garafola’s) profile! :)
Posted in Profiles
Comments Off on Here is the link for my (Anthony Garafola’s) profile! :)
