This course is designed for those without any or very little prior experience with Excel who desire the knowledge to use it on a professional level. Step by step tutorials guide and teach you how to use the many tools that Excel offers for use at work, for small businesses, or at home. This course begins with the very basics of Excel with how to open a workbook and transitions you into more in depth skills such as working with multiple worksheets and creating formulas and calculations. In addition, this course offers a free downloadable training manual which provides step by step instructions at your fingertips covering all of the topics taught in this course.
The content of this course was designed based on feedback from Excel 2010 students from live classrooms who are employed and use Excel in many types of business professions.
This tutorial demonstrates how to open Excel and create a default workbook.
How to change HD setting to clear us fuzzy tutorial videos.
This tutorial explains what the ribbon is and the locations and grouping of various tools and how to use them.
This tutorial explains and demonstrates how to use and customize the quick access toolbar.
This tutorial explains the various auto recovery options and how to set up auto recovery options; as well as, how to recover an unsaved workbook.
This tutorial demonstrates how to make a copy of a workbook using the save as option, as well as how to save a workbook.
This tutorial explains what are columns and rows, as well as how to access and maniplulate them.
This tutorial demonstrates how to use Excel in different view types and how to get back to a normal view.
This tutorial explains what a zipped files is and demonstrates how to create or open one.
This section includes an Excel training manual as well as two data files that are used in upcoming tutorials; all of these are available for free download.
This tutorial demonstrates how to enter data into an excel spreadsheet as well as how to move between cells, columns, and rows.
This tutorial demonstrates how to delete data from an excel spreadsheet; explaining the difference between deleting with the keyboard versus deleting with a mouse.
This tutorial demonstrates how to format an excel spreadsheet with bold and underline; as well as how to change cell and font colors.
This tutorial demonstrates how to merge and center cells using the ribbon and the mouse.
This tutorial demonstrates how to right, left, or center align data across entire columns, rows, or individual cells.
This tutorial demonstrates how to cut, copy, and paste data using the mouse or the ribbon.
This tutorial demonstrates how to use format painter to apply selected formatting to rows, columns, or individual cells.
This tutorial demonstrates how to adjust column and row width with auto fit, dragging with the mouse, and adjusting to a specific size using the demensions displayed on a column or row.
This tutorial demonstrations how to format various types of numeric data; for example, into currency or percentages.
This tutorial demonstrates how to use predefined auto fill list included with Excel; as well as, how to create and use your own list.
This tutorial demonstrates how to add additional sheets to a workbook; as well as, how to delete sheets from a workbook.
This tutorial demonstrates how to format multiple spreadsheets all at once with font and color.
This tutorial demonstrates how to add data and formatting to multiple spreadsheets all at once.
This tutorial demonstrates how to use the multiple freeze pane options to allow the top row, selected columns and rows, or selected column to remain visible while scrolling through the spreadsheet.
This tutorial demonstrates how to use sorting or filters and explains the difference between these options.
This tutorial demonstrates how to adjust page breaks for more uniformed printing.
This tutorial demonstrates how to print a spreadsheet or entire workbook with different page layouts while eliminating blank pages during printing.
This tutorial demonstrates how to enter numeric values and use the auto sum feature to total the values. In addition, this tutorial demonstrates how to manually type in the sum formula and explains the format of the formula.
This tutorial demonstrates how to perform multiplication calculations using formulas.
This tutorial explains what an absolute reference is and how to use it with multiplication formulas.
This tutorial demonstrates how to create multiplication and addition formulas across multiple spreadsheets all at once.
This tutorial demonstrates how to include data from other spreadsheets and use those in calculations.
What steps to take next and how to get help.
I hold a degree in Computer Science for Software Development and am employed as a Business Intelligence Analyst and Software Developer for an IT consulting firm. On a daily basis I build software, create websites, and both manage and create Sql and Access databases. The firm that I work for also offers instructor lead training classes to our members who are taught in person in a classroom.
Over the past two years I have taught the entire Microsoft Office Suite professionally in a class room to hundreds of business professionals who use the software daily in their professions. My teaching philosophy is that it is important to teach in a way that uses real life examples and analogies and breaks down and simplifies processes and techniques. Using real life examples and teaching in small simplified topic blocks allows others to learn easily. I have learned through real life teaching experience that not all students come to a class with the same knowledge base; so it is important to teach each topic thoroughly step by step. This means that every step is explained and demonstrated without making assumptions that a student will know how to complete some parts of a task already. This allows students to focus on the concept of what is being taught instead of focusing on a step that was not demonstrated that they are unsure of how to complete.