Financial accounting is a specialized branch of accounting that keeps track of a company's financial transactions. Using standardized guidelines, the transactions are recorded, summarized, and presented in a financial report or financial statement such as an income statement or a balance sheet.
Web design encompasses many different skills and disciplines in the production and maintenance of websites. The different areas of web design include web graphic design; interface design; authoring, including standardised code and proprietary software; user experience design; and search engine optimization.
AutoCAD is a commercial computer-aided design and drafting software application. Developed and marketed by Autodesk, AutoCAD was first released in December 1989 as a desktop app running on microcomputers with internal graphics controllers.
Advanced MS Excel 2010 course covers all the Excel functions to perform financial, mathematical or statistical calculations such as, DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros.
1)Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
2) Saving Excel File as PDF, CSV and Older versions
3) Using Excel Shortcuts with Full List of Shortcuts
4)Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
Using Paste Special Options
5)Formatting Cells, Rows, Columns and Sheets
6)Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
7)Page Layout and Printer Properties
8)Inserting Pictures and other objects in Worksheets
9)Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc
12) Math and Trigonometry Functions
13) Statistical Functions
14) Text Functions
15) Using Conditional Formatting
16)Sorting Data A-Z and Z-A
17)Using Filters to Sort Data,Advance Filtering Options
18)Creating Pivot Tables
19) Using Pivot Table Options
24) What is Excel Macro ? How to Record / Run Excel Macro ?
1)Basic of computers
9)Features in Tally