Full course description
Learn Excel basics
Advance your knowledge of Excel in this second of two self-paced online Excel classes. Learn how to use complex data sets and workbooks, and sort and filter through your Excel data in this online class.
As your data sets grow and become complicated, you will save time and frustration by leveraging the tools and automation practices within Excel. Organize your data through sort, hide data that’s not relevant in the filters, and format cells to make your information easier to review. This online excel class will help you through personal and business use cases such as:
- Calculating the highest sales month in a year
- Taking an inventory of your stock and determining trends in specific wares
- Reviewing operating budget trends throughout the year
- Creating a graphic that visually represents your data accurately and easily
What you'll learn in this Excel tutorial:
This Microsoft Excel tutorial will teach you how to create an Excel spreadsheet and start creating and filling in the cells of your spreadsheet. The skills you will develop include:
- Create a new workbook with more than one worksheet; new worksheets within a workbook help to organize information that is in particular groupings.
- Sort data in a table; sort your information in your workbook alphabetically, by numerical value, date or custom organization.
- Filter data in a table; Filtering information in your Excel workbook allows you to hide data without losing the information.
- Use the COUNTIF function; The COUNTIF function allows you to see how many times a certain piece of information appears in your worksheet.
- Use the IF function; Use the IF function to form a logic around certain sets of data in your workbook. For example, you can use this function to automatically see if your operating costs are under budget in your monthly spend entries throughout a year.
- Create a clustered column chart; A clustered column chart is sometimes called a bar graph because it shows data organized in solid shapes like pillars.
- Modify chart style; Choosing the format of your chart (bar, pie, line) can help you and your audience understand different components of your data. Learn how to create different chart types within Excel.
- Create sparklines; Sparklines are mini graphs that show up within the cell of your workbook to more easily communicate information for users in between your data.
- Create and apply conditional formatting; create organizational and formatting rules in your spreadsheet that treats specific data or data types differently. For example, if you want to see any case in which a customer ranks your services as poor within a million customer feedback entries, you can tell Excel to highlight the word “poor” in your data.
- Change page layout orientation; determine whether your information is better suited for horizontal (landscape) layout or a vertical (portrait) layout orientation.
- Change margins; Alter your margins to ensure your Workbook can easily print on a standard printer, or fit within a larger report or presentation.
Who this online Excel class is for:
If you’re seeking to advance your Excel abilities and better use the Excel functions to save time and represent your data with graphic visualizations, this is the course for you! If you’re seeking to understand the basics of Microsoft Excel, review our first class on foundational Excel functions.
Earn a certificate in Excel functions:
When you complete this Excel class, you’ll take with you skills that you can apply for all kinds of business data organization and visualization and you will earn a certificate to signify your advanced Excel skills.
Meet the instructor
Jennifer Chandler, PhD
Jennifer L. S. Chandler, Ph.D. teaches organizational leadership courses and researches organizational leadership practices among scientist and engineering teams who are tackling global sustainability challenges. She has also led projects, taught project management, trained project managers, and evaluated Project Management Programs for over 20 years working with international corporations, U. S. federal agencies, and U. S. national professional associations.