*Basic Excel

Participants will work on entering organizing data, and performing calculations with data using simple functions. The course will also cover the basics of working with multiple worksheets, formatting the appearance of cells and data, creating charts, and making PivotTables. The uses of functions like IF, VLOOKUP, and COUNTIFwill be covered as well. Seeing how to best use data analysis tools, like Goal Seek and Solver will also be covered. Task automation via macros, and best data management practices will be covered as well.

Topics include:

• Menu and Tab navigation
• Data Entry
• Function and formula creation
• Row, Column, Cell and Data Forming
• Text wrapping and alignment
• Column and Row adjustment
• Replacing data using the find function
• Sharing, printing worksheets
• PivotTable adn Chart Creation
• Deleting Sheets, Inserting Sheets
• VLOOKUP and IF function usage
• Password-protection of workbooks and worksheets
• Data Sorting
• Solver and Goal Seek data analysis