Microsoft Excel is one of the most powerful data analysis software program. It has tons of features and tools allow you to do thousands of complicated task, that no one can't do without it. The only problem is that there are many things you have to know before you start using it. "Excel Basic" become a big help for the students and professionals who demand the missing piece in their life. This book will give a full picture of Microsoft Excel in depth, things that you need to learn at the beginning when using Excel. In this book You will learn about some new excel functions/tools/tasks on simple mode as well as in professional mode so you will be able to do every task in Excel from easy to difficult with fully functional instructions.
DAY 1: The Basics of Excel
• Excel New Look and Feel
• Personalizing the Quick Access Toolbar
• Exploring your Options
• Using Office Add-ins
• Using Excel’s own add-ins
• Spreadsheet Design
• Kinds of Cell Entries
• Basics of Data Entry
• Saving your Data
• Document Recovery
• Selecting cells
• Handling Columns and Rows
• Formatting Tables
• Cell Styles
• Conditional Formatting
• Different ways to print
• Page Setup Options
• Using Print Options
• Headers and Footers
• Page Break
• What you need to know about formulas
• How to Copy Formulas
• Array Formulas
• Range Names
• Linking Formulas
• Formula Recalculation
• Circular References
• Error Values
• Error Trapping
• Logical Functions
• Formula Auditing
• Error Checking
• Removing Errors in Printout
• Understanding Date and Time
• Date functions
• Time Functions
• Basics of Financial Functions
• PV, NPV and FV
• PMT Function
• Depreciation Functions
DAY 2: Formulas
• Math and Trigonometry Functions
• Statistical Functions
• Protecting the Workbook with a Password
• Protecting the Worksheet
• The Basics of Hyperlinks
• Using the HYPERLINK Function
• Sharing Workbooks Online
• Basics of Excel Data Sharing
• Exporting Workbooks to Different Usable File Formats
• The Basics of Worksheet Charting
• Adding Sparkline Graphics
• Adding Infographics
• Printing Charts
• Basics of Graphic Objects
• Different Types of Graphics
• Drawing Graphic Objects
• Adding Screenshots
• Themes
• The Basics of Data Lists
• Data Sorting
• Sub-totalling Your Data
• Data List Filtering
• Filtering Data
• Database Functions
• External Data Query
• Data Tables
• Exploring Different Scenarios
• Hide and Goal Seeking
• Using the Solver
• Building Pivot Tables
• Modifying the Pivot Table
• Creating Pivot Charts
• Creating Forecast Worksheets
