Covers the key beginning to advanced Excel topics needed to solve your Excel tasks quickly.
- Key topics include data entry, worksheet formatting, formulas, functions, chart design, data processing, external data linking, and dashboards.
- Over 1200+ pages of must know Excel topics.
- 100's of examples like the ones below.
- Proven strategies that will solve your questions and problems.
Price: $49.00
Manual specs.
| For: | General audience |
| 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: | 1200+ 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 2010-2019, Microsoft 365 |
What's in our manual.
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 manual 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. *Learning modules below are part of our premium manual: TCEM >
< < < Scroll Picture > > >
Actual Manual Problems
* Our learning modules below come from our all-in-one manual: The Complete Excel Manual >
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
- Discusses how Excel can be used 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 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 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 applications on the worksheet
- How to track data using the Conditional Formatting feature
- Workbook and worksheet security
- How to create 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 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