Excel 1 Essentials: More Than a Foundation

Rady School of Management

How long?

  • 1 day
  • online

Rady School of Management

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Who should attend

This course is designed for participants with intermediate skill level using Excel. Participants should be comfortable using Excel and have familiarity with its basic functions. This course is not for beginners or designed for people with no Excel experience.

About the course

Get more out of Microsoft Excel®: more productivity and better answers for greater success. This intermediate-level course brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts.

In this hands-on class, you will learn to use Excel to successfully tackle business related problems, including financial forecasting, purchase order calculations, pro forma financials, capital budgeting, and text transformations.

Topics Covered:

  • Formatting: Customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand
  • Absolute vs. Relative Cell References: a cell or a range of cells on a worksheet and can be used in a formula so that Excel can find the values or data that you want that formula to calculate
  • Filtering: Filter your Excel data if you only want to display records that meet certain criteria
  • Tables: Allow you to analyze your data in Excel quickly and easily
  • Sorting: Sort data by numbers, text such as alphabetical order, dates, colors, icons, or by a custom list.
  • Formulas and Functions: Allows all sorts of data analysis, from simple sums to standard deviation
  • Macros: Easily create automated tasks and custom logic
  • Solver / Goal Seek: find roots of a polynomial equation and a variety of other problems, even with multiple unknowns
  • Linking Spreadsheets: Establish links across multiple spreadsheets and workbooks to streamline data management
  • Present Value Applications and Finance Functions: Determine the value of a financial asset.
  • Charting: Communicate data graphically.
  • Conditional Formatting: Allows you to apply different formatting options, such as color, to a cell or cells based on the data entered.
  • Spark lines: Graphs that fit in one cell and give you information about the data
  • Sliders: Use a scroll bar or spin button to quickly enter or change a range of values.
  • Histograms: A specialized type of bar graph used to summarize groups of data.
  • Working with Text: Learn valuable formulas for working with text in Excel, Flash Fill

Experts

David Ravetch

David Ravetch has been a UCLA faculty member for over thirty years. He has won numerous teaching awards. He has been named Favorite Accounting Instructor, as voted by the accounting students, as well as, Most Recommended Instructor, as voted by students campus wide. In the spring of 1995, the Cal...

Videos and materials

Excel 1 Essentials: More Than a Foundation at Rady School of Management

From  $800

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.