Excel Course is just what you’ll need to increase excel skills confidence and take your current excel skills to the advanced excel level!
Excel Course Pivot Tables take data management for the user to another level, you can organize long lists of information and create custom tables from a list of entries or a database.
Excel Course “IF” function is a condition statement, to display if the condition is met, and if the condition isn’t met.
Learn Excel filter and Sort are though there are some similarities, there are some differences. While sorting rearranges entries in a particular order, filtering enables you to display only the specific information you need.
Excel Training VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index number position. VLOOKUP function is a built-in function in Excel can be used as a worksheet function in Excel. As a worksheet function, VLOOKUP function can be entered as part of a formula in a cell of a worksheet. Advanced Excel Course Chart function is useful when presenting your results, you don’t deal with too much text and numbers.
Excel Course Benefits:
Advanced Excel training skills you’ll gain in this one week is more practical in less time to use at your work place. Advanced Excel Course training provides you to work with hands-on exercises without wasting your valuable time.
EXCEL COURSE TOPICS FOR DISCUSSION:
Microsoft Excel Ribbon & shortcut menus
Practice to format Excel worksheets
Practice to use simple Excel worksheet basic functions that auto sum, max, min and average
Preparing worksheet tables
Practice to use Conditional Formatting features
Practice Absolute and Relative Cell References
Lists – Filtering, Auto filtering & Advanced Filtering
Sorting – Custom & Multiple Column Sorting
Summarize data using key worksheet functions like IF, SUMIF, COUNTA and COUNTIF
Excel data-Group, Outline and Subtotal
How to use VLOOKUP and HLOOKUP
Linking – Workbooks, Exporting & Importing Data
Practice to prepare business charts
Generate report with Pivot Table and Pivot Chart.
Excel Financial Functions PMT()
Data Tables – One Input & Two Input Data Tables
How to Remove Duplicates
How to use page setup and print features
Excel Security – Workbook, Worksheet and Cell Protection & Hiding
Certificate on Completion