• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME

excel tips

how to calculate sum of squares in Excel

January 26, 2022 by mechanicaleng blog Leave a Comment

How to calculate sum of squares in Excel 7

Today, mechnicalengblog,com will introduce to you sum of squares function in Excel and how to use it. As you know, excel have many function, and you will have many ways to calculate sum of squares  in excel, but what is the best? How to calculate sum of squares in Excel? The formula to calculate sum […]

4 ways to break line in excel

November 28, 2021 by mechanicaleng blog Leave a Comment

break line in excel by format cells

Today, mechanicalengblog.com will show to you 4 ways to break line in excel. Sometimes, you need to get a line break to align your content in a cell. Do you know how to fit the line in a cell? 1. Break line in excel by Alt + enter. To start new line of text or […]

How to fix excel cannot open a file error

November 28, 2021 by mechanicaleng blog Leave a Comment

fix excel can not open _ open and repair option

Today, mechanicalengblog.com will guide to you 4 ways to fix excel error cannot open excel file. In this post, you will know the reasons of error and how to fix it. Have you seen this word: “Excel cannot open the file because the extension is not valid” . Sometimes, we have seen the text “Excel […]

4 ways to reduce excel size

November 27, 2021 by mechanicaleng blog Leave a Comment

reduce size in excel _compress pictures in excel

In this post, I will guide to you 4 ways to reduce excel size. You will know the reason of heavy and how to improve it. You can reduce excel file by compress images file, remove conditional formatting, Remove formatting from empty rows and columns, save as your excel file to Excel Binary Workbook. How […]

How to insert data in excel

October 15, 2021 by mechanicaleng blog Leave a Comment

insert number in excel1

In this tutorial, I will guide to you how to insert data in excel? You can insert text, numeric value or formulas in excel. How many characters can we insert in excel? We can insert maximum  32000 characters into an excel cell. How to insert data in excel ? For inserting data in Ms excel, […]

How to count and color blank cells in excel

March 4, 2021 by mechanicaleng blog Leave a Comment

How to count blank cells in excel

If your task is to get Excel count and color blank cells in your worksheet, read this article to find the way to accomplish it. Learn how to count empty cells with Count Blank in Excel 2016,2013,2010,2019. I. How to count blank cells in excel? Step 1: Open the spreadsheet in Excel. Step 2: Use […]

Next Page »

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in