MS Excel Essential Skills

This course will teach you how to best enter and organize data, perform different calculations with various functions, organizing data in different worksheets, formatting UI, and building PivotTables and visualizing data using charts. We will also cover the very useful functions i.e. IF, SUMIF, VLOOKUP, and COUNTIF. It also covers other essential features offered in MS Excel 2016.

Outline

• Basic Skills
• Doing Useful Work with Excel – Data Entry using shortcuts
• Taking Your Skills to the Next Level – Using formulas and functions
• Making Your Worksheets Professional/Presentable – Formatting
• Charts & Graphs
• Organizing data using multiple worksheets and workbooks
• Protecting your important data
• Printing your Work
• Analyzing data with Goal Seek and Solver
• Creating and running macros

Fees: Please contact +21-34558425
Duration: 1-1.5 Months