| Code |
Lesson & Link |
Description |
Lesson Name |
Lesson URL |
Lesson Image URL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Home |
Microsoft Access
|
Use this spreadsheet to copy links to the skills you want to share or teach. Lessons are bite-sized, focus on a single skill & take about 3 to 5 minutes to complete. |
Access Training |
https://www.customguide.com/access |
https://www.customguide.com/images/subject/access-course.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.00 |
Access Fundamentals |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.01 |
Understand the Screen |
Understand the Access Screen |
Understand the Screen |
https://www.customguide.com/access/how-do-you-hide-the-ribbon-in-access |
https://www.customguide.com/images/pages/access/how-do-you-hide-the-ribbon-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.02 |
Open and Save a Database |
How to Open a Database in Access |
Open and Save a Database |
https://www.customguide.com/access/open-access-database |
https://www.customguide.com/images/pages/access/open-access-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.03 |
Work with Database Objects |
How to Work with Database Objects in Access |
Work with Database Objects |
https://www.customguide.com/access/access-database |
https://www.customguide.com/images/pages/access/access-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.04 |
Tour of Tables |
Tour of Tables in Access |
Tour of Tables |
https://www.customguide.com/access/access-tables |
https://www.customguide.com/images/pages/access/access-tables.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.05 |
Tour of Queries |
Tour of Queries in Access |
Tour of Queries |
https://www.customguide.com/access/tour-of-queries |
https://www.customguide.com/images/pages/access/tour-of-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.06 |
Tour of Forms |
How to Add a Record in Access |
Tour of Forms |
https://www.customguide.com/access/access-forms |
https://www.customguide.com/images/pages/access/access-forms.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.07 |
Tour of Reports |
Tour of Reports in Access |
Tour of Reports |
https://www.customguide.com/access/access-reports |
https://www.customguide.com/images/pages/access/access-reports.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.08 |
Help |
How to Get Help in Access |
Help |
https://www.customguide.com/access/microsoft-access-help |
https://www.customguide.com/images/pages/access/microsoft-access-help.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.09 |
Close and Exit Access |
How to Close and Exit Access |
Close and Exit Access |
https://www.customguide.com/access/close-and-exit-access |
https://www.customguide.com/images/pages/access/close-and-exit-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.00 |
Work with Databases |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.01 |
Plan a Database |
How to Plan a Database in Access |
Plan a Database |
https://www.customguide.com/access/plan-a-database |
https://www.customguide.com/images/pages/access/plan-a-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.02 |
Create a Database |
How to Create a Database in Access |
Create a Database |
https://www.customguide.com/access/how-to-create-a-database-in-access |
https://www.customguide.com/images/pages/access/how-to-create-a-database-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.03 |
Add, Edit, and Delete Records |
How to Add, Edit, and Delete Records in Access |
Add, Edit, and Delete Records |
https://www.customguide.com/access/how-to-delete-a-record-in-access |
https://www.customguide.com/images/pages/access/how-to-delete-a-record-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.04 |
Select Data |
How to Select Data in Access |
Select Data |
https://www.customguide.com/access/select-data |
https://www.customguide.com/images/pages/access/select-data.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.05 |
Cut, Copy, and Paste Data |
How to Cut, Copy, and Paste Data in Access |
Cut, Copy, and Paste Data |
https://www.customguide.com/access/cut-copy-and-paste-data |
https://www.customguide.com/images/pages/access/cut-copy-and-paste-data.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.06 |
Use Undo and Redo |
How to Use Undo and Redo in Access |
Use Undo and Redo |
https://www.customguide.com/access/how-to-undo-in-access |
https://www.customguide.com/images/pages/access/how-to-undo-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.07 |
Check Spelling |
How to Check your Spelling in Access |
Check Spelling |
https://www.customguide.com/access/access-spell-check |
https://www.customguide.com/images/pages/access/access-spell-check.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.08 |
Use the Zoom Box |
How to Use the Zoom Box in Access |
Use the Zoom Box |
https://www.customguide.com/access/zoom-dialog-box-access |
https://www.customguide.com/images/pages/access/zoom-dialog-box-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.09 |
Preview and Print |
How to Preview and Print in Access |
Preview and Print |
https://www.customguide.com/access/access-print |
https://www.customguide.com/images/pages/access/access-print.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.00 |
Work with Data |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.01 |
Find and Replace Data |
How to Find and Replace Data in Access |
Find and Replace Data |
https://www.customguide.com/access/how-to-use-the-find-and-replace-tool-in-access |
https://www.customguide.com/images/pages/access/how-to-use-the-find-and-replace-tool-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.02 |
Sort Records |
How to Sort Records in Access |
Sort Records |
https://www.customguide.com/access/access-sort |
https://www.customguide.com/images/pages/access/access-sort.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.03 |
Use Common Filters |
How to Use Common Filters in Access |
Use Common Filters |
https://www.customguide.com/access/access-form-filters |
https://www.customguide.com/images/pages/access/access-form-filters.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.04 |
Filter by Selection |
How to Filter by Selection in Access |
Filter by Selection |
https://www.customguide.com/access/filter-by-selection-access |
https://www.customguide.com/images/pages/access/filter-by-selection-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.05 |
Filter by Form |
How to Filter by Form in Access |
Filter by Form |
https://www.customguide.com/access/filter-by-form-access |
https://www.customguide.com/images/pages/access/filter-by-form-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.06 |
Create an Advanced Filter |
How to Create an Advanced Filter in Access |
Create an Advanced Filter |
https://www.customguide.com/access/microsoft-access-operators |
https://www.customguide.com/images/pages/access/microsoft-access-operators.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.07 |
Adjust Rows and Columns |
How to Adjust Rows and Columns in Access |
Adjust Rows and Columns |
https://www.customguide.com/access/how-to-autofit-in-access |
https://www.customguide.com/images/pages/access/how-to-autofit-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.08 |
Change Gridlines and Cell Effects |
How to Change Gridlines and Cell Effects in Access |
Change Gridlines and Cell Effects |
https://www.customguide.com/access/change-gridlines-and-cell-effects |
https://www.customguide.com/images/pages/access/change-gridlines-and-cell-effects.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.09 |
Freeze a Column |
How to Freeze a Column in Access |
Freeze a Column |
https://www.customguide.com/access/freeze-a-column |
https://www.customguide.com/images/pages/access/freeze-a-column.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.10 |
Hide a Column |
How to Hide a Column in Access |
Hide a Column |
https://www.customguide.com/access/hide-a-column |
https://www.customguide.com/images/pages/access/hide-a-column.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.00 |
Tables |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.01 |
Create a Table |
How to Create a Table in Access |
Create a Table |
https://www.customguide.com/access/how-to-create-a-table-in-access |
https://www.customguide.com/images/pages/access/how-to-create-a-table-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.02 |
Understand Field Types and Properties |
How to Understand Field Types and Properties in Access |
Understand Field Types and Properties |
https://www.customguide.com/access/access-data-types |
https://www.customguide.com/images/pages/access/access-data-types.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.03 |
Index a Field |
How to Index a Field in Access |
Index a Field |
https://www.customguide.com/access/index-a-field |
https://www.customguide.com/images/pages/access/index-a-field.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.04 |
Add a Primary Key and Auto-Increment Fields |
How to Add a Primary Key and Auto-Increment Fields in Access |
Add a Primary Key and Auto-Increment Fields |
https://www.customguide.com/access/add-a-primary-key-and-auto-increment-fields |
https://www.customguide.com/images/pages/access/add-a-primary-key-and-auto-increment-fields.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.05 |
Insert, Reorder, and Delete Fields |
How to Insert, Reorder, and Delete Fields in Access |
Insert, Reorder, and Delete Fields |
https://www.customguide.com/access/insert-reorder-and-delete-fields |
https://www.customguide.com/images/pages/access/insert-reorder-and-delete-fields.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.06 |
Add Field Descriptions and Captions |
How to Add Field Descriptions and Captions in Access |
Add Field Descriptions and Captions |
https://www.customguide.com/access/how-to-add-a-caption-to-a-field-in-access |
https://www.customguide.com/images/pages/access/how-to-add-a-caption-to-a-field-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.07 |
Change the Field Size |
How to Change the Field Size in Access |
Change the Field Size |
https://www.customguide.com/access/how-to-change-field-size-in-access |
https://www.customguide.com/images/pages/access/how-to-change-field-size-in-access.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.08 |
Format Number, Currency, and Date/Time Fields |
How to Format Number, Currency, and Date/Time Fields in Access |
Format Number, Currency, and Date/Time Fields |
https://www.customguide.com/access/format-number-currency-and-date-time-fields |
https://www.customguide.com/images/pages/access/format-number-currency-and-date-time-fields.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.09 |
Format Text Fields |
How to Format Text Fields in Access |
Format Text Fields |
https://www.customguide.com/access/format-text-fields |
https://www.customguide.com/images/pages/access/format-text-fields.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.10 |
Set a Default Value |
How to Set a Default Value in Access |
Set a Default Value |
https://www.customguide.com/access/set-a-default-value |
https://www.customguide.com/images/pages/access/set-a-default-value.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.11 |
Require Data Entry |
How to Require Data Entry in Access |
Require Data Entry |
https://www.customguide.com/access/require-data-entry |
https://www.customguide.com/images/pages/access/require-data-entry.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.12 |
Validate Data |
How to Validate Data in Access |
Validate Data |
https://www.customguide.com/access/validate-data |
https://www.customguide.com/images/pages/access/validate-data.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.13 |
Create an Input Mask |
How to Create an Input Mask in Access |
Create an Input Mask |
https://www.customguide.com/access/create-an-input-mask |
https://www.customguide.com/images/pages/access/create-an-input-mask.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.14 |
Create a Lookup Field |
How to Create a Lookup Field in Access |
Create a Lookup Field |
https://www.customguide.com/access/create-a-lookup-field |
https://www.customguide.com/images/pages/access/create-a-lookup-field.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.15 |
Create a Value List |
How to Create a Value List in Access |
Create a Value List |
https://www.customguide.com/access/create-a-value-list |
https://www.customguide.com/images/pages/access/create-a-value-list.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.16 |
Modify a Lookup List |
How to Modify a Lookup List in Access |
Modify a Lookup List |
https://www.customguide.com/access/modify-a-lookup-list |
https://www.customguide.com/images/pages/access/modify-a-lookup-list.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.17 |
Add Total Rows |
How to Add Total Rows in Access |
Add Total Rows |
https://www.customguide.com/access/add-total-rows |
https://www.customguide.com/images/pages/access/add-total-rows.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.00 |
Create Relational Databases |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.01 |
Table Relationships and Relationship Types |
Understand Table Relationships and Relationship Types in Access |
Table Relationships and Relationship Types |
https://www.customguide.com/access/table-relationships-and-relationship-types |
https://www.customguide.com/images/pages/access/table-relationships-and-relationship-types.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.02 |
Create Relationships Between Tables |
How to Create Relationships Between Tables in Access |
Create Relationships Between Tables |
https://www.customguide.com/access/create-relationships-between-tables |
https://www.customguide.com/images/pages/access/create-relationships-between-tables.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.03 |
Enforce Referential Integrity |
How to Enforce Referential Integrity in Access |
Enforce Referential Integrity |
https://www.customguide.com/access/enforce-referential-integrity |
https://www.customguide.com/images/pages/access/enforce-referential-integrity.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.04 |
Print and Delete Relationships |
How to Print and Delete Relationships in Access |
Print and Delete Relationships |
https://www.customguide.com/access/print-and-delete-relationships |
https://www.customguide.com/images/pages/access/print-and-delete-relationships.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.00 |
Work with Queries |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.01 |
Create a Query |
How to Create a Query in Access |
Create a Query |
https://www.customguide.com/access/create-a-query |
https://www.customguide.com/images/pages/access/create-a-query.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.02 |
Hide, Remove, and Sort Fields |
How to Hide, Remove, and Sort Fields in Access |
Hide, Remove, and Sort Fields |
https://www.customguide.com/access/hide-remove-and-sort-fields |
https://www.customguide.com/images/pages/access/hide-remove-and-sort-fields.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.03 |
Use AND and OR Operators in a Query |
How to Use AND and OR Operators in a Query in Access |
Use AND and OR Operators in a Query |
https://www.customguide.com/access/use-and-and-or-operators-in-a-query |
https://www.customguide.com/images/pages/access/use-and-and-or-operators-in-a-query.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.04 |
Create a Multiple Table Query |
How to Create a Multiple Table Query in Access |
Create a Multiple Table Query |
https://www.customguide.com/access/create-a-multiple-table-query |
https://www.customguide.com/images/pages/access/create-a-multiple-table-query.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.05 |
Create a Calculated Field |
How to Create a Calculated Field in Access |
Create a Calculated Field |
https://www.customguide.com/access/create-a-calculated-field |
https://www.customguide.com/images/pages/access/create-a-calculated-field.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.06 |
Work with Expressions and the Expression Builder |
How to Work with Expressions and the Expression Builder in Access |
Work with Expressions and the Expression Builder |
https://www.customguide.com/access/work-with-expressions-and-the-expression-builder |
https://www.customguide.com/images/pages/access/work-with-expressions-and-the-expression-builder.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.07 |
Format Fields within Queries |
How to Format Fields within Queries in Access |
Format Fields within Queries |
https://www.customguide.com/access/format-fields-within-queries |
https://www.customguide.com/images/pages/access/format-fields-within-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.08 |
Use an IIF Function |
How to Use an IIF Function in Access |
Use an IIF Function |
https://www.customguide.com/access/use-an-iif-function |
https://www.customguide.com/images/pages/access/use-an-iif-function.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.09 |
Summarize Groups of Records |
How to Summarize Groups of Records in Access |
Summarize Groups of Records |
https://www.customguide.com/access/summarize-groups-of-records |
https://www.customguide.com/images/pages/access/summarize-groups-of-records.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.10 |
Display Top or Bottom Values |
How to Display Top or Bottom Values in Access |
Display Top or Bottom Values |
https://www.customguide.com/access/display-top-or-bottom-values |
https://www.customguide.com/images/pages/access/display-top-or-bottom-values.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.11 |
Parameter Queries |
How to Create Parameter Queries in Access |
Parameter Queries |
https://www.customguide.com/access/parameter-queries |
https://www.customguide.com/images/pages/access/parameter-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.12 |
Find Duplicate Records |
How to Find Duplicate Records in Access |
Find Duplicate Records |
https://www.customguide.com/access/find-duplicate-records |
https://www.customguide.com/images/pages/access/find-duplicate-records.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.13 |
Find Unmatched Records |
How to Find Unmatched Records in Access |
Find Unmatched Records |
https://www.customguide.com/access/find-unmatched-records |
https://www.customguide.com/images/pages/access/find-unmatched-records.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.14 |
Crosstab Queries |
How to Create Crosstab Queries in Access |
Crosstab Queries |
https://www.customguide.com/access/crosstab-queries |
https://www.customguide.com/images/pages/access/crosstab-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.15 |
Delete Queries |
How to Create Delete Queries in Access |
Delete Queries |
https://www.customguide.com/access/delete-queries |
https://www.customguide.com/images/pages/access/delete-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.16 |
Append Queries |
How to Create Append Queries in Access |
Append Queries |
https://www.customguide.com/access/append-queries |
https://www.customguide.com/images/pages/access/append-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.17 |
Make-Table Queries |
How to Create Make Table Queries in Access |
Make-Table Queries |
https://www.customguide.com/access/make-table-queries |
https://www.customguide.com/images/pages/access/make-table-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.18 |
Update Queries |
How to Create Update Queries in Access |
Update Queries |
https://www.customguide.com/access/update-queries |
https://www.customguide.com/images/pages/access/update-queries.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.00 |
Work with Forms |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.01 |
Create a Form with the Form Wizard |
How to Create a Form with the Form Wizard in Access |
Create a Form with the Form Wizard |
https://www.customguide.com/access/create-a-form-with-the-form-wizard |
https://www.customguide.com/images/pages/access/create-a-form-with-the-form-wizard.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.02 |
Create and Use a Form |
How to Create and Use a Form in Access |
Create and Use a Form |
https://www.customguide.com/access/create-and-use-a-form |
https://www.customguide.com/images/pages/access/create-and-use-a-form.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.03 |
Modify a Form in Layout View |
How to Modify a Form in Layout View in Access |
Modify a Form in Layout View |
https://www.customguide.com/access/modify-a-form-in-layout-view |
https://www.customguide.com/images/pages/access/modify-a-form-in-layout-view.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.04 |
Form Design View Basics |
How to Use Form Design View in Access |
Form Design View Basics |
https://www.customguide.com/access/form-design-view-basics |
https://www.customguide.com/images/pages/access/form-design-view-basics.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.05 |
Change the Tab Order |
How to Change the Tab Order in Access |
Change the Tab Order |
https://www.customguide.com/access/change-the-tab-order |
https://www.customguide.com/images/pages/access/change-the-tab-order.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.06 |
Work with Control Properties |
How to Work with Control Properties in Access |
Work with Control Properties |
https://www.customguide.com/access/work-with-control-properties |
https://www.customguide.com/images/pages/access/work-with-control-properties.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.07 |
Work with Form Properties |
How to Work with Form Properties in Access |
Work with Form Properties |
https://www.customguide.com/access/work-with-form-properties |
https://www.customguide.com/images/pages/access/work-with-form-properties.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.08 |
Change a Controls Data Source |
How to Change a Controls Data Source in Access |
Change a Controls Data Source |
https://www.customguide.com/access/change-a-controls-data-source |
https://www.customguide.com/images/pages/access/change-a-controls-data-source.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.09 |
Create a Calculated Control |
How to Create a Calculated Control in Access |
Create a Calculated Control |
https://www.customguide.com/access/create-a-calculated-control |
https://www.customguide.com/images/pages/access/create-a-calculated-control.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.10 |
Change a Controls Default Value |
How to Change a Controls Default Value in Access |
Change a Controls Default Value |
https://www.customguide.com/access/change-a-controls-default-value |
https://www.customguide.com/images/pages/access/change-a-controls-default-value.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.11 |
Create a Subform |
How to Create a Subform in Access |
Create a Subform |
https://www.customguide.com/access/create-a-subform |
https://www.customguide.com/images/pages/access/create-a-subform.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.12 |
Work with and Modify Subforms |
How to Work with and Modify Subforms in Access |
Work with and Modify Subforms |
https://www.customguide.com/access/work-with-and-modify-subforms |
https://www.customguide.com/images/pages/access/work-with-and-modify-subforms.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.13 |
Create and Modify a Navigation Form |
How to Create and Modify a Navigation Form in Access |
Create and Modify a Navigation Form |
https://www.customguide.com/access/create-and-modify-a-navigation-form |
https://www.customguide.com/images/pages/access/create-and-modify-a-navigation-form.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.00 |
Work with Reports |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.01 |
Create a Report |
How to Create a Report in Access |
Create a Report |
https://www.customguide.com/access/create-a-report |
https://www.customguide.com/images/pages/access/create-a-report.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.02 |
Use the Report Wizard |
How to Use the Report Wizard in Access |
Use the Report Wizard |
https://www.customguide.com/access/use-the-report-wizard |
https://www.customguide.com/images/pages/access/use-the-report-wizard.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.03 |
Use the Label Wizard |
How to Use the Label Wizard in Access |
Use the Label Wizard |
https://www.customguide.com/access/use-the-label-wizard |
https://www.customguide.com/images/pages/access/use-the-label-wizard.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.04 |
Work in Layout View |
How to Work in Layout View in Access |
Work in Layout View |
https://www.customguide.com/access/work-in-layout-view |
https://www.customguide.com/images/pages/access/work-in-layout-view.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.05 |
Format Fonts |
How to Format Fonts in Access |
Format Fonts |
https://www.customguide.com/access/format-fonts |
https://www.customguide.com/images/pages/access/format-fonts.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.06 |
Copy Formatting |
How to Copy Formatting in Access |
Copy Formatting |
https://www.customguide.com/access/copy-formatting |
https://www.customguide.com/images/pages/access/copy-formatting.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.07 |
Change Text Alignment |
How to Change Text Alignment in Access |
Change Text Alignment |
https://www.customguide.com/access/change-text-alignment |
https://www.customguide.com/images/pages/access/change-text-alignment.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.08 |
Insert a Logo and Background Image |
How to Insert a Logo and Background Image in Access |
Insert a Logo and Background Image |
https://www.customguide.com/access/insert-a-logo-and-background-image |
https://www.customguide.com/images/pages/access/insert-a-logo-and-background-image.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.09 |
Adjust Page Margin and Orientation |
How to the Adjust Page Margin and Orientation in Access |
Adjust Page Margin and Orientation |
https://www.customguide.com/access/adjust-page-margin-and-orientation |
https://www.customguide.com/images/pages/access/adjust-page-margin-and-orientation.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.10 |
Add Page Numbers and Dates |
How to Add Page Numbers and Dates in Access |
Add Page Numbers and Dates |
https://www.customguide.com/access/add-page-numbers-and-dates |
https://www.customguide.com/images/pages/access/add-page-numbers-and-dates.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.11 |
Group and Sort |
How to Group and Sort in Access |
Group and Sort |
https://www.customguide.com/access/group-and-sort |
https://www.customguide.com/images/pages/access/group-and-sort.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.12 |
Summarize Data using Totals |
How to Summarize Data using Totals in Access |
Summarize Data using Totals |
https://www.customguide.com/access/summarize-data-using-totals |
https://www.customguide.com/images/pages/access/summarize-data-using-totals.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.13 |
Understand Report Sections |
How to Understand Report Sections in Access |
Understand Report Sections |
https://www.customguide.com/access/understand-report-sections |
https://www.customguide.com/images/pages/access/understand-report-sections.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.00 |
Advanced Topics |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.01 |
Use Conditional Formatting |
How to Use Conditional Formatting in Access |
Use Conditional Formatting |
https://www.customguide.com/access/use-conditional-formatting |
https://www.customguide.com/images/pages/access/use-conditional-formatting.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.02 |
Work with Number Formatting |
How to Work with Number Formatting in Access |
Work with Number Formatting |
https://www.customguide.com/access/work-with-number-formatting |
https://www.customguide.com/images/pages/access/work-with-number-formatting.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.03 |
Use Themes |
How to Use Themes in Access |
Use Themes |
https://www.customguide.com/access/use-themes |
https://www.customguide.com/images/pages/access/use-themes.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.04 |
Import Information |
How to Import Information in Access |
Import Information |
https://www.customguide.com/access/import-information |
https://www.customguide.com/images/pages/access/import-information.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.05 |
Export Information |
How to Export Information from Access |
Export Information |
https://www.customguide.com/access/export-information |
https://www.customguide.com/images/pages/access/export-information.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.06 |
Link External Information |
How to Link External Information in Access |
Link External Information |
https://www.customguide.com/access/link-external-information |
https://www.customguide.com/images/pages/access/link-external-information.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.07 |
Mail Merge Records to Word |
How to Create a Word Merge with Access Data |
Mail Merge Records to Word |
https://www.customguide.com/access/mail-merge-records-to-word |
https://www.customguide.com/images/pages/access/mail-merge-records-to-word.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.08 |
Use Hyperlink Fields |
How to Use Hyperlink Fields in Access |
Use Hyperlink Fields |
https://www.customguide.com/access/use-hyperlink-fields |
https://www.customguide.com/images/pages/access/use-hyperlink-fields.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.09 |
Database Object Dependencies |
How to Database Object Dependencies in Access |
Database Object Dependencies |
https://www.customguide.com/access/database-object-dependencies |
https://www.customguide.com/images/pages/access/database-object-dependencies.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.10 |
Compact and Repair a Database |
How to Compact and Repair a Database in Access |
Compact and Repair a Database |
https://www.customguide.com/access/compact-and-repair-a-database |
https://www.customguide.com/images/pages/access/compact-and-repair-a-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.11 |
Convert an Access Database |
How to Convert an Access Database |
Convert an Access Database |
https://www.customguide.com/access/convert-an-access-database |
https://www.customguide.com/images/pages/access/convert-an-access-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.12 |
Back Up and Restore a Database |
How to Back Up and Restore a Database in Access |
Back Up and Restore a Database |
https://www.customguide.com/access/back-up-and-restore-a-database |
https://www.customguide.com/images/pages/access/back-up-and-restore-a-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.13 |
Password Protect a Database |
How to Password Protect a Database in Access |
Password Protect a Database |
https://www.customguide.com/access/password-protect-a-database |
https://www.customguide.com/images/pages/access/password-protect-a-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.14 |
Split a Database |
How to Split a Database in Access |
Split a Database |
https://www.customguide.com/access/split-a-database |
https://www.customguide.com/images/pages/access/split-a-database.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Code |
Lesson & Link |
Description |
Lesson Name |
Lesson URL |
Lesson Image URL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Home |
Microsoft Excel
|
Use this spreadsheet to copy links to the skills you want to share or teach. Lessons are bite-sized, focus on a single skill & take about 3 to 5 minutes to complete. |
Excel Training |
https://www.customguide.com/excel |
https://www.customguide.com/images/subject/excel-course.png |
Microsoft Excel Español |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.00 |
Excel Fundamentals |
Basic Skills |
|
|
|
Inicio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.01 |
Understand the Excel Screen |
Understand the Excel Screen |
Understand the Excel Screen |
https://www.customguide.com/excel/excel-ribbon |
https://www.customguide.com/images/pages/excel/excel-ribbon.png |
Entender la Pantalla de Excel |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.02 |
Create Workbooks |
How to create blank & template-based workbooks in Excel |
Create Workbooks |
https://www.customguide.com/excel/how-to-make-an-excel-spreadsheet |
https://www.customguide.com/images/pages/excel/how-to-make-an-excel-spreadsheet.png |
Crear un Libro de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.03 |
Navigate Worksheets |
How to Navigate Worksheets in Excel |
Navigate Worksheets |
https://www.customguide.com/excel/navigate-worksheets |
https://www.customguide.com/images/pages/excel/navigate-worksheets.png |
Navegar en una Hoja de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.04 |
Open Workbooks |
How to Open Workbooks in Excel |
Open Workbooks |
https://www.customguide.com/excel/open-excel-workbook |
https://www.customguide.com/images/pages/excel/open-excel-workbook.png |
Abrir un Libro de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.05 |
Save Workbooks |
How to Save Workbooks in Excel |
Save Workbooks |
https://www.customguide.com/excel/how-to-save-in-excel |
https://www.customguide.com/images/pages/excel/how-to-save-in-excel.png |
Guardar un Libro de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.06 |
AutoRecover |
How to AutoRecover Excel Files |
AutoRecover |
https://www.customguide.com/excel/recover-excel-file |
https://www.customguide.com/images/pages/excel/recover-excel-file.png |
Autorrecuperación |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.07 |
The Quick Access Toolbar |
How to Use The Quick Access Toolbar in Excel |
The Quick Access Toolbar |
https://www.customguide.com/excel/excel-quick-access-toolbar |
https://www.customguide.com/images/pages/excel/excel-quick-access-toolbar.png |
La Barra de Herramientas de Acceso Rápido |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.08 |
Print |
How to Print in Excel |
Print |
https://www.customguide.com/excel/how-to-print-in-excel |
https://www.customguide.com/images/pages/excel/how-to-print-in-excel.png |
Imprimir |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.09 |
Help |
How to Get Help in Excel |
Help |
https://www.customguide.com/excel/get-help-with-excel |
https://www.customguide.com/images/pages/excel/get-help-with-excel.png |
Ayuda |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1.10 |
Close and Exit |
How to Close and Exit from Excel |
Close and Exit |
https://www.customguide.com/excel/excel-close-workbook |
https://www.customguide.com/images/pages/excel/excel-close-workbook.png |
Cerrar y Salir |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.00 |
Edit a Workbook |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.01 |
Select Cells and Ranges |
How to Select Cells and Ranges in Excel |
Select Cells and Ranges |
https://www.customguide.com/excel/how-to-select-multiple-cells-in-excel |
https://www.customguide.com/images/pages/excel/how-to-select-multiple-cells-in-excel.png |
Seleccionar Celdas y Rangos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.02 |
Edit Cell Data |
How to Edit Cell Data in Excel |
Edit Cell Data |
https://www.customguide.com/excel/how-to-edit-cells-in-excel |
https://www.customguide.com/images/pages/excel/how-to-edit-cells-in-excel.png |
Editar Datos de Celdas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.03 |
Cut, Copy, and Paste |
How to Cut, Copy, and Paste in Excel |
Cut, Copy, and Paste |
https://www.customguide.com/excel/how-to-copy-and-paste-in-excel |
https://www.customguide.com/images/pages/excel/how-to-copy-and-paste-in-excel.png |
Cortar, Copiar y Pegar |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.04 |
Undo, Redo, Repeat |
How to Use Undo, Redo, Repeat Commands in Excel |
Undo, Redo, Repeat |
https://www.customguide.com/excel/undo-in-excel |
https://www.customguide.com/images/pages/excel/undo-in-excel.png |
Deshacer, Rehacer y Repetir |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.05 |
More Pasting Options |
How to Use Special Paste Options in Excel |
More Pasting Options |
https://www.customguide.com/excel/paste-special-excel |
https://www.customguide.com/images/pages/excel/paste-special-excel.png |
Más opciones de pegado |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.06 |
Insert and Move Cells |
How to Insert and Move Cells in Excel |
Insert and Move Cells |
https://www.customguide.com/excel/how-to-move-cells-in-excel |
https://www.customguide.com/images/pages/excel/how-to-move-cells-in-excel.png |
Insertar y Mover Celdas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.07 |
Delete Cells |
How to Delete Cells in Excel |
Delete Cells |
https://www.customguide.com/excel/how-to-delete-cells-in-excel |
https://www.customguide.com/images/pages/excel/how-to-delete-cells-in-excel.png |
Eliminar Celdas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.08 |
Check Spelling |
Learn how you use Excel's spell check to proof your worksheets for spelling errors. |
Check Spelling |
https://www.customguide.com/excel/spell-check-in-excel |
https://www.customguide.com/images/pages/excel/spell-check-in-excel.png |
Revisión de Ortografía |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.09 |
Find and Replace Text |
How to Use Find and Replace in Excel |
Find and Replace Text |
https://www.customguide.com/excel/find-and-replace-in-excel |
https://www.customguide.com/images/pages/excel/find-and-replace-in-excel.png |
Buscar y Reemplazar Texto |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.10 |
Hide Columns and Rows |
How to Hide Columns and Rows in Excel |
Hide Columns and Rows |
https://www.customguide.com/excel/how-to-unhide-columns-in-excel |
https://www.customguide.com/images/pages/excel/how-to-unhide-columns-in-excel.png |
Ocultar Filas y Columnas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2.11 |
Document Properties |
How to View and Edit Document Properties in Excel |
Document Properties |
https://www.customguide.com/excel/excel-document-properties |
https://www.customguide.com/images/pages/excel/excel-document-properties.png |
Propiedades del Documento |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.00 |
Basic Formulas |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.01 |
Formula Basics |
How to Create Basic Formulas in Excel |
Formula Basics |
https://www.customguide.com/excel/excel-formulas |
https://www.customguide.com/images/pages/excel/excel-formulas.png |
Conceptos Básicos de Fórmulas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.02 |
AutoFill |
How to Use AutoFill in Excel |
AutoFill |
https://www.customguide.com/excel/autofill-excel |
https://www.customguide.com/images/pages/excel/autofill-excel.png |
AutoRellenar |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.03 |
Sums and Averages |
How to Use Sum and Average Formulas in Excel |
Sums and Averages |
https://www.customguide.com/excel/excel-sum-formula |
https://www.customguide.com/images/pages/excel/excel-sum-formula.png |
Sumas y Promedios |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.04 |
MIN and MAX |
How to Use MIN and MAX Functions in Microsoft Excel |
MIN and MAX |
https://www.customguide.com/excel/excel-max-function |
https://www.customguide.com/images/pages/excel/excel-max-function.png |
MIN y MAX |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3.05 |
COUNT |
How to Use the COUNT Function in Excel |
COUNT |
https://www.customguide.com/excel/excel-count |
https://www.customguide.com/images/pages/excel/excel-count.png |
CONTAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.00 |
Basic Formatting |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.01 |
Format Text |
How to Apply Formatting to Text in Excel |
Format Text |
https://www.customguide.com/excel/how-to-format-text-in-excel |
https://www.customguide.com/images/pages/excel/how-to-format-text-in-excel.png |
Formato de Texto |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.02 |
Align and Merge Cells |
How to Align and Merge Cells in Excel |
Align and Merge Cells |
https://www.customguide.com/excel/how-to-merge-cells-in-excel |
https://www.customguide.com/images/pages/excel/how-to-merge-cells-in-excel.png |
Alinear y Combinar Celdas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.03 |
Format Numbers and Dates |
How to Format Numbers and Dates in Excel |
Format Numbers and Dates |
https://www.customguide.com/excel/how-to-change-date-format-in-excel |
https://www.customguide.com/images/pages/excel/how-to-change-date-format-in-excel.png |
Formato de Números y Fechas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.04 |
Borders and Background Colors |
How to Add Cell Borders and Background Colors in Excel |
Borders and Background Colors |
https://www.customguide.com/excel/how-to-add-borders-in-excel |
https://www.customguide.com/images/pages/excel/how-to-add-borders-in-excel.png |
Bordes y Colores de Fondo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.05 |
Copy Formatting |
How to Copy Formatting in Excel |
Copy Formatting |
https://www.customguide.com/excel/format-painter-excel |
https://www.customguide.com/images/pages/excel/format-painter-excel.png |
Copiar Formato |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4.06 |
Row Heights and Column Widths |
How to Adjust Row Heights and Column Widths in Excel |
Row Heights and Column Widths |
https://www.customguide.com/excel/autofit-excel |
https://www.customguide.com/images/pages/excel/autofit-excel.png |
Altura de Filas y Ancho de Columnas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.00 |
Insert Objects |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.01 |
Images |
How to Insert Images in Excel |
Images |
https://www.customguide.com/excel/insert-picture-into-excel-cell |
https://www.customguide.com/images/pages/excel/insert-picture-into-excel-cell.png |
Insertar una Imágen |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.02 |
Shapes |
How to Insert and Format Shapes in Excel |
Shapes |
https://www.customguide.com/excel/excel-shapes |
https://www.customguide.com/images/pages/excel/excel-shapes.png |
Cuadros de Texto y Formas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.03 |
Hyperlinks |
How to Insert Hyperlinks in Excel |
Hyperlinks |
https://www.customguide.com/excel/hyperlink-in-excel |
https://www.customguide.com/images/pages/excel/hyperlink-in-excel.png |
Hipervínculos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5.04 |
Object Properties and Alt Text |
How to Adjust Object Properties and Alt Text in Excel |
Object Properties and Alt Text |
https://www.customguide.com/excel/excel-object-properties |
https://www.customguide.com/images/pages/excel/excel-object-properties.png |
Propiedades de Objeto y Texto Alternativo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.00 |
Manage Worksheets |
Basic Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.01 |
View Worksheets |
How to Change Worksheet Views in Excel |
View Worksheets |
https://www.customguide.com/excel/zoom-in-excel |
https://www.customguide.com/images/pages/excel/zoom-in-excel.png |
Vista de una Hoja de Cálculo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.02 |
Multiple Windows |
How to Work with Multiple Windows in Excel |
Multiple Windows |
https://www.customguide.com/excel/opening-two-excel-window |
https://www.customguide.com/images/pages/excel/opening-two-excel-window.png |
Múltiples Ventanas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.03 |
Move and Copy Worksheets |
How to Move and Copy Worksheets in Excel |
Move and Copy Worksheets |
https://www.customguide.com/excel/how-to-copy-a-sheet-in-excel |
https://www.customguide.com/images/pages/excel/how-to-copy-a-sheet-in-excel.png |
Mover y Copiar Hojas de Cálculo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.04 |
Insert, Rename, and Delete Worksheets |
How to Insert, Rename, and Delete Worksheets in Excel |
Insert, Rename, and Delete Worksheets |
https://www.customguide.com/excel/how-to-delete-a-sheet-in-excel |
https://www.customguide.com/images/pages/excel/how-to-delete-a-sheet-in-excel.png |
Insertar, Eliminar, y Cambio de Nombre |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.05 |
Freeze Rows and Columns |
How to Freeze Rows and Columns in Excel |
Freeze Rows and Columns |
https://www.customguide.com/excel/how-to-freeze-a-row-in-excel |
https://www.customguide.com/images/pages/excel/how-to-freeze-a-row-in-excel.png |
Inmovilizar Filas y Columnas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6.06 |
Hide Worksheets and Gridlines |
How to Hide Worksheets and Gridlines in Excel |
Hide Worksheets and Gridlines |
https://www.customguide.com/excel/how-to-remove-gridlines-in-excel |
https://www.customguide.com/images/pages/excel/how-to-remove-gridlines-in-excel.png |
Ocultar Hojas de Cálculo y Cuadrículas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.00 |
Charts |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.01 |
Create Charts |
How to Create Charts in Excel |
Create Charts |
https://www.customguide.com/excel/how-to-make-a-graph-in-excel |
https://www.customguide.com/images/pages/excel/how-to-make-a-graph-in-excel.png |
Crear Gráficos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.02 |
Move and Resize |
How to Move and Resize a Chart in Excel |
Move and Resize |
https://www.customguide.com/excel/how-to-resize-a-chart-in-excel |
https://www.customguide.com/images/pages/excel/how-to-resize-a-chart-in-excel.png |
Mover y Cambiar Tamaño |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.03 |
Chart Types |
How to Change Chart Types in Excel |
Chart Types |
https://www.customguide.com/excel/types-of-charts-in-excel |
https://www.customguide.com/images/pages/excel/types-of-charts-in-excel.png |
Tipos de Gráfico |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.04 |
Layout and Style |
How to Apply Chart Layouts and Styles in Excel |
Layout and Style |
https://www.customguide.com/excel/change-chart-style-in-excel |
https://www.customguide.com/images/pages/excel/change-chart-style-in-excel.png |
Diseño y Estilo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.05 |
Titles and Legends |
How to Customize Chart Titles and Legends in Excel |
Titles and Legends |
https://www.customguide.com/excel/how-to-edit-legend-in-excel |
https://www.customguide.com/images/pages/excel/how-to-edit-legend-in-excel.png |
Títulos y Leyendas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.06 |
Gridlines, Labels, and Data Tables |
How to Display Chart Gridlines, Labels, and Data Tables in Excel |
Gridlines, Labels, and Data Tables |
https://www.customguide.com/excel/how-to-add-axis-labels-in-excel |
https://www.customguide.com/images/pages/excel/how-to-add-axis-labels-in-excel.png |
Cuadrículas, Etiquetas, y Datos de un Gráfico |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.07 |
Chart Elements |
How to Format Chart Data in Excel |
Chart Elements |
https://www.customguide.com/excel/chart-elements-excel |
https://www.customguide.com/images/pages/excel/chart-elements-excel.png |
Elementos de Gráfico |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.08 |
Modify Chart Data |
How to Modify Chart Data in Excel |
Modify Chart Data |
https://www.customguide.com/excel/excel-chart-data-range |
https://www.customguide.com/images/pages/excel/excel-chart-data-range.png |
Modificar Datos de Gráfico |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.09 |
Filter Charts |
How to Filter Charts in Excel |
Filter Charts |
https://www.customguide.com/excel/chart-filters-excel |
https://www.customguide.com/images/pages/excel/chart-filters-excel.png |
Filtrar Gráficos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.10 |
Trendlines |
How to Add Trendlines in Excel |
Trendlines |
https://www.customguide.com/excel/how-to-add-trendline-in-excel |
https://www.customguide.com/images/pages/excel/how-to-add-trendline-in-excel.png |
Líneas de Tendencia |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.11 |
Dual-Axis Charts |
How to Create Dual-Axis Charts in Excel |
Dual-Axis Charts |
https://www.customguide.com/excel/add-secondary-axis-excel |
https://www.customguide.com/images/pages/excel/add-secondary-axis-excel.png |
Gráficos de Doble Eje |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.12 |
Chart Templates |
How to Create Chart Templates in Excel |
Chart Templates |
https://www.customguide.com/excel/excel-chart-templates |
https://www.customguide.com/images/pages/excel/excel-chart-templates.png |
Plantillas de Gráfico |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 7.13 |
Sparklines |
How to Add Sparklines in Excel |
Sparklines |
https://www.customguide.com/excel/excel-sparklines |
https://www.customguide.com/images/pages/excel/excel-sparklines.png |
Minigráficos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.00 |
Print and Distribute |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.01 |
Page Size and Scale |
How to Adjust Page Size and Scale in Excel |
Page Size and Scale |
https://www.customguide.com/excel/excel-print-on-one-page |
https://www.customguide.com/images/pages/excel/excel-print-on-one-page.png |
Tamaño de Página y Escala |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.02 |
Print Area and Page Breaks |
How to Set Print Area and Page Breaks in Excel |
Print Area and Page Breaks |
https://www.customguide.com/excel/how-to-set-print-area-in-excel |
https://www.customguide.com/images/pages/excel/how-to-set-print-area-in-excel.png |
Área de Impresión y Saltos de Página |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.03 |
Print Titles, Gridlines, and Headings |
How to Print Titles, Gridlines, and Headings in Excel |
Print Titles, Gridlines, and Headings |
https://www.customguide.com/excel/how-to-print-gridlines-in-excel |
https://www.customguide.com/images/pages/excel/how-to-print-gridlines-in-excel.png |
Títulos de Impresión y Encabezados |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.04 |
Headers and Footers |
How to Add Headers and Footers in Excel |
Headers and Footers |
https://www.customguide.com/excel/excel-header |
https://www.customguide.com/images/pages/excel/excel-header.png |
Encabezados y Pies de Página |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.05 |
Margins and Orientation |
How to Adjust Margins and Orientation in Excel |
Margins and Orientation |
https://www.customguide.com/excel/change-page-margins-in-excel |
https://www.customguide.com/images/pages/excel/change-page-margins-in-excel.png |
Márgenes y Orientación |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 8.06 |
Inspect for Issues |
How to Inspect for Issues in Excel |
Inspect for Issues |
https://www.customguide.com/excel/how-to-inspect-document-for-issues-in-excel |
https://www.customguide.com/images/pages/excel/how-to-inspect-document-for-issues-in-excel.png |
Inspeccionar Problemas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.00 |
Intermediate Formulas |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.01 |
Reference External Worksheets |
How to Reference External Worksheets in Excel |
Reference External Worksheets |
https://www.customguide.com/excel/excel-reference-another-sheet |
https://www.customguide.com/images/pages/excel/excel-reference-another-sheet.png |
Referenciar Hojas de Cálculo Externas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.02 |
Absolute and Relative References |
How to use Absolute and Relative References in Excel |
Absolute and Relative References |
https://www.customguide.com/excel/absolute-reference-excel |
https://www.customguide.com/images/pages/excel/absolute-reference-excel.png |
Referencias Absolutas y Relativas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.03 |
Order of Operations |
Order of Operations in Excel |
Order of Operations |
https://www.customguide.com/excel/excel-order-of-operations |
https://www.customguide.com/images/pages/excel/excel-order-of-operations.png |
Orden de Operaciones |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.04 |
Cell and Range Names |
How to Add Cell and Range Names in Excel |
Cell and Range Names |
https://www.customguide.com/excel/excel-named-range |
https://www.customguide.com/images/pages/excel/excel-named-range.png |
Nombres de Celda y Rango |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.05 |
Insert Functions |
How to Insert Functions in Excel |
Insert Functions |
https://www.customguide.com/excel/insert-function-in-excel |
https://www.customguide.com/images/pages/excel/insert-function-in-excel.png |
Insertar Funciones |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.06 |
CONCAT Function |
How to Use the CONCAT Function in Excel |
CONCAT Function |
https://www.customguide.com/excel/concatenate-excel |
https://www.customguide.com/images/pages/excel/concatenate-excel.png |
Función CONCATENAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.07 |
PMT and NPER Functions |
How to Use the PMT Function in Excel |
PMT and NPER Functions |
https://www.customguide.com/excel/pmt-function-excel |
https://www.customguide.com/images/pages/excel/pmt-function-excel.png |
Función PAGO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.08 |
Display Formulas |
How to Display Formulas in Excel |
Display Formulas |
https://www.customguide.com/excel/how-to-show-formulas-in-excel |
https://www.customguide.com/images/pages/excel/how-to-show-formulas-in-excel.png |
Mostrar Fórmulas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9.09 |
Date Formulas |
How to Use Date Formulas in Excel |
Date Formulas |
https://www.customguide.com/excel/excel-date-functions |
https://www.customguide.com/images/pages/excel/excel-date-functions.png |
Fórmulas de Fecha |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10.00 |
Manage Data |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10.01 |
Quick Analysis |
The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline. |
Quick Analysis |
https://www.customguide.com/excel/quick-analysis-tool-excel |
https://www.customguide.com/images/pages/excel/quick-analysis-tool-excel.png |
Análisis Rápido |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10.02 |
Outline and Subtotal |
How to Use the Outline and Subtotal Features in Excel |
Outline and Subtotal |
https://www.customguide.com/excel/excel-subtotal |
https://www.customguide.com/images/pages/excel/excel-subtotal.png |
Esquema y Subtotal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10.03 |
Data Validation |
How to Use Data Validation Rules in Excel |
Data Validation |
https://www.customguide.com/excel/data-validation-excel |
https://www.customguide.com/images/pages/excel/data-validation-excel.png |
Validación de Datos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10.04 |
Flash Fill |
How to Use Flash Fill in Excel |
Flash Fill |
https://www.customguide.com/excel/flash-fill-excel |
https://www.customguide.com/images/pages/excel/flash-fill-excel.png |
Relleno Rápido |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10.05 |
Import and Export Data |
How to Import and Export Excel Data |
Import and Export Data |
https://www.customguide.com/excel/how-to-import-data-into-excel |
https://www.customguide.com/images/pages/excel/how-to-import-data-into-excel.png |
Importar y Exportar Datos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.00 |
Tables |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.01 |
Insert a Table |
How to Insert a Table in Excel |
Insert a Table |
https://www.customguide.com/excel/how-to-make-a-table-in-excel |
https://www.customguide.com/images/pages/excel/how-to-make-a-table-in-excel.png |
Insertar una Tabla |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.02 |
Sort Data |
How to Sort Data in Excel |
Sort Data |
https://www.customguide.com/excel/how-to-sort-in-excel |
https://www.customguide.com/images/pages/excel/how-to-sort-in-excel.png |
Ordenar Datos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.03 |
Filter Data |
How to Filter Data in Excel |
Filter Data |
https://www.customguide.com/excel/how-to-filter-in-excel |
https://www.customguide.com/images/pages/excel/how-to-filter-in-excel.png |
Filtrar Datos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.04 |
Add Rows and Columns |
How to Add Rows and Columns to Excel Tables |
Add Rows and Columns |
https://www.customguide.com/excel/how-to-add-a-column-to-a-table-in-excel |
https://www.customguide.com/images/pages/excel/how-to-add-a-column-to-a-table-in-excel.png |
Agregar Filas y Columnas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.05 |
Table Styles |
How to Apply Table Styles in Excel |
Table Styles |
https://www.customguide.com/excel/excel-format-as-table |
https://www.customguide.com/images/pages/excel/excel-format-as-table.png |
Estilos de Tabla |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.06 |
Remove Duplicates |
How to Remove Duplicates in Excel |
Remove Duplicates |
https://www.customguide.com/excel/excel-remove-duplicates |
https://www.customguide.com/images/pages/excel/excel-remove-duplicates.png |
Quitar Duplicados |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.07 |
Slicers |
How to Use Slicers in Excel |
Slicers |
https://www.customguide.com/excel/excel-slicer |
https://www.customguide.com/images/pages/excel/excel-slicer.png |
Segmentación de Datos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11.08 |
Structured References |
How to Use Structured References in Excel |
Structured References |
https://www.customguide.com/excel/excel-structured-reference |
https://www.customguide.com/images/pages/excel/excel-structured-reference.png |
Referencias Estructuradas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12.00 |
Intermediate Formatting |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12.01 |
Apply Conditional Formatting |
How to Apply Conditional Formatting in Excel |
Apply Conditional Formatting |
https://www.customguide.com/excel/excel-conditional-formatting |
https://www.customguide.com/images/pages/excel/excel-conditional-formatting.png |
Aplicar Formato Condicional |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12.02 |
Apply and Remove Cell Styles |
How to Apply and Remove Cell Styles in Excel |
Apply and Remove Cell Styles |
https://www.customguide.com/excel/cell-styles-in-excel |
https://www.customguide.com/images/pages/excel/cell-styles-in-excel.png |
Aplicar y Eliminar Estilos de Celda |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12.03 |
Create and Modify Cell Styles |
How to Create and Modify Cell Styles in Excel |
Create and Modify Cell Styles |
https://www.customguide.com/excel/create-a-new-style-in-excel |
https://www.customguide.com/images/pages/excel/create-a-new-style-in-excel.png |
Crear y Modificar Estilos de Celda |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12.04 |
Find and Replace Formatting |
How to Find and Replace Formatting in Excel |
Find and Replace Formatting |
https://www.customguide.com/excel/find-and-replace-formatting-in-excel |
https://www.customguide.com/images/pages/excel/find-and-replace-formatting-in-excel.png |
Buscar y Reemplazar Formato |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12.05 |
Apply a Theme |
How to Apply a Theme in Excel |
Apply a Theme |
https://www.customguide.com/excel/how-to-change-theme-in-excel |
https://www.customguide.com/images/pages/excel/how-to-change-theme-in-excel.png |
Aplicar un Tema |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.00 |
Collaboration |
Intermediate Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.01 |
Cell Comments |
How to Add, Edit, and Delete Cell Comments in Excel |
Cell Comments |
https://www.customguide.com/excel/insert-comment-in-excel |
https://www.customguide.com/images/pages/excel/insert-comment-in-excel.png |
Comentarios de Celda |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.02 |
Share Workbooks |
How to Share Workbooks in Excel |
Share Workbooks |
https://www.customguide.com/excel/share-excel-workbook |
https://www.customguide.com/images/pages/excel/share-excel-workbook.png |
Compartir Libros de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.03 |
Co-author Workbooks |
How to Co-author Workbooks in Excel |
Co-author Workbooks |
https://www.customguide.com/excel/excel-collaboration |
https://www.customguide.com/images/pages/excel/excel-collaboration.png |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.04 |
Version History |
How to Use Version History in Excel |
Version History |
https://www.customguide.com/excel/restore-previous-version-of-excel-file |
https://www.customguide.com/images/pages/excel/restore-previous-version-of-excel-file.png |
Administrar Versiones de un Libro de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.05 |
Protect a Worksheet |
How to Protect a Worksheet in Excel |
Protect a Worksheet |
https://www.customguide.com/excel/how-to-lock-cells-in-excel |
https://www.customguide.com/images/pages/excel/how-to-lock-cells-in-excel.png |
Proteger una Hoja de Cálculo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.06 |
Protect Workbook Structure |
How to Protect a Workbook's Structure in Excel |
Protect Workbook Structure |
https://www.customguide.com/excel/protect-excel-workbook |
https://www.customguide.com/images/pages/excel/protect-excel-workbook.png |
Proteger la Estructura de un Libro de Trabajo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13.07 |
Password Protection |
How to Add Password Protection in Excel |
Password Protection |
https://www.customguide.com/excel/password-protect-excel |
https://www.customguide.com/images/pages/excel/password-protect-excel.png |
Proteger con Contraseña |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.00 |
PivotTables |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.01 |
Create PivotTables |
How to Create PivotTables in Excel |
Create PivotTables |
https://www.customguide.com/excel/pivot-table-excel |
https://www.customguide.com/images/pages/excel/pivot-table-excel.png |
Crear Tablas Dinámicas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.02 |
Add Multiple PivotTable Fields |
How to Add Multiple PivotTable Fields to a PivotTable in Excel |
Add Multiple PivotTable Fields |
https://www.customguide.com/excel/pivot-table-multiple-columns |
https://www.customguide.com/images/pages/excel/pivot-table-multiple-columns.png |
Agregar Múltiples Campos de Tablas Dinámicas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.03 |
Change a PivotTable's Calculation |
How to Change a PivotTable's Calculation in Excel |
Change a PivotTable's Calculation |
https://www.customguide.com/excel/how-to-change-a-pivot-table-calculation |
https://www.customguide.com/images/pages/excel/how-to-change-a-pivot-table-calculation.png |
Cambiar el Cálculo de una Tabla Dinámica |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.04 |
Add Calculated Fields |
How to Add and Remove Calculated Fields in Excel PivotTables |
Add Calculated Fields |
https://www.customguide.com/excel/pivot-table-calculated-field |
https://www.customguide.com/images/pages/excel/pivot-table-calculated-field.png |
Agregar Campos Calculados |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.05 |
The GETPIVOTDATA Function |
How to Use the GETPIVOTDATA Function in Excel |
The GETPIVOTDATA Function |
https://www.customguide.com/excel/getpivotdata |
https://www.customguide.com/images/pages/excel/getpivotdata.png |
La Función IMPORTARDATOSDINAMICOS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.06 |
Filter PivotTables |
How to Filter PivotTables in Excel |
Filter PivotTables |
https://www.customguide.com/excel/pivot-table-filter |
https://www.customguide.com/images/pages/excel/pivot-table-filter.png |
Filtrar Tablas Dinámicas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.07 |
Timelines |
How to Add a Timeline in Excel |
Timelines |
https://www.customguide.com/excel/pivot-table-timeline |
https://www.customguide.com/images/pages/excel/pivot-table-timeline.png |
Escalas de Tiempo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.08 |
PivotTable Layout |
Adjust a PivotTable's Layout in Excel |
PivotTable Layout |
https://www.customguide.com/excel/pivot-table-layout |
https://www.customguide.com/images/pages/excel/pivot-table-layout.png |
Diseño de Tabla Dinámica |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.09 |
Group Values |
How to Group Values in Excel |
Group Values |
https://www.customguide.com/excel/pivot-table-grouping |
https://www.customguide.com/images/pages/excel/pivot-table-grouping.png |
Agrupar Valores |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.10 |
Refresh a PivotTable |
How to Refresh a PivotTable in Excel |
Refresh a PivotTable |
https://www.customguide.com/excel/refresh-pivot-table |
https://www.customguide.com/images/pages/excel/refresh-pivot-table.png |
Actualizar una Tabla Dinámica |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 14.11 |
Format a PivotTable |
How to Format a PivotTable in Excel |
Format a PivotTable |
https://www.customguide.com/excel/pivot-table-formatting |
https://www.customguide.com/images/pages/excel/pivot-table-formatting.png |
Formato a Tablas Dinámicas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 15.00 |
PivotCharts |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 15.01 |
Create PivotCharts |
How to Create PivotCharts in Excel |
Create PivotCharts |
https://www.customguide.com/excel/pivot-chart |
https://www.customguide.com/images/pages/excel/pivot-chart.png |
Crear Gráficos Dinámicos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 15.02 |
PivotChart Options |
PivotChart Options in Excel |
PivotChart Options |
https://www.customguide.com/excel/refresh-pivot-chart |
https://www.customguide.com/images/pages/excel/refresh-pivot-chart.png |
Opciones de Gráficos Dinámicos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 15.03 |
PivotChart Styles |
How to Apply PivotChart Styles in Excel |
PivotChart Styles |
https://www.customguide.com/excel/pivot-chart-styles |
https://www.customguide.com/images/pages/excel/pivot-chart-styles.png |
Estilos de Gráficos Dinámicos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 15.04 |
Drill-Down Data |
How to Drill-Down Chart Data in Excel |
Drill-Down Data |
https://www.customguide.com/excel/excel-pivot-chart-drill-down |
https://www.customguide.com/images/pages/excel/excel-pivot-chart-drill-down.png |
Explorar Datos a Profundidad |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 16.00 |
Troubleshoot Formulas |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 16.01 |
Formula Errors |
How to Fix Formula Errors in Excel |
Formula Errors |
https://www.customguide.com/excel/excel-formula-error |
https://www.customguide.com/images/pages/excel/excel-formula-error.png |
Errores de Fórmula |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 16.02 |
The Watch Window |
How to The Watch Window in Excel |
The Watch Window |
https://www.customguide.com/excel/watch-window-excel |
https://www.customguide.com/images/pages/excel/watch-window-excel.png |
La Ventana Inspección |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 16.03 |
Evaluate Formulas |
How to Evaluate Formulas in Excel |
Evaluate Formulas |
https://www.customguide.com/excel/evaluate-formula-excel |
https://www.customguide.com/images/pages/excel/evaluate-formula-excel.png |
Evaluar Fórmulas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.00 |
Advanced Formatting |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.01 |
Customize Conditional Formatting |
How to Customize Conditional Formatting in Excel |
Customize Conditional Formatting |
https://www.customguide.com/excel/custom-conditional-formatting |
https://www.customguide.com/images/pages/excel/custom-conditional-formatting.png |
Personalizar el Formato Condicional |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.02 |
Conditional Formatting with Formulas |
How to Use Conditional Formatting with Formulas in Excel |
Conditional Formatting with Formulas |
https://www.customguide.com/excel/excel-conditional-formatting-formula |
https://www.customguide.com/images/pages/excel/excel-conditional-formatting-formula.png |
Formato Condicional con Fórmulas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.03 |
Manage Conditional Formatting |
How to Manage Conditional Formatting in Excel |
Manage Conditional Formatting |
https://www.customguide.com/excel/how-to-edit-conditional-formatting-in-excel |
https://www.customguide.com/images/pages/excel/how-to-edit-conditional-formatting-in-excel.png |
Administrar Formato Condicional |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.04 |
International Currency and Formats |
How to Use International Currency and Formats in Excel |
International Currency and Formats |
https://www.customguide.com/excel/excel-international |
https://www.customguide.com/images/pages/excel/excel-international.png |
Monedas y Formatos Internacionales |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.05 |
Body and Heading Options |
How to Apply Body and Heading Font Options in Excel |
Body and Heading Options |
https://www.customguide.com/excel/excel-set-theme-font |
https://www.customguide.com/images/pages/excel/excel-set-theme-font.png |
Opciones de Cuerpo y Encabezado |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.06 |
Color Formats |
How to Create and Apply Color Schemes in Excel |
Color Formats |
https://www.customguide.com/excel/excel-color-scheme |
https://www.customguide.com/images/pages/excel/excel-color-scheme.png |
Formatos de Color |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.07 |
Custom Themes |
How to Create and Apply Custom Themes in Excel |
Custom Themes |
https://www.customguide.com/excel/excel-themes |
https://www.customguide.com/images/pages/excel/excel-themes.png |
Temas Personalizados |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.08 |
Form Controls |
How to Form Controls in Excel |
Form Controls |
https://www.customguide.com/excel/excel-forms |
https://www.customguide.com/images/pages/excel/excel-forms.png |
Controles de Formulario |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 17.09 |
Save Form Templates |
How to Save a Form as a Template in Excel |
Save Form Templates |
https://www.customguide.com/excel/excel-forms-template |
https://www.customguide.com/images/pages/excel/excel-forms-template.png |
Guardar Plantillas de Formulario |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.00 |
Advanced Formulas |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.01 |
IF Function |
How to Use the IF Function in Excel |
IF Function |
https://www.customguide.com/excel/if-function-excel |
https://www.customguide.com/images/pages/excel/if-function-excel.png |
Función SI |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.02 |
Nested Functions |
How to Insert Nested Functions in Excel |
Nested Functions |
https://www.customguide.com/excel/nested-function-excel |
https://www.customguide.com/images/pages/excel/nested-function-excel.png |
Funciones SUMAR.SI, PROMEDIO.SI, y CONTAR.SI |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.03 |
AND, OR, and NOT Functions |
How to use AND, OR, and NOT Functions in Excel |
AND, OR, and NOT Functions |
https://www.customguide.com/excel/excel-or-function |
https://www.customguide.com/images/pages/excel/excel-or-function.png |
Funciones Y, O, y NO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.04 |
SUMIF, AVERAGEIF, and COUNTIF Functions |
How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel |
SUMIF, AVERAGEIF, and COUNTIF Functions |
https://www.customguide.com/excel/excel-sumif |
https://www.customguide.com/images/pages/excel/excel-sumif.png |
Funciones Anidadas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.05 |
VLOOKUP |
How to Use the VLOOKUP Function in Excel |
VLOOKUP |
https://www.customguide.com/excel/vlookup |
https://www.customguide.com/images/pages/excel/vlookup.png |
BUSCARV |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.06 |
HLOOKUP |
How to Use HLOOKUP in Excel |
HLOOKUP |
https://www.customguide.com/excel/hlookup |
https://www.customguide.com/images/pages/excel/hlookup.png |
BUSCARH |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.07 |
INDEX and MATCH |
How to Use the INDEX and MATCH Functions in Excel |
INDEX and MATCH |
https://www.customguide.com/excel/excel-index-match |
https://www.customguide.com/images/pages/excel/excel-index-match.png |
ÍNDICE y COINCIDIR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.08 |
UPPER, LOWER, and PROPER |
How to Use UPPER, LOWER, and PROPER Functions in Excel |
UPPER, LOWER, and PROPER |
https://www.customguide.com/excel/change-case-in-excel |
https://www.customguide.com/images/pages/excel/change-case-in-excel.png |
DERECHA, IZQUIERDA, y EXTRAE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.09 |
RIGHT, LEFT, and MID |
How to Use RIGHT, LEFT, and MID Functions in Excel |
RIGHT, LEFT, and MID |
https://www.customguide.com/excel/excel-left-function |
https://www.customguide.com/images/pages/excel/excel-left-function.png |
MAYUSC, MINUSC, y NOMPROPIO |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 18.10 |
Formula Calculation Options |
How to Change Formula Calculation Options in Excel |
Formula Calculation Options |
https://www.customguide.com/excel/excel-auto-calculate |
https://www.customguide.com/images/pages/excel/excel-auto-calculate.png |
Opciones de Cálculo de Fórmulas |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 19.00 |
Analyze Data |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 19.01 |
Goal Seek |
How to Use Goal Seek in Excel |
Goal Seek |
https://www.customguide.com/excel/goal-seek-excel |
https://www.customguide.com/images/pages/excel/goal-seek-excel.png |
Buscar Objetivo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 19.02 |
Scenario Manager |
How Use to Scenario Manager in Excel |
Scenario Manager |
https://www.customguide.com/excel/scenario-manager-excel |
https://www.customguide.com/images/pages/excel/scenario-manager-excel.png |
Administrador de Escenarios |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 19.03 |
Consolidate Data |
How to Consolidate Data in Excel |
Consolidate Data |
https://www.customguide.com/excel/excel-consolidate |
https://www.customguide.com/images/pages/excel/excel-consolidate.png |
Consolidar Datos |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 20.00 |
Macros |
Advanced Skills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 20.01 |
Enable Macros |
How to Enable Macros in Excel |
Enable Macros |
https://www.customguide.com/excel/how-to-enable-macros-in-excel |
https://www.customguide.com/images/pages/excel/how-to-enable-macros-in-excel.png |
Habilitar Macros |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 20.02 |
Create Macros |
How to Create Macros in Excel |
Create Macros |
https://www.customguide.com/excel/excel-macros |
https://www.customguide.com/images/pages/excel/excel-macros.png |
Crear Macros |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 20.03 |
Modify Macros |
How to Modify Macros in Excel |
Modify Macros |
https://www.customguide.com/excel/edit-macros-in-excel |
https://www.customguide.com/images/pages/excel/edit-macros-in-excel.png |
Modificar Macros |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 20.04 |
Copy Macros |
How to Copy Macros in Excel |
Copy Macros |
https://www.customguide.com/excel/export-excel-macro |
https://www.customguide.com/images/pages/excel/export-excel-macro.png |
Copiar Macros |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
