Legal Information

PC Knowledge Base - MSOffice

Good Knowledge Is Good2Use This section contains material for exploiting the function within office products

• Edit Help Files
• Link Sage database with Excel
  • Using Pivot Tables with Accountancy Data
• Excel data analysis
  .. Choose action ... Add a drawing to Excel Add a form button Add a function button Auto-Correlation of Time Series Calculate Number Given Probability in Normal Distribution Construct a Candlestick Chart Construct a Normal Distribution Curve Construct a Histogram Delete a Number of Worksheets Draw a Line on a Chart in Excel Excel Candlestick Formula Fit a Trend Line in Excel Get external data from web Moving Average Name a Chart in Excel Optimisation Modelling with Solver Probability Number at or Below Value of a Normal Distribution. Reverse data order on axis Significance testing Significance testing of means Linear Programming with Solver Regression Analysis With Excel Using Logical Operators
• Modify Excel toolbar
  .. Choose action ... Add a new toolbar Add/Remove toolbar when Excel opens/closes Add buttons to a toolbar Modify buttons Open Worksheets in Different Tabs
• Visual Basic Macro Editor
  .. Choose action ... Accessing Data Accessing Data in Second Workbook in Background Access Active Excel Cell Activate a Worksheet Add a chart to Excel using VBA Add a combobox to Excel using VBA Add and tailor chart to Excel Using VBA Add a trendline to chart using VBA Add text to a drawing in Excel Add a toolbar dynamically in Excel Add an External Form Calculate Probability of Streak Continuing For One More Success Calculate Probability of Streak Ceasing with at least One Failure Calculate T-statistic and P-value from Linest Regression Calculate Regression Calculate Regression Prediction Interval Calculate Regression with Linest (preferred) Calculate Multiple Linear Regression Calculate Regression of non-linear series Call an Excel Function Change the Colour of A Chart Series Check if Worksheet exists Clear a worksheet Construct a Histogram Convert date to number and number to date Convert binary to decimal Convert XML File Copy data to clipboard Copy one worksheet to another Correlate Data Create an External Form Create a New Worksheet Get a Chart Name or Name it Delete Charts/Graphs/From controls Delete a Worksheet Determine Cell Format Determine Day of Week Determine Folders and sub-folders Determine Row of Value Disk Paths From Application Location Download Web Page Bypassing SSL Drop Down Combo List Emulate Numpy Randn Statement Emulate a Sleep Function Extract Range of Data From a Chart Extract Trendline Data From a Chart Extract Polynomial Trendline Data From a Chart Extract Polynomial Trendline Data with Linest Find a File Formatting Cells Get URL from hyperlink cell Generate Random Number from Normal Distribution Generate a Sigmoid Function Identify Download Folder Identify Username Issue Long Message With Wait Issue Message Without Wait List all shapes, read data in worksheets Link to a webpage Loop Through Excel Worksheet Modify Chart Modify Drop down List Open Anothere Workbook Invisibly and Process Pass command to command line from VBA Protect and Hide Cells Process Worksheets in a Workbook Python Forward Projection Dot Product Weight and Values with Bias Python Initialise Weight Values and Bias Python Loss Read/Write Data From/To Clpboard Read Data From a Chart Read/Write Data From a File with Special Characters in the Filename Read Data From a Number of Charts Read Formula From an Excel Cell Read text from a drawing in Excel Read a web page Read a Google web page Run Macro at Open Run Solver Select Data From Worksheet Select a Random Value with Normal Distrbution Sleep Wait Sort Data Subroutines Testing Difference in Means Testing for Normal Data Testing for Significance Write hyperlinks to Excel
• Python code
  .. Choose action ... __init__ : np.random.seed np.random.random sigmoid function
• Interface with Outlook data
• Create Access Database
  • Analyse Access Database Records
  • Inserting a Lookup Column

.

Search Knowledge Base

Feedback

If you like our web site refer a friend.
Your friends name.	Your friends email address.
Your Name	Your Email Address

© Copyright 1998-1999 GOOD2USE