Download Advanced Excel VBA Notes and more Exercises Computer Science in PDF only on Docsity!
ADVANCED EXCEL WITH VBA
Introduction Formulas What is an Excel? Logical Histroy, Versions IF, And, Or, IFError Opportunities & Career Growth ISBlank, ISError ISNumber,ISText ISFormula,ISNA Cell Formatting Format Painter Text Paste Links Clean Paste Special Concatenate Cell Alignment Find Indent Increase/Decrease Left Wrap Text Len Merge & Center Mid Number Format Lower Conditional Formatting Proper Convert to Table Replace Cells Insert/Delete Repeat Row Height, Column Width Right Find, Replace & GoTo Substitute Text Tables Trim Create Tables Upper Tables Formatting Convert Tables to Ranges Date & Time Filters & Adv.Filters Day Now PivotTables Today Pivot Charts WeekDay Insert Slicers WeekNum Change Data Source Copy and Move Lookup & Reference Caluculated Fields Lookup Sub Totals, Grand Totals Vlookup Report Layouts Hlookup Pivot Styles Choose Row Charts Column Pies Chart Match Line Charts Index Bar Charts Offset Interactive Charts Transpose Sparklines Hyperlink
ADVANCED EXCEL WITH VBA
Conditional Text Sum Text Box SumIf Word Art Sumifs Object Count CountA Shapes & Hyperlinks CountIf CountIfs Advanced Features CountBlank Hide/Unhide Sheets Average Hide/Unhide Workbooks AverageIf Protect/Unprotect Sheets Protect/Unprotect Workbooks Defined Names Hide/Unhide ScrollBars Name Manager Hide/Unhide Status Bar Define Name Quick Access Tool Bar Using Names in Formulas & Pivot Tables Customize Ribbon Collapse the Ribbon Data Creating Symbols with Fonts Importing & Exporting Data Watch Window Creating Connections with other Applications Calculation Options Text to Columns Formula Auditing Remove Duplicates Short Cuts Data Validation Scinario Manager Goal Seek Data Table Grouping, Ungrouping, Sub Totals Flash Fill View Removing/Adding Formula Bar Removing/Adding Gridlines Removing/Adding Row Headers Removing/Adding Column Headers Zoom New Window Arange All Freeze Panes Split
