Excel Essentials: Create, Format, and Distribute Like a Pro!

سرفصل های دوره

Create, Format, and Distribute Workbooks with Confidence and Efficiency for Better Data Management!

1 - Start Here

1 -Introduction

2 -Exercise Files

2 - Creating and Managing Workbooks and Worksheets

1 -Creating Workbooks

2 -Adding a Worksheet to an Existing Workbook

3 -Copying and Moving a Worksheet

3 -Filters.xlsx

4 -Archived Orders.xlsx

4 -Importing Data From a Text Delimited File

4 -Orders.txt

5 -Monthly Profit.txt

5 - Section Review Creating and Managing Workbooks and Worksheets.html

5 - Test Your Skills Creating and Managing Workbooks and Worksheets.html

3 - Navigating in Workbooks and Worksheets

1 -Searching.xlsx

1 -Searching for Data

2 -Navigating a Named Cell.xlsx

2 -Navigating to a Named Cell, Range, or Element

3 -Hyperlinks.xlsx

3 -Inserting and Removing Hyperlinks

4 -Test Your Skills - Navigation.xlsx

4 - Section Review Navigating in Workbooks and Worksheets.html

4 - Test Your Skills Navigating in Workbooks and Worksheets.html

4 - Formatting Workbooks and Worksheets

1 -Changing Worksheet Tab Color

2 -Modifying the Page Setup

2 -Page Setup.xlsx

2 - Renaming Worksheets.html

3 -Inserting Columns and Rows.xlsx

3 -Inserting, and Deleting Columns and Rows

4 -Changing Workbook Themes

4 -Themes.xlsx

5 -Adjusting Row Height, and Column Width

6 -Inserting Headers, and Footers

7 -Test Your Skills - Formatting Workbooks and Worksheets.xlsx

7 - Section Review Formatting Workbooks and Worksheets.html

7 - Test Your Skills Formatting Workbooks and Worksheets.html

5 - Customizing Options and Views for Workbooks and Worksheets

1 -Hiding Columns and Rows.xlsx

1 -Hiding or Unhiding Columns and Rows

1 - Hiding or Unhiding Worksheets.html

2 -Customizing the Quick Access Toolbar

3 -Changing Workbook Views

4 -Changing Window Views

4 -Workbook Views.xlsx

5 -Changing Magnification

6 -Modifying Workbook Properties

7 -Test Your Skills - Customizing Options and Views for Workbooks and Worksheets.xlsx

7 - Displaying Formulas.html

7 - Section Review Customizing Options and Views for Workbooks and Worksheets.html

7 - Test Your Skills Customizing Options and Views for Workbooks and Worksheets.html

6 - Configuring Workbooks for Distribution

1 -Print Area.xlsx

1 -Setting Print Areas

2 -Printing All or Part of a Workbook

2 -Workbook Views.xlsx

3 -Setting the Print Scale

3 -Workbook Views.xlsx

4 -Repeating Row Column Headings.xlsx

4 -Repeating Row and Column Headings

5 -Inspecting Workbooks for Hidden Properties, Accessibility, and Compatibility

5 - Saving Workbooks as Other Formats.html

6 -Test Your Skills - Configuring Workbooks for Distribution.xlsx

6 - Section Review Configuring Workbooks for Distribution.html

6 - Test Your Skills Configuring Workbooks for Distribution.html

7 - Test Your Skills for Sections 2 - 6

1 -Test Your Skills - Sections 2 - 6.txt

1 -Test Your Skills - Sections 2 - 6.xlsx

1 - Test Your Skills.html

8 - Course Wrap Up

1 -Thank You & Next Steps

2 - [BONUS LECTURE].html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy