Our "you need to know this" Excel manual for business.
Over 1000+ pages of useful Excel tips, formulas and strategies derived from our 20+
years of Excel training and Excel software design. It shows you everything you really need to know about using Excel in the business world.
Questions? 1.866.924.6244 Customers >
Microsoft Excel Manual Specifics
| For: |
Business Professionals |
| Format: |
ADOBE PDF and Excel Files
as zip file download |
| Covers: |
Covers beginning to
advanced general Excel topics, VBA macros are not
covered in this manual |
| Book: |
1000+ pages with Excel examples |
| Platform: |
Windows 7 - Windows 10 |
| Sent: |
Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT |
| Versions: |
Excel for Windows 2007-2016, Office 365 |
Manual Introduction. This Microsoft Excel self study manual covers all the fundamental
Microsoft Excel skills you will use in an office environment and much
much more. Our book is a combo of our beginning, intermediate and advanced Excel training. It covers general
Excel topics like formula construction, worksheet functions, chart construction, copying and pasting, worksheet formatting, sorting, filtering...etc. When you are
done with the basics, it then shows you how to build Pivot Tables and Excel tables, perform data processing, use logic and array formulas, use Data Validation and
Conditional Formatting, build dashboards, use ActiveX controls, link Excel with Word and PowerPoint, link Excel with databases and much much more.
Price: $89.00
Learning Module 1: Excel Elements and Basic Program Operation
- How to use the manual and terminology used in the manual
- Mouse terminology in the manual
- Introduction to Microsoft Excel
- Excel program interface review including how to use Excel on-line help
- How to open and close workbooks
- How to save workbooks
- How to use the Ribbon, shortcut menus, dialog boxes and hot keys
- How to arrange workbook windows
- How to create a new workbook
- How to freeze a worksheet row
- How to split a worksheet screen
- Overview of the main Excel elements that make up a workbook
Learning Module 2: How Can Excel Be Used in Business
- Discusses how Excel can be used in the business process in the areas of analysis, information
integration, VBA program development, dashboard development, rapid analysis, team integration and data processing.
Learning Module 3: Business Analysis Methods on the Worksheet
- Worksheet/cell command and control fundamentals
- How to layout and arrange business problems on the worksheet
- Business formula construction and debugging in worksheet formulas
- How to name cells and ranges and use them in business formulas
- How to type, debug and use key Excel worksheet functions
- How to type, debug and use array formulas on the worksheet
- How to format worksheets (i.e. color cells, change the font...etc.)
- How to use the Conditional Formatting and Data Validation features in Excel to create interactive business applications on the worksheet
- How to track business data using the Conditional Formatting feature
- How to protect worksheets and workbooks
- How to create business forms on the worksheet
- How to analyze sort and filter data using Excel's Sort, Auto Filter and Advanced Filter tools
- How to import text files into Excel
- How to link Excel with Word and PowerPoint
- How to create, format and use drawing shapes on the worksheet
- How to create, format and use pictures on the worksheet
- How to transmit cell values dynamically to drawing shapes to create interactive displays
- How to create Excel tables for changing worksheet data and use their structured references in formulas
- How to link to external data using Excel tables
- How to use slicers with your Excel tables to create interactive worksheet displays
- How to create and edit Pivot Tables on the worksheet
- How to perform statistics on Pivot Tables
- How to use slicers and timelines with your Pivot Tables
- How to create Pivot Charts from your Pivot Tables
- How to create, edit and use ActiveX and Form controls on the worksheet
Learning Module 4: Creating Business Charts and Reports in Excel
- Data visualization in Excel using charts
- Business chart construction using Chart Wizard
- Business chart editing and formatting techniques
- Creating various charts using effects
- Curve fitting in Excel
- Business report generation strategies in Excel
Learning Module 5: Accessing Data Bases from Microsoft Excel Using MS Query
- Overview of relational databases
- Overview of ODBC and MS Query
- How to use MS Query to access a database
- How to use MS Query to query an Excel workbook
- How to use MS Query to query a text file
- Overview of how to use Power Query
- How to use Power Query to query an Access Database
- How to use Power Query to query a text file
- How to use Power Query to query an Excel file
Learning Module 6: Problem Optimization in Excel Using Solver
- Overview of problem optimization
- How to layout an optimization problem in Excel
- Command and control worksheet overview
- How to use Solver in Microsoft Excel
- How to drive multiple workbooks using Solver
- Other design optimization packages for ExcelÂ
Learning Module 7: Linking Teams Together in Excel
- Overview of external references
- How to link Excel workbooks
- How to manage Excel workbook links
- How to distribute linked Excel workbooks
Learning Module 8: Advanced Excel Formulas
- How to extract start and end points of data
- How to use the IF worksheet function in various advanced logic scenarios
- How to summarize data using advanced logic
- How to separate (parse) text
- How to determine specific items from worksheet data
Learning Module 9: Microsoft Excel Dashboard Design
- Key Excel elements and features used in dashboard construction
- Dashboard layout and design tips
- How to make pictures and shapes go dynamic in your dashboards
- Key dashboard formulas and functions
- How to use string concatenation to assemble range and cell names dynamically in formulas
- How to use the INDIRECT, VLOOKUP, COUNTA, MATCH, SUMIFS, ADDRESS, INDEX, OFFSET, IF, AND, OR, IS, COUNTIF, TEXT,
ROW, ROWS, COLUMN, COLUMNS worksheet functions to build advanced dashboard formulas
- How to build dynamic range names that adjust to changing worksheet data
- Unique chart dashboard design
- Schedule / milestone dashboard design construction using Conditional Formatting
- Using Conditional Formatting to color tables in your dashboards
_EMAGENIT_2019.gif)
