Microsoft excel classes how to#
Microsoft excel classes pro#
Microsoft excel classes professional#

LESSON 4: MORE EXCEL FUNCTIONS EVERY BEGINNER SHOULD KNOW During this lesson you'll use more common techniques to manipulate and organize your data.

Microsoft excel classes how to#

Learn basic Excel concepts such as inserting, deleting and moving rows and columns and how to sort and filter your table. LESSON 3: EDITING, SORTING AND FILTERING YOUR TABLES Additionally, you'll learn how to change the background colors of cells, font colors and work with the Alignment group and working with Number formats. During this lesson you'll be able to cut, copy and paste content, cells, rows and columns and learn how to use the Format Painter. Learn how to use the Home tab commands to change the formatting of the content in your tables. LESSON 2: UPDATING, CHANGING & DUPLICATING THE FORMAT & CONTENT OF TABLES You'll end the lesson working with some data and doing simple tasks to get you acclimated with tables. During this lesson you'll learn where to find things in Excel, how to properly name sections in Excel, how to navigate a ribbon, a workbook and a spreadsheet.

Microsoft excel classes pro#

LESSON 7: ADDITIONAL TASKS FOR PIVOT TABLESīecome a pro with Pivot tables by learning how to do additional tasks, such as inserting Slicers into your pivot tables and creating a custom field with a calculation.īuild your foundational skill by learning how to navigate a workbook, a ribbon and work with a basic spreadsheet. Learn how to create pie graphs, bar charts, line graphs and more by using Pivot Charts in Excel. Now that you have some basic understanding of Pivot Tables, it's time to learn how to to customize them, manipulate them and organize them depending on the data you want to produce. LESSON 5: HOW TO CUSTOMIZE YOUR PIVOT TABLES

In Lesson 4 of our Advanced Excel Accelerated Course, you'll learn how to build pivot tables in a few easy steps. In Lesson 3, users will spend a significant portion of their time learning three different types of lookup formulas by learning about how they are structured, how they are used, and when to use each type of formula depending on your spreadsheet and your desired outcome. Through numerous exercises, you'll learn how to apply the IF formula to automate a process, how to use multiple IF formulas when you encounter different conditions and how to combine IF formulas with other logical formulas to facilitate the automation process. In Lesson 2 of our Advanced Excel Accelerated Course, you'll begin to learn how to automate your formulas by using the infamous IF formula. During this lesson you'll learn different techniques to link sheets together, work with hyperlinks and learn a few formulas that will help you become more efficient when working with dates in Excel. Lesson 1 helps you quickly learn Excel skills that intermediate users should know and helps our newer Excel students get well acquainted with the structure of our course. LESSON 1: HOW TO USE HYPERLINKS & WORK WITH DATES The warm-up exercises are designed to help you smoothly transition from an intermediate Excel user to an advanced Excel user.

Microsoft excel classes professional#

Professional accreditation and certification.The Advanced Excel Accelerated Course begins with two warm-up exercises to help you assess your skills in a few intermediate-level Excel concepts.

Ensure your organization knows how to extend and leverage Excel knowledge throughout your organization to avoid costly mistakes. Learn the ins and outs of spreadsheets, macros, sparklines, PivotTables, charts, graphs, reports and more with award-winning Excel training. Without Excel knowledge, organizations are in a position of unnecessary risk and potential liability. And these aren’t isolated or inflated events. Barclays lost millions due to an error of hiding cells instead of deleting them.

But what are the actual costs to an organization with employees that don’t know, or are not well-versed in Excel? Consider that a simple cut and paste error cost JP Morgan $6 billion and TransAlta $24 million. On the flip side, it’s estimated that 80-90% of all active Excel spreadsheets have critical errors. Why is Microsoft Excel Training Important?Īccording to Forrester Research and WorldAtWork, 80% of businesses use Excel, with 95% of Fortune 500 businesses relying on Excel to store and interpret crucial business data.