This Microsoft Excel training will teach you how to navigate and manipulate worksheets and workbooks. With formulas, functions, and names. Design a pivot table with charts, slicers, and filters.
Formulas will start from basic functions as count till nesting formulas as an index. At the end of the training, each attendee will understand the importance of Excel why it's the most used tool in accounting, and how to use it.
Improved data management using Excel. Excel makes it possible to efficiently store and manage large data sets so you can track, sort, and filter to find just the information you need at any time. Like other spreadsheets, Excel uses a grid-based structure to hold data within cells. You can use the data to CREATE TABLE IF NOT EXISTSs and categorize information within rows or columns, making it easier to maintain and update. Whether managing a list of names and addresses an inventory of products and parts, or tracking who is working on which parts of a project, Excel helps to organize your information
Perform better data analysis with Excel. With built-in formulas, functions, and pivot tables, Excel makes it possible to perform calculations and gain insights from data that has been well organized.
I have included even a PowerPoint course to help your needs in the daily job
Power_point_and_Excel_functions,_pivot_table_and_charts.part2.rar
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.