Learn the essential Excel
skills and know how you need to succeed in today's business world.
Over 1000+ pages of key Excel topics including data entry, worksheet formatting, formula design, chart design, data processing, linking to external data, dashboards and much more.
Questions? 1.805.498.7162 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-2019, Microsoft 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, advanced
and dashboard 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 PivotTables 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
external data sources and shape it using Power Query and much much more.
Price: $89.00
Add to Cart
Our Refund Policy >
Learning Module 1:
Creating, Opening, Saving Workbooks; Controlling Workbook Views; Using
the Ribbon and Using Help
- 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 create a new workbook
- How to open and close a workbook
- How to save a workbook
- How to use the Ribbon, shortcut menus, dialog boxes and hot keys
- How to arrange workbook windows
- 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
Microsoft 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: Worksheets, Formulas, Cell Naming, Functions, Formatting and Security,
Array Formulas, Data Tools, PivotTables and ActiveX Controls
- How to create and manage worksheets in Excel
- How to type data in a worksheet cell
and how data is really stored in Excel
- How to layout and arrange business problems on the worksheet
- How to create formulas, use different
cell references and operators, perform drag and fills
- How to name cells and ranges and use them in business formulas
- How to type, debug and use Excel worksheet functions like IF, VLOOKUP, SUMIF, COUNTIF, INDEX,
SUM, MAX, MIN, ...and much much more
- How to create and use dynamic names
in formulas
- How to create, debug and use powerful array formulas on the worksheet
- How to format worksheets including cell colors, fonts, borders, merging, text alignment...
- 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
- Workbook and worksheet security
- 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 PivotTables on the worksheet
- How to perform statistics on PivotTables
- How to use slicers and timelines with your PivotTables
- How to create PivotCharts from your PivotTables
- How to create, edit and use ActiveX and Form controls on the worksheet
Learning Module 4: Creating Business Charts and
Chart Reports in Excel
- Data visualization in Excel using charts
- How charts are created and work in Excel
- How to create and edit a Chart
- Editing and formatting a chart
- Creating and Managing Chart Trend
lines
- How to create charts with a primary and secondary Y-axis
- Creating limit lines for a chart
- Printing a chart sheet
- How to layout a chart report on a worksheet and print it
Learning Module 5: Accessing Data Bases and Data Sources from Microsoft Excel Using MS Query and Power 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
- Excel dashboard formula design, debugging and
linking review
- Key logic formulas and functions that your Excel
dashboards will use
- Constructing, managing
and using range and cell names in your Excel dashboard
- How to create proper tables and
use Excel tables in your Excel dashboards
- How to create dynamic names that
automatically adjust to changing data and use them in various Excel
features
- Key worksheet functions and array
formulas used in Excel data processing
- Metric formula construction
techniques for Excel dashboards
- Learn about the different
dashboard types, benchmarks and KPI's
- Learn how to use ActiveX controls
and Data Validation to create Excel dashboard interfaces
- Learn how to link drawing shapes
with cells and pictures with ranges to create adaptive dashboard
displays
- Learn how to create and format key
Excel dashboard charts like sunburst, tree map, bubble and radar
- Learn how to create speedometer,
linear and doughnut gauge charts
- Learn how to create milestone
charts
- How to use Conditional Formatting
on the worksheet to build various status, project and timeline
displays
- How to create custom map displays
on the worksheet
- Learn how to use Microsoft Query,
Power Query and various OLEDB tools to automatically query and
filter external dashboard data
- Learn how to utilize PivotTables,
PivotCharts, slicers, timelines and various PivotTable
calculations to build dashboard displays
- Learn how to create custom VBA
worksheet functions that can perform amazing calculations