MS Excel (Advanced)
Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Advanced Microsoft Excel training is for those people who know Excel already and is designed for students to gain advanced skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros (Optiona). … etc.
Modules
- Basic Functions
- Sumif, Countif, Sumifs, Countifs
- Pivot Table & Pivot Chart
- Data Validation
- Goal Seek
- Hyperlink
- Print Titles
- Name Manager
- Custom List
- Advanced Filter
- Scenario Manager
- Quick Access Tool Bar
- Header And Footer
- Formulae Auditing
- Vlookup & If error
- Conditional Formatting
- Subtotal, Group, Ungroup
- Data Table
- Remove Duplicates
- Consolidation
- Watch Window
- Text To Columns
- Custom Views
- Comment
- Paste Special
- Track Changes
Course Rating
MS Excel (Advanced)
Course Provider: Organization
Course Provider Name: Rolla Academy Dubai
Course Provider URL: https://rollaacademydubai.com/
5
- Duration 20 hours
- Lessons 26
- Enrolled 1365 student
- Access Lifetime
More Courses You Might Like
Microsoft Outlook
Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing.
MS Excel (Advanced)
Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Advanced Microsoft Excel training is for those people who know Excel already and is designed for students to gain advanced
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
