Dear All, in case anybody wants to take training on advanced excel, please note the details;
Advanced Excel - 16 HOURS
You can send queries to learn more
Advanced Excel - 16 HOURS
- Microsoft Excel and its applications
- GUI Layout
- Customizing toolbars
- Working smartly with office ribbon and mini toolbar
- Working with quick access toolbar
- Contextual tabs
- Data creation : Working with cells, rows, columns,
- Worksheets, workbook effectively ; shortcuts
- Data preparation Using "format as table" effectively
- Using paste special and format painter brush
- Custom settings: number, text, date, currency
- Format Painter
- Auto fill, auto complete, auto correct functions
- Data analysis Subtotal function
- Grouping and ungrouping
- Text to columns
- Data validation
- Single Sort, multiple sort, filter, custom filter
- Advanced filter
- Conditional formatting
- Goal seek, data table
- Solver
- Pivot table, pivot chart
- Scenario
- Hyperlinking
- Reviewing Inserting and deleting comments
- Sending files for review, managing track Changes
- Proofing Thesaurus, spelling and grammar
- Auto correct option
- Formulas : Sum, average, count, min, max, autosum, counta, maxa, mina, averagea, Upper, lower, proper vlookup, hlookup
- If, absolute and relative referencing
- Sumif, countif, date and time functions
- And, or, not and other regularly used advanced formulaes
- Graphs How to create charts: pie charts, column charts, bar charts
- Viewing data Normal view, page layout, page break preview, custom view, full screen view
- Name manager
- Data printing Print area, page setup, printing do's and don’ts
- Security Protecting excel workbooks with password
- Visual Basic for Applications Introducing VBA macros, macro recorder
- Settings and Excel options
You can send queries to learn more