About this course
Basic Excel Course helps participants get a deeper understanding of the functions and features available. It also elevates the participants’ Excel skills to a different level. This course is by professionals for professionals looking to improve their knowledge and hands-on practical applications of Microsoft Excel in the workplace.
Excel is a powerful application that can help in generating reports. This is exactly why we offer this training. To ensure that individuals are aware of the basics of Excel to help do tasks quickly and efficiently. It will also help you understand how much you can do with Excel. Additionally, it will increase the effectiveness of the reports and presentations that you use Excel to prepare.
More often than not, you invest a great deal of effort into sorting out all your workbook data and calculations. It would be a real shame if some, or all, of this effort, is wasted because the end product that you rely on, or present to others, isn’t as effective as it could be and doesn’t make the required impact. Some of Excel’s most powerful, but least obvious, features can help you turn an unremarkable set of figures into a graphical presentation that provides real insight and drives important decisions.
Things You Might Need for this Course
Course Objective
Microsoft Excel 2010/2013/2016 Basic Course:
At the end of this 1-day course participants are expected to learn the following:
- Running Microsoft Excel
- Define Excel components
- Using Worksheets
- Saving, Closing, and Opening Worksheets
- Entering Values
- Using Autofill
- Using Formulas for Computations
- Adding images
- Saving a worksheet as a PDF file
- Adding data and computations
- Absolute references
- Insert and delete ranges
- Using common features in computations
- Formatting
- Conditional Formatting
- Pagination
- Hiding and unhiding data
- Inserting and modifying images
Modules
To achieve these objectives, Advanced Learning Programs (ALPs) will use the below Lesson Plan:
Lesson 1 Introduction
- Introduction
- Class Expectations
- Class Structure
Lesson 2 Getting started
- Worksheet defined
- The Excel Screen
- Getting Help
- Worksheet Navigation
Lesson 3 Entering and editing data
- Entering and editing values
- Entering and editing formulas
- Working with Images
- Saving and updating workbooks
Lesson 4 Modifying a worksheet
- Moving and copying data
- Moving and copying formulas
- Formulas: Absolute and relative
- Inserting and deleting ranges.
Lesson 5 Using Basic Formulas
- Entering formulas
- @sum formula
- Other common formulas
Lesson 6 Using Formatting
- Text formatting
- Row and column formatting
- Number formatting
- Conditional formatting
- Additional formatting options
Lesson 7 Printing
- Preparing to print
- Page Setup options
- Printing worksheets
Lesson 8 Charts
- Chart basics
- Formatting charts
Lesson 9 Managing workbooks
- Viewing worksheets
- Printing worksheets
- Working with multiple worksheets
Lesson 10 Graphics and Images
- Conditional formatting
- SmartArt
- Images