KING OF EXCEL: Atlas Excel

Showing posts with label Atlas Excel. Show all posts

Thursday, December 19, 2019

Finding the Position of the First Integer in an Alphanumeric String

KingExcel.info December 19, 2019

Finding the Position of the First Integer in an Alphanumeric String When you are faced with alphanumeric strings, such as those esoteric-loo...

Putting a Date on One Line and Time on Another Line in the Same Cell

KingExcel.info December 19, 2019

Putting a Date on One Line and Time on Another Line in the Same Cell Here’s a tip to place the date and time in the same cell, in separate l...

Wednesday, December 18, 2019

Atlas Excel

Doing Date Math on Text (non real) Dates

KingExcel.info December 18, 2019

Doing Date Math on Text (non real) Dates In yesterday’s tutorial , I showed how to place a date and time on separate lines in the same cell...

Atlas Excel

Using VLOOKUP With MIN, MAX, and AVERAGE

KingExcel.info December 18, 2019

Using VLOOKUP With MIN, MAX, and AVERAGE You can nest a function as the lookup_value argument with VLOOKUP , to return an item relating t...

Atlas Excel

Rounding Numbers By Fractions or Decimals

KingExcel.info December 18, 2019

Rounding Numbers By Fractions or Decimals When rounding numbers to a particular decimal factor, you can express that rounding factor in your...

Tuesday, December 17, 2019

Atlas Excel

Opening Excel in a New Instance

KingExcel.info December 17, 2019

Opening Excel in a New Instance In Excel versions 2013 and later, new workbooks open in the same instance of Excel. Here are 2 options to op...

Monday, December 16, 2019

Atlas Excel

Reverse Lookup For Times in Milliseconds

KingExcel.info December 16, 2019

Reverse Lookup For Times in Milliseconds You can format, analyze, and lookup (in this example, reverse VLOOKUP with CHOOSE) times measured i...

Atlas Excel

Copying Only a PivotTable’s PivotField to Another Worksheet

KingExcel.info December 16, 2019

Copying Only a PivotTable’s PivotField to Another Worksheet Here is how you can copy a specific pivot field and display its data on another ...

Atlas Excel

Using Label Headers as Intersecting Lookup Criteria

KingExcel.info December 16, 2019

Using Label Headers as Intersecting Lookup Criteria I previously posted this example of using the spacebar character as the mathematical o...

Saturday, December 14, 2019

Atlas Excel

Using Undo For Several Actions at Once

KingExcel.info December 14, 2019

Using Undo For Several Actions at Once You can Undo up to 100 previous actions on your workbook at the same time. Clicking the drop-down arr...

Crafted with by TemplatesYard

Pages

Thursday, December 19, 2019

Finding the Position of the First Integer in an Alphanumeric String

Putting a Date on One Line and Time on Another Line in the Same Cell

Wednesday, December 18, 2019

Doing Date Math on Text (non real) Dates

Using VLOOKUP With MIN, MAX, and AVERAGE

Rounding Numbers By Fractions or Decimals

Tuesday, December 17, 2019

Opening Excel in a New Instance

Monday, December 16, 2019

Reverse Lookup For Times in Milliseconds

Copying Only a PivotTable’s PivotField to Another Worksheet

Using Label Headers as Intersecting Lookup Criteria

Saturday, December 14, 2019

Using Undo For Several Actions at Once

Popular Posts

Popular Posts

Popular Posts

Total Pageviews

Search This Blog

Translate

Now

Public

Comments

Popular Posts

Kết nối với chúng tôi

Bài đăng phổ biến

Popular Posts

About me

Contact Form

Pages

Pages

Thursday, December 19, 2019

Wednesday, December 18, 2019

Tuesday, December 17, 2019

Monday, December 16, 2019

Saturday, December 14, 2019

Popular Posts

Popular Posts

Popular Posts

Socialize

Popular Posts

Total Pageviews

Search This Blog

Translate

Now

Public

Comments

Popular Posts

Kết nối với chúng tôi

Bài đăng phổ biến

Popular Posts

About me

Contact Form

Pages