## Basic Excel Training Syllabus| Basic Excel Course Syllabus

Start out on the right foot with Excel by taking advantage of SLA’s comprehensive Basic Excel Training Syllabus. As part of our Basic Excel Course Syllabus, you’ll get some hands-on experience with fundamental arithmetic and formulae, graphical displays, table construction, workbook, and worksheet formatting, and shortcut keys.

This Basic Excel Training gives you everything you need to know to construct and manage simple spreadsheets. Students will be given an introduction to the system’s user interface and instructed on how to enter and modify data in numerous ways. Furthermore, our Basic Excel training Syllabus will teach learners the many approaches to writing formulae.

Objective: To create, modify, save and print an excel worksheet.

Lesson 1: The Excel environment

• Navigating a worksheet
• Getting help

Lesson 2: Entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Saving and updating workbooks

Lesson 3: Modifying a worksheet

• Moving and copying data
• Moving and copying formulas
• Inserting and deleting ranges, rows, and
• columns

Lesson 4: Using functions

• Entering functions
• AutoSum
• Other common functions

Lesson 5: Formatting

• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting

Lesson 6: Printing

• Preparing to print
• Page Setup options
• Printing worksheets

Lesson 7: Charts

• Chart basics
• Pie Chart
• Bar Chart

Lesson 8: Case Study

• Modifying existing worksheet
• Use shortcut keys
• Create and email worksheet

_______________________________________________________________________

Objective: To enhance a basic excel worksheet using Pivot Tables and Charts, advanced functions like SUMIF, as well as use lookups.

Lesson 1: Review Basics

• The Excel environment
• The Sparkline
• The Trendline

Lesson 2: Subtotal Functions

• Create an outline and consolidate data
• Create subtotals in a list
• Use multiple subtotal functions – SUBTOTAL,
• SUMIF
• Create custom views to save different sets of
• worksheet display and print settings

Lesson 3: Range names and Filter date

• Define and apply cell and range names
• Use names in Formulas
• Filter data based on complex criteria
• Use conditional filters
• Copy filtered results to another range

Lesson 4: Pivot Tables

• Prepare data in a table format and name the
• table
• Create a PivotTable for analyzing
• Reconciliation as example
• Modify or re-arrange fields

Lesson 5: Selected Functions

• Using IF and SUMIF functions to calculate a
• value based on specified criteria
• Use ROUND function to round off numbers
• Use VLOOKUP to find values in worksheet data
• Use HLOO

Conclusion:

Our Microsoft Excel Training Syllabus is designed to ensure that you have an understanding of Excel, starting from basics to advancing to complex ideas. You get the knowledge and abilities required for success in the data area with this course. By joining our training, you’ll gain the essential skills needed to pursue and thrive in your dream job. Take advantage of the opportunity to gain the essential skills necessary for a successful career.